Temporal Function Issues

Doherty, Adam adam.doherty at esso.ca
Wed Jun 13 16:52:29 CEST 2018


Hello all:

I am trying to find the most efficient way to filter results for those matching today only.
My events table has 550 million rows and I want a view as follows-

CREATE VIEW events_today AS SELECT * FROM events WHERE str_to_date(timestamp_to_str(event_timestamp, '%Y-%m-%d'), '%Y-%m-%d') = CURRENT_DATE which should give me all events with today's date.

Running the SELECT by itself also never returns.

However, the query just hangs without ever returning.

I'm running 11.29.3 (Mar2018) on CentOS 7 with 128GB and 16 Cores.

Adam


More information about the users-list mailing list