Query language reference

Note

This Query Language Reference includes the following third-party documentation from the Trino Software Foundation (formerly Presto Software Foundation), which is licensed under the Apache License, Version 2.0. You may not use this file except in compliance with this license. To get a copy of the Apache License, Version 2.0, see the Apache website.

Timestream supports a rich query language for working with your data. You can see the available data types, operators, functions and constructs below.

You can also get started right away with Timestream's Query Language in the Sample queries section.

Topics

• Supported data types
• Built-in time series functionality
• SQL support
• Logical operators
• Comparison operators
• Comparison functions
• Conditional expressions
• Conversion functions
• Mathematical operators
• Mathematical functions
• String operators
• String functions
• Array operators
• Array functions
• Regular expression functions
• Date / time operators
• Date / time functions
• Aggregate functions
• Window functions
• Sample queries