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/10/09 18:08:16 UTC
[GitHub] [incubator-superset] stevensuting opened a new issue #11219: BIGINT not filterable when using Presto as datasource
stevensuting opened a new issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219
I am required to cast bigint to int to make it filterable.
`cast("my_bigint_column" AS INTEGER)`
The logs show no error and SQL labs says:
`The query returned no data`
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stevensuting commented on issue #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
stevensuting commented on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-710096413
Presto version: 0.232
This is a Presto issue and not Superset.
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stevensuting edited a comment on issue #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
stevensuting edited a comment on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-707623946
**In Explore Chart**
`select cast("clbprogid" AS INTEGER) AS "clbprogid" from table`
<img width="541" alt="Screenshot 2020-10-13 at 3 02 27 PM" src="https://user-images.githubusercontent.com/8875448/95843580-7de5c400-0d65-11eb-873b-5e0eb3b6f9b5.png">
`select clbprogid from table`
<img width="913" alt="Screenshot 2020-10-13 at 3 01 47 PM" src="https://user-images.githubusercontent.com/8875448/95843638-8b9b4980-0d65-11eb-962b-fe068354cb97.png">
---
**In SQL LAB**
With CAST
<img width="480" alt="Screenshot 2020-10-13 at 3 32 28 PM" src="https://user-images.githubusercontent.com/8875448/95846698-5db80400-0d69-11eb-9243-dc67dc43e8e4.png">
Without CAST
<img width="365" alt="Screenshot 2020-10-13 at 3 11 53 PM" src="https://user-images.githubusercontent.com/8875448/95844388-7f63bc00-0d66-11eb-8369-0df423d7f282.png">
----------------------------------------------------------------
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
---------------------------------------------------------------------
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 #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-708200558
Agreed, it seems this is a bug in the version of Presto you are using.
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stevensuting closed issue #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
stevensuting closed issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219
----------------------------------------------------------------
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
---------------------------------------------------------------------
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 #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-706328262
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.88. 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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] mistercrunch commented on issue #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
mistercrunch commented on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-708144007
Oh wow, that looks more like a Presto bug to me now. What version of Presto are you on? I bet you'll get the same odd behavior in the Presto CLI
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stevensuting edited a comment on issue #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
stevensuting edited a comment on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-707623946
**In Explore Chart**
`select cast("clbprogid" AS INTEGER) AS "clbprogid" from table`
<img width="541" alt="Screenshot 2020-10-13 at 3 02 27 PM" src="https://user-images.githubusercontent.com/8875448/95843580-7de5c400-0d65-11eb-873b-5e0eb3b6f9b5.png">
`select clbprogid from table`
<img width="913" alt="Screenshot 2020-10-13 at 3 01 47 PM" src="https://user-images.githubusercontent.com/8875448/95843638-8b9b4980-0d65-11eb-962b-fe068354cb97.png">
---
**In SQL LAB**
With CAST
<img width="482" alt="Screenshot 2020-10-13 at 3 34 07 PM" src="https://user-images.githubusercontent.com/8875448/95846947-bb4c5080-0d69-11eb-91f2-a272e1210188.png">
Without CAST
<img width="382" alt="Screenshot 2020-10-13 at 3 35 05 PM" src="https://user-images.githubusercontent.com/8875448/95846935-b7203300-0d69-11eb-84b8-307ac3f68131.png">
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stevensuting commented on issue #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
stevensuting commented on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-707480759
Updated original post.
----------------------------------------------------------------
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
---------------------------------------------------------------------
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 #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-707010407
@stevensuting Can you state which version you're 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
---------------------------------------------------------------------
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 #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-707510044
Can you also elaborate more on the context in which this isn't working. With filterable, do you mean you can't create a FilterBox? You also mention SQL Lab; does this mean that a simple `SELECT cols FROM tbl` doesn't work if your dataset has a `bigint` column, but works if you cast it to `integer`? A few screenshots would also be very helpful.
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] mistercrunch commented on issue #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
mistercrunch commented on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-708144238
https://github.com/prestosql/presto/issues/2166 ?
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stevensuting commented on issue #11219: BIGINT not filterable when using Presto as datasource
Posted by GitBox <gi...@apache.org>.
stevensuting commented on issue #11219:
URL: https://github.com/apache/incubator-superset/issues/11219#issuecomment-707623946
**In Explore Chart**
`select cast("clbprogid" AS INTEGER) AS "clbprogid" from table`
<img width="541" alt="Screenshot 2020-10-13 at 3 02 27 PM" src="https://user-images.githubusercontent.com/8875448/95843580-7de5c400-0d65-11eb-873b-5e0eb3b6f9b5.png">
`select clbprogid from table`
<img width="913" alt="Screenshot 2020-10-13 at 3 01 47 PM" src="https://user-images.githubusercontent.com/8875448/95843638-8b9b4980-0d65-11eb-962b-fe068354cb97.png">
**In SQL LAB**
With CAST
<img width="488" alt="Screenshot 2020-10-13 at 3 10 36 PM" src="https://user-images.githubusercontent.com/8875448/95844355-75da5400-0d66-11eb-9de5-2c96280324ea.png">
Without CAST
<img width="365" alt="Screenshot 2020-10-13 at 3 11 53 PM" src="https://user-images.githubusercontent.com/8875448/95844388-7f63bc00-0d66-11eb-8369-0df423d7f282.png">
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org