Number/Integer INFER statement

SQL++
1

Hi, from the documentation of the INFER statement, I understand that both integer and number types are supported as the inferred type for some numeric field. However, running the INFER statement is always returning “number” for integer fields. Can you please check?
Example statement:
INFER default:travel-sample with { “sample_size”: 10, “num_sample_values”: 0 }

2

The documentation is misleading. I opend a ticket to have it fixed. JSON has only string, number, boolean and null primitive types.

Primitive and compound JSON data types | YugabyteDB Docs.

3

JSON. top level value types
number includes integer and float

1 Like