Scalar data types
Every data value, like the value of an expression or a function parameter, has a data type. A data type is either a scalar data type, which is one of the built-in predefined types listed below, or a user-defined record, which is an ordered sequence of name and scalar-data-type pairs, like the data type of a row in a table.
Note
User-defined data types are not supported in Kusto.
Supported data types
The following data types are supported:
Type | Description |
---|---|
bool (boolean ) |
true (1 ) or false (0 ). |
datetime (date ) |
An instant in time, typically expressed as a date and time of day. |
decimal | A 128-bit wide, decimal number. |
dynamic | An array, a property bag, or a value of any of the other scalar data types. |
guid (uuid , uniqueid ) |
A 128-bit globally unique value. |
int | A signed, 32-bit wide, integer. |
long | A signed, 64-bit wide, integer. |
real (double ) |
A 64-bit wide, double-precision, floating-point number. |
string | A sequence of zero or more Unicode characters. |
timespan (time ) |
A time interval. |
Tip
To check the data type of a value, use the the gettype() function.
Null values
All nonstring data types can be null. When a value is null, it indicates an absence or mismatch of data. For example, if you try to input the string abc
into an integer column, it results in the null value. To check if an expression is null, use the isnull() function.
For more information, see Null values.
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om