You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2021/01/14 21:22:21 UTC
[GitHub] [incubator-pinot] vmarchaud commented on issue #6442: bug: query parsing error
vmarchaud commented on issue #6442:
URL: https://github.com/apache/incubator-pinot/issues/6442#issuecomment-760484427
From slack:
```
Can you try single quote instead of double quote? In SQL, double quote is for identifier, you need single quote for literal
```
So i tested with the following and it worked fine:
```
SELECT "tmpId" from datasource_5ffdbf421eb80003001818fe
WHERE "name" = 'identify' AND "clientId" = '3f8e0112fbac1450776931712bdaad3bb0deb121'
GROUP BY "tmpId"
LIMIT 1
```
----------------------------------------------------------------
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: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org