Skip to content

v22.8.1.1-clib
Compare
Choose a tag to compare
@ch-devops ch-devops released this 04 Aug 00:53
· 41044 commits to master since this release
v22.8.1.1-clib
68ba390

Release v22.8.1.1-clib
Image is published at icr.io/clickhouse/clickhouse:22.8.1.1-1-clib-ibm

KQL implemented features.

Augest 1, 2022

  • strcmp (https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/strcmpfunction)
    print strcmp('abc','ABC')

  • parse_url (https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/parseurlfunction)
    print Result = parse_url('scheme://username:[email protected]:1234/this/is/a/path?k1=v1&k2=v2#fragment')

  • parse_urlquery (https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/parseurlqueryfunction)
    print Result = parse_urlquery('k1=v1&k2=v2&k3=v3')

  • print operator (https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/printoperator)
    print x=1, s=strcat('Hello', ', ', 'World!')

  • The following functions now support arbitrary expressions as their argument:

  • Aggregate Functions:

  • make_list()
    Customers | summarize t = make_list(FirstName) by FirstName
    Customers | summarize t = make_list(FirstName, 10) by FirstName

  • make_list_if()
    Customers | summarize t = make_list_if(FirstName, Age > 10) by FirstName
    Customers | summarize t = make_list_if(FirstName, Age > 10, 10) by FirstName

  • make_list_with_nulls()
    Customers | summarize t = make_list_with_nulls(FirstName) by FirstName

  • make_set()
    Customers | summarize t = make_set(FirstName) by FirstName
    Customers | summarize t = make_set(FirstName, 10) by FirstName

  • make_set_if()
    Customers | summarize t = make_set_if(FirstName, Age > 10) by FirstName
    Customers | summarize t = make_set_if(FirstName, Age > 10, 10) by FirstName

  • Default dialect config setting for session and user:

  • Set dialect setting in server configuration XML at user level(users.xml). This sets the dialect at server startup and CH will do query parsing for all users with default profile acording to dialect value.

    For example:
    <profiles> <!-- Default settings. --> <default> <load_balancing>random</load_balancing> <dialect>kusto_auto</dialect> </default>

  • Query can be executed with HTTP client as below once dialect is set in users.xml
    echo "KQL query" | curl -sS "http://localhost:8123/?" --data-binary @-

  • To execute the query using clickhouse-client , Update clickhouse-client.xml as below and connect clickhouse-client with --config-file option (clickhouse-client --config-file=<config-file path>)

    <config> <dialect>kusto_auto</dialect> </config>

    OR
    pass dialect setting with '--'. For example :
    clickhouse-client --dialect='kusto_auto' -q "KQL query"

Assets 5
Loading