search

microsoft / Kusto-Query-Language

Kusto Query Language is a simple and productive language for querying Big Data.
Apache License 2.0
510 stars 97 forks source link

Available Types: Kusto versus C# #86

Closed jodybrownell closed 1 year ago

jodybrownell commented 1 year ago

Hello, we are adding KQL dialect support to the Clickhouse database. C# has many types not supported in Kusto. After reviewing the difference between Kusto and C#, we wonder why some of the type support was not included and why some of the type support was removed after the initial releases.

In C#, types include

Screen Shot 2022-09-23 at 10 05 07 AM

In Kusto, types include

Screen Shot 2022-09-23 at 10 14 33 AM
mattwar commented 1 year ago

C# and Kusto are different languages, so there really should be no expectations that they share the same type system.

Kusto does have most of these same scalar types as C#, but many only as storage types (types that columns can be declared as). The query language only operates on the narrower set of types, and all column values are converted when accessed.

This library focuses on the Kusto language parser and intellisense. The scalar types declared here are the ones that are used to describe results of query expressions and so do not include any additional types that are used by the storage system.