SQL Parameters

To pass parameters in query, ClickHouse parameter formatting must be used, in following form:

{<name>:<data type>}

Notes

SQL 'bind' parameters are passed as HTTP URI query parameters, so using too many of them may result in a "URL too long" exception. To insert large volume of records, consider using Bulk insertion functionality

Examples

SELECT {value:Array(UInt16)} as value

SELECT * FROM table WHERE val = {tuple_in_tuple:Tuple(UInt8, Tuple(String, UInt8))}

INSERT INTO table VALUES ({val1:Int32, val2:Array(UInt8)})