search

mozilla / fxa-activity-metrics

A server for managing the Firefox Accounts metrics database and pipeline
1 stars 3 forks source link

Querying Timestamp data issue #86

Closed Chiranjeeviv closed 7 years ago

Chiranjeeviv commented 7 years ago

Hi Everyone,

I am facing an issue querying data from a table by giving a condition on timestamp column, the query returning zero records, but able to see the record if I remove the condition and query with same timestamp value.

EX: select * from table1 where start_timestmp='2017-08-24 00:00:00'; -- returning 0 records even though the table contains the data with the same value.

The same query returning the records if I covert to text(start_timestmp::text='2017-08-24 00:00:00'). But the column datatype is defined as timestamp itself. Please find below.

start_timestamp TIMESTAMP NOT NULL ENCODE lzo

Is this the issue with LZO Encode?

Please let me know why it's behaving like this if anyone knows the reason.

Thanks !!

shane-tomlinson commented 7 years ago

@philbooth - can you triage this?

philbooth commented 7 years ago

Hey @Chiranjeeviv, not sure what the problem is but I doubt it is anything to do with the encoding. Might be worth reading the redshift docs on timestamps, to see if that helps:

http://docs.aws.amazon.com/redshift/latest/dg/r_Date_and_time_literals.html

Closing this issue as it has nothing to do with Firefox Accounts.