When trying to execute a query that returns an interval an error is returned instead of data.
Example use case: Showing time since last update for a set of sensors
Example query: select measure_name, now() - max(time) as last_update from dbname."tablename" group by measure_name order by measure_name asc
Expected outcome: Table with two columns of results (as in AWS Timestream Console)
Actual outcome: Table with just one column and a message of unsupported data type: "Unsupported scalar value: INTERVAL_DAY_TO_SECOND". This seems to originate from file: parsers.go line: 60 where it is clear that Interval datatypes are not yet supported. An example of how seems to be present in the AWS Developer guide page 79 (https://docs.aws.amazon.com/timestream/latest/developerguide/timestream.pdf)
When trying to execute a query that returns an interval an error is returned instead of data.
Example use case: Showing time since last update for a set of sensors
Example query:
select measure_name, now() - max(time) as last_update from dbname."tablename" group by measure_name order by measure_name asc
Expected outcome: Table with two columns of results (as in AWS Timestream Console)
Actual outcome: Table with just one column and a message of unsupported data type: "Unsupported scalar value: INTERVAL_DAY_TO_SECOND". This seems to originate from file: parsers.go line: 60 where it is clear that Interval datatypes are not yet supported. An example of how seems to be present in the AWS Developer guide page 79 (https://docs.aws.amazon.com/timestream/latest/developerguide/timestream.pdf)