Defining the time column format

58 views
Skip to first unread message

Ali Altaf

unread,
Nov 10, 2016, 7:14:28 PM11/10/16
to airbnb_superset
Hi,

I am using presto as my backend and I have a table called event with a column ts_date which stores values in the presto DATE format. To query this field I have to say something like 

select * from event where ts_date = date '2016-11-09'

It seems like the time series views don't support this format out of the box. Do I have to provide some kind off transformation in my table settings to get this working?

Thanks!
Ali

Maxime Beauchemin

unread,
Nov 10, 2016, 7:41:51 PM11/10/16
to airbnb_superset
Thanks for reporting this. I just added support for this recently but it wasn't working for some reason. I just pushed a fix here:

It will be in the next release.

Max

Ali Altaf

unread,
Nov 10, 2016, 9:08:01 PM11/10/16
to Maxime Beauchemin, airbnb_superset
Awesome, I pulled the changes in and everything works great. Thanks for the quick responses!

--
You received this message because you are subscribed to a topic in the Google Groups "airbnb_superset" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/airbnb_superset/jZXXRCkiAFo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to airbnb_superset+unsubscribe@googlegroups.com.
To post to this group, send email to airbnb_superset@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/airbnb_superset/b83d3839-757a-45fb-92c0-a16112c20c32%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages