Due to the way data is structured in Timestream, in which each row contains a different measurement, for example, load, speed, fuel (taking the sample IOT database) it becomes not obvious how to query data for questions that take more than one measurement in mind.
Is it possible to query for items that share a value column? For example: For a given truck_id and time range, find out all records where the speed is higher than 40 and the load is less than 100?