Query Language Reference

Note

This Documentation includes the following third-party documentation from the Trino Software Foundation (formerly Presto Software Foundation) – https://trino.io/foundation.html8 (formerly https://prestosql.io/foundation.html). Licensed under the Apache License, Version 2.0 (the “License”); you may not may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0

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