You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/01/02 16:12:47 UTC
[GitHub] [incubator-superset] klazaj opened a new issue #8910: function
date_trunc(unknown, text) does not exist in Line Chart
klazaj opened a new issue #8910: function date_trunc(unknown, text) does not exist in Line Chart
URL: https://github.com/apache/incubator-superset/issues/8910
When trying to create a line chart from a datasource I have uploaded (through CSV upload), I get the following error:
> function date_trunc(unknown, text) does not exist LINE 2: DATE_TRUNC('day', created) AS __timestamp, ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Column details:
The column details and date format are exactly the same as the 'examples.birthnames' provided by Superset. Why do I get an error? Database is Superset's own Postgres
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] rumbin commented on issue #8910: function
date_trunc(unknown, text) does not exist in Line Chart
Posted by GitBox <gi...@apache.org>.
rumbin commented on issue #8910: function date_trunc(unknown, text) does not exist in Line Chart
URL: https://github.com/apache/incubator-superset/issues/8910#issuecomment-570733620
In my eyes this probably is the expected behaviour, at least from Superset's point of view.
The user might expect something different, perhaps.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] klazaj closed issue #8910: function
date_trunc(unknown, text) does not exist in Line Chart
Posted by GitBox <gi...@apache.org>.
klazaj closed issue #8910: function date_trunc(unknown, text) does not exist in Line Chart
URL: https://github.com/apache/incubator-superset/issues/8910
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #8910:
function date_trunc(unknown, text) does not exist in Line Chart
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #8910: function date_trunc(unknown, text) does not exist in Line Chart
URL: https://github.com/apache/incubator-superset/issues/8910#issuecomment-570255644
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.80. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] villebro commented on issue #8910: function
date_trunc(unknown, text) does not exist in Line Chart
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #8910: function date_trunc(unknown, text) does not exist in Line Chart
URL: https://github.com/apache/incubator-superset/issues/8910#issuecomment-570628122
@klazaj what database engine are you on?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] klazaj commented on issue #8910: function
date_trunc(unknown, text) does not exist in Line Chart
Posted by GitBox <gi...@apache.org>.
klazaj commented on issue #8910: function date_trunc(unknown, text) does not exist in Line Chart
URL: https://github.com/apache/incubator-superset/issues/8910#issuecomment-570579189
If I put the date column in `Parse Dates` field when importing the CSV, I do not get this error anymore.
Maybe someone can elaborate why changing the column type manually results in an error?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] rumbin commented on issue #8910: function
date_trunc(unknown, text) does not exist in Line Chart
Posted by GitBox <gi...@apache.org>.
rumbin commented on issue #8910: function date_trunc(unknown, text) does not exist in Line Chart
URL: https://github.com/apache/incubator-superset/issues/8910#issuecomment-570733383
In my understanding Postgres tries to apply the date_trunc() function on a column with data type 'text', which will obviously fail.
If you check the column dtype of this table, e.g., using any DB explorer like pgadmin or DBeaver you will most likely see that it is of type text and not timestamp.
By adding the column to the Parse Dates list, you tell Superset (in fact, supposedly, Pandas' read_csv() function) to try to interpret the column as timestamp, which then leads to setting the correct dtype in the DB table.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org