Contribute in GitHub:
Edit online
KQL compatibility
With our implementation of Kusto QL, there will be some gaps until we finish the initial release. Here we describe the differences, nuances or things to watch for in IBM KQL.
Type support
| Name | Description |
|---|---|
| dynamic | Only arrays of a single type, and with a maximum of two dimensions are currently supported. |
| string | Verbatim strings, like those starting with an @ sign are not supported. |
| datatable | Datatable as an input to table operators are currently not supported |
Operators
| Name | Description |
|---|---|
| in | Currently does not support sub-querying |
| !in | Currently does not support sub-querying |
| top-hitters | Currently does not support approximation algorithm Count-min sketch and is therefore not more efficient than a summarize operator |
| let | Currently does not support any let functionality. |
Functions
| Name | Description |
|---|---|
| dcount() | A synonym for count_distinct(). The second parameter is ignored. There is no support for HpperLogLog (HLL), or approximation at this point. |
| dcountif() | A synonym for count_distinctif(). The second parameter is ignored. There is no support for HLL, or approximation at this point |
| any() | Alias is deprecated, not supported. |
| anyif() | Alias is deprecated, not supported |
| pack() | Deprecated, see bag_pack() |
| pack_dictionary() | Deprecated, see bag_pack() |
IBM added functionality
Functions
| Name | Description |
|---|---|
| lookup() | like the operator, allows the resolution of reference data |