For similar capabilities to AWS IoT Analytics, explore Amazon Kinesis, Amazon S3, and Amazon Athena. These services provide additional scalability and flexibility to meet your evolving analytics requirements. Learn how
here
Supported SQL functionality in AWS IoT Analytics
Datasets are generated by using SQL expressions on data in a data store. The queries you
run in AWS IoT Analytics are based on Presto
0.217
Supported data types
AWS IoT Analytics and Amazon Athena support these data types.
-
primitive_type
-
TINYINT
-
SMALLINT
-
INT
-
BIGINT
-
BOOLEAN
-
DOUBLE
-
FLOAT
-
STRING
-
TIMESTAMP
-
DECIMAL(precision, scale)
-
DATE
-
CHAR
(fixed-length character data with a specified length) -
VARCHAR
(variable-length character data with a specified length)
-
-
array_type
-
ARRAY<data_type>
-
-
map_type
-
MAP<primitive_type, data_type>
-
-
struct_type
-
STRUCT<col_name:data_type[COMMENT col_comment][,...]>
-
Note
AWS IoT Analytics and Amazon Athena don't support some data types.
Supported functions
Amazon Athena and AWS IoT Analytics SQL functionality are based on Presto
0.217
-
Logical operators
-
Comparison functions and operators
-
Conditional expressions
-
Conversion functions
-
Mathematical functions and operators
-
Bitwise functions
-
Decimal functions and operators
-
String functions and operators
-
Binary functions
-
Date and time functions and operators
-
Regular expression functions
-
JSON functions and operators
-
URL functions
-
Aggregate functions
-
Window functions
-
Color functions
-
Array functions and operators
-
Map functions and operators
-
Lambda expressions and functions
-
Teradata functions
Note
AWS IoT Analytics and Amazon Athena don't support user-defined functions (UDFs or UDAFs) or stored procedures.