Closed Bug 1301689 Opened 9 years ago Closed 8 years ago

Unexpected Dates in Presto Table usearch_daily

Categories

(Data Platform and Tools Graveyard :: Presto, defect, P2)

defect

Tracking

(Not tracked)

RESOLVED INVALID

People

(Reporter: emtwo, Unassigned)

References

Details

The following query in re:dash results in some strange dates from 1979-2099. It looks like it may be a bug: SELECT DATE_TRUNC('week', FROM_UNIXTIME(ts / (1000000000))) AS week, count(*) FROM usearch_daily GROUP BY 1 ORDER BY week
Depends on: 1301820
Priority: -- → P2
Component: Metrics: Pipeline → Presto
Product: Cloud Services → Data Platform and Tools
Marina, is this still relevant? Which data source contains the "usearch_daily" table?
Flags: needinfo?(msamuel)
O_O this is from 2 years ago. Just noticed now. I think we can call this irrelevant and close it.
Status: NEW → RESOLVED
Closed: 8 years ago
Flags: needinfo?(msamuel)
Resolution: --- → INVALID
Product: Data Platform and Tools → Data Platform and Tools Graveyard
You need to log in before you can comment on or make changes to this bug.