question

KamaljitPati-5045 avatar image
0 Votes"
KamaljitPati-5045 asked ·

Abnormal behaviour when inserting very large value in decimal column in azure data explorer

So I tried to ingest very large values in decimal column of azure data explorer, it succeeded. But then when I tried to fetch the rows it is showing empty. I ran the following queries :

.create table test_decimal_table(id:decimal)
.ingest inline into table test_decimal_table <| 99999999999999999999999999999999999999
test_decimal_table

So it is showing no rows. I mean if it is not allowed then it should have thrown an exception or something. But it is being successful and then it is not showing anything. And if I do this with some other data in the same column means like below :

.ingest inline into table test_decimal_table <| 99999999999999999999999999999999999999
.ingest inline into table test_decimal_table <| 23.67


Then if try to fetch the rows by running test_decimal_table command then

1 time it is showing only 23.67 and again it is showing no rows and again it is showing 1 row and again no rows. Does anyone has any idea about this.


azure-data-explorer
· 1
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

sloutsky avatar image
0 Votes"
sloutsky answered ·

When working with decimals, you should be using decimal() literals.
For example:

.create table test_decimal_table(id:decimal)
.set-or-append table test_decimal_table <| print id=decimal(1234)
.set-or-append table test_decimal_table <| print id=decimal(1234.567)
test_decimal_table

10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered ·

From my testing, the maximum ingested this way is
.ingest inline into table test_decimal_table <| 9999999999999999999999999999999999
That is 34 , 9's

10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.