For similar capabilities to Amazon Timestream for LiveAnalytics, consider Amazon Timestream for InfluxDB. It offers simplified data ingestion and single-digit millisecond query response times for real-time analytics. Learn more here.
The COALESCE statement
COALESCE returns the first non-null value in an argument list. The syntax is as follows:
coalesce(value1, value2[,...])