isNaN(x) Īccepts Float32 and Float64 and returns UInt8 equal to 1 if the argument is a NaN, otherwise 0. You can get similar result by using ternary operator: isFinite(x) ? x : y. Login of user, that initiated query, will be returned in case distibuted query. You can use this function in table engine parameters in a CREATE TABLE query where you need to specify the database. Returns the name of the current database.
You can specify an integer or a floating-point number. Sleeps ‘seconds’ seconds on each data block. However, the argument is still evaluated. ignore(…) Īccepts any arguments, including NULL. This function is for debugging this behavior.
Functions work differently for constant arguments and normal arguments (different code is executed), although the result is almost always the same. In ClickHouse, full columns and constants are represented differently in memory.
Turns a constant into a full column containing just one value.
0 kommentar(er)
