Hi
I got a parquet file in my bucket i am trying to read using the select_object_content API.
client.select_object_content(
Bucket="bucket-name",
Key=file, #"path/file.parquet",
ExpressionType='SQL',
Expression=f'SELECT "Time" as t1, "col2" FROM s3object',
InputSerialization=input_spec,
OutputSerialization={'JSON': {}}
#ScanRange=scan_range
)
Here the column "Time" is TimestampType column. When i make the call what i get back in the response is
some long number that looks like this "45357758218963327341449984"
I am trying to understand what this number represent ? Is there way i can get back the column in iso-format. I initially thought this number is the byte representation that happens when the timestamp value is converted to a binary encoding represenation. But when i applied the logic mentioned
https://stackoverflow.com/questions/54657496/how-to-write-timestamp-logical-type-int96-to-parquet-using-parquetwriter
It didnt reproduce the value i expected.
Any help is appreciated.