Skip to content
Advertisement

Tag: clickhouse

I am getting this error on inserting data in ClickHouse

Unknown error field: Code: 27. DB::ParsingException: Cannot parse input: expected ‘”‘ before: ’40”,”gmtoffset”:0,”open”:109.6,”high”:109.6,”low”:109.6,”close”:109.6,”volume”:0,”previousClose”:108.4,”change”:1.2,”change_p”:1.107}n’: (while reading the value of key timestamp): While executing JSONEachRowRowInputFormat: (at row 1). (CANNOT_PARSE_INPUT_ASSERTION_FAILED) (version 21.11.5.33 (official build))] Create table query is simple insert query: Answer The type of column ‘previousClose’ is ‘Int32’, but the value in realTime is the float type. I tried your problem with

How to parse a Clickhouse-SQL statement using ANTRL4?

Objective : Add an additional WHERE clause to any given Clickhouse statement. I’m using the following Antlr grammars to generate Java classes for a lexer & parser. Lexer grammar https://github.com/ClickHouse/ClickHouse/blob/master/utils/antlr/ClickHouseLexer.g4 Parser grammar https://github.com/ClickHouse/ClickHouse/blob/master/utils/antlr/ClickHouseParser.g4 Problem : I cannot figure out/understand how to interact or create the appropriate POJOs for use with the generated classes that Antlr produces. Example of statement Goal

Advertisement