August 2019
Intermediate to advanced
560 pages
13h 41m
English
Elasticsearch SQL almost inherits the data types from Elasticsearch. We list them as follows:
null, boolean, byte, short, integer, long, double, float, half_float, scaled_float, keyword, text, binary, datetime, ip, object, nested.
The datetime data type in Elasticsearch SQL is the same as date in Elasticsearch. The reason for the name change is that it is not equivalent to DATE in ANSI SQL. Other data types that are only supported in Elasticsearch SQL are as follows:
date, interval_year, interval_month, interval_day, interval_hour, interval_minute, interval_second, interval_year_to_month, interval_day_to_hour, interval_day_to_minute, interval_day_to_second, interval_hour_to_minute, interval_hour_to_second, interval_minute_to_second ...Read now
Unlock full access