Hi aws re:Post!
I used the AWS Timestream Web App Query Editor while developing my CDK IaC to test certain queries - specifically, I run the following and receive 1000 rows in response:
SELECT measure_value::varchar FROM DATABASE.TABLE ORDER BY time LIMIT 1000
However the same exact query sent in NodeJS via aws-sdk/TimestreamQuery
returns 0 rows in response. If I remove ORDER BY time
such that my query is:
SELECT measure_value::varchar FROM DATABASE.TABLE LIMIT 1000
the NodeJS Query client receives the same data as in the AWS Timestream Web App Query Editor. This is very bizarre behavior- I have not found any mention of it whatsoever in the context of AWS Timestream, and the only contextual results I found on the internet was MySQL Bug Report #70466 (accompanying stack overflow post).
This really does not seem like a software configuration issue - to reiterate, if I omit ORDER BY time
my NodeJS client behaves the same as my Web App client. Any insight on how to resolve this would be greatly appreciated!