Leslie300 opened a new issue #4813: datetrunc is not suported
URL: https://github.com/apache/incubator-superset/issues/4813
   the time works nicely, but as soon as I am trying to adjust the time grain i 
get thrown this error.
   (psycopg2.ProgrammingError) function date_trunc("unknown", character 
varying) does not exist HINT: No function matches the given name and argument 
types. You may need to add explicit type casts. [SQL: "SELECT refferer AS 
refferer,\n DATE_TRUNC('week', real_time) AT TIME ZONE 'UTC' AS __timestamp,\n 
count(*) AS count\nFROM\n (SELECT count (event) as count,\n 
initial_referring_domain as refferer,\n real_time\n FROM metrics\n WHERE event 
= 'adventureView'\n group by initial_referring_domain,\n real_time\n limit 100) 
AS expr_qry\nWHERE real_time >= '1918-04-12 00:00:00'\n AND real_time <= 
'2018-04-12 15:55:53'\nGROUP BY refferer,\n DATE_TRUNC('week', real_time) AT 
TIME ZONE 'UTC'\nORDER BY count DESC\nLIMIT 50000"] (Background on this error 
at: http://sqlalche.me/e/f405)

This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:

With regards,
Apache Git Services

Reply via email to