Advanced partitioning

[wernerzirkel]

in the advanced partitioning, it is possible to use a certain column (e.g. device id) + a timestamp to define the partition key. As shown in the blog, device id is defined a string. From a database guy's perspective, it would be would be more natural to me to use integers here (can be internally tostring(device_id) of course).

[y0nil]

Hi @wernerzirkel, and thank you for the feedback!

In Kusto, string indices are generally more detailed and efficient than numeric ones.
Thus, if the purpose is to frequently filter on an ID column, and reach optimal performance, it'd be better to type that column as string.

Regardless, while there's no current support for partitioning on numeric columns, please feel free to submit this as a feature requests at https://aka.ms/adx.ideas.