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 11:27:24 UTC
[GitHub] [incubator-superset] klazaj opened a new issue #8909: Query returns
no data SQL Lab
klazaj opened a new issue #8909: Query returns no data SQL Lab
URL: https://github.com/apache/incubator-superset/issues/8909
When I run the query `select * from table where 'Column' = 'Value'` in SQL Lab, the query returns no data, even though there are rows that satisfy that condition.
Is there something wrong with my `where` condition?
PS:
I have also tried `select * from table where Column = 'Value'`, and I get the following Error message:
> column "column" does not exist LINE 1: select * from table where Column = 'Value' ^ HINT: Perhaps you meant to reference the column "table.Column".
When I try `select * from table where table.Column = 'Value'` there's again a similar Error message:
> column table.column does not exist LINE 1: select * from table where jira.Column = 'Value' ^ HINT: Perhaps you meant to reference the column "table.Column".
I assume the problem is with the capital C in Column, hence why I put the single quotes in the query.
----------------------------------------------------------------
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 #8909:
Query returns no data SQL Lab
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #8909: Query returns no data SQL Lab
URL: https://github.com/apache/incubator-superset/issues/8909#issuecomment-570181935
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.63. 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] klazaj closed issue #8909: Query returns no
data SQL Lab
Posted by GitBox <gi...@apache.org>.
klazaj closed issue #8909: Query returns no data SQL Lab
URL: https://github.com/apache/incubator-superset/issues/8909
----------------------------------------------------------------
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