arccosine arcsine # SQL_INFO_SQL_KEYWORDS # Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info absolute action add all allocate alter and any are as asc assertion at authorization avg begin between bit bit_length bitwise both by cascade cascaded case cast catalog char char_length character character_length check close coalesce collate collation column commit connect connection constraint constraints continue convert corresponding count create cross current current_date current_time current_timestamp current_user cursor date day deallocate dec decimal declare default deferrable deferred delete desc describe descriptor diagnostics disconnect distinct domain double drop else end end-exec escape except exception exec execute exists external extract false fetch first float for foreign found from full get global go goto grant group having hour identity immediate in indicator initially inner input insensitive insert int integer intersect interval into is isolation join key language last leading left level like local locf lower match max min minute module month names national natural nchar next no not null nullif numeric octet_length of on only open option or order outer output overlaps pad partial position precision prepare preserve primary prior privileges procedure public read real references relative restrict revoke right rollback rows schema scroll second section select session session_user set size smallint some space sql sqlcode sqlerror sqlstate substring sum system_user table temporary then time timestamp timezone_hour timezone_minute to trailing transaction translate translation trim true union unique unknown update upper usage user using value values varchar varying view when whenever where with work write year zone # SQL_INFO_NUMERIC_FUNCTIONS # Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info abs acos asin atan atan2 ceil cos exp floor ln log log10 log2 pow power round signum sin sqrt tan trunc # SQL_INFO_STRING_FUNCTIONS # Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info arrow_typeof ascii bit_length btrim char_length character_length chr concat concat_ws digest from_unixtime initcap left length lower lpad ltrim md5 octet_length random regexp_match regexp_replace repeat replace reverse right rpad rtrim sha224 sha256 sha384 sha512 split_part starts_with strpos substr to_hex translate trim upper uuid # SQL_INFO_DATE_TIME_FUNCTIONS # Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info current_date current_time date_bin date_part date_trunc datepart datetrunc from_unixtime now to_timestamp to_timestamp_micros to_timestamp_millis to_timestamp_seconds # SQL_DATE_TIME_KEYWORDS dow doy # SQL_INFO_SYSTEM_FUNCTIONS # Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info array arrow_typeof struct # is_scalar_math_function # Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/influxdb_influxql_parser/src/functions.rs abs sin cos tan asin acos acosh asinh atan atanh atan2 cbrt exp gcd isnan iszero lcm log ln log2 log10 nanvl sqrt pow floor ceil round # InfluxQL operators bitfield # is_aggregate_function # Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/influxdb_influxql_parser/src/functions.rs approx_distinct approx_median approx_percentile_cont approx_percentile_cont_with_weight covar cumulative_sum derivative difference elapsed moving_average non_negative_derivative non_negative_difference bottom first last max min percentile sample top count integral mean median mode spread stddev sum holt_winters holt_winters_with_fit chande_momentum_oscillator exponential_moving_average double_exponential_moving_average kaufmans_efficiency_ratio kaufmans_adaptive_moving_average triple_exponential_moving_average triple_exponential_derivative relative_strength_index