https://pinot.apache.org/ logo
Join Slack
Powered by
Hi, when i execute simple query on Pinot query co...
# troubleshooting
d
Hi, when i execute simple query on Pinot query console - select * from transcript where 1=1 , it gives error like - org.apache.pinot.pql.parsers.Pql2CompilationException: Comparison between two constants is not supported
m
Curious why you sre running pql
it is about to be deprecated
d
withoout checking PQL
even alias is also not working on pinot query console
@Mayank so , we can query only via presto ?
m
No, Pinot supports SQL as well (just not full sql eg nested queries)
You can use Pinot for those SQL queries
d
i am using Pinot for this simple query. but query , select * from transcript where 1=1 is not working
m
try sql, just uncheck the box you checked in the query console
also, what do you mean by 
where 1 = 1
?
d
I have unchecked the box , even it is not working
m
You can just do 
select * from transcript
d
where 1=1 , query is working under presto
m
Yeah, I think it is a valid sql query, but Pinot engine expects LHS to be an identifier.
I am curious why you want to do 
where 1=1
? Is it so your query generator can simply add more conditions by doing 
and..
?
If so, please go ahead and file an issue
d
where 1 = 1 means no where clause.It will always be true, so all records will be returned.
m
I get that. I am asking when is it necessary for you to add 
where 1=1
?
Either case, please do file an issue.
d
it is basically used for testing the query to return all rows
where can i file this issue?
m
Open in Slack
PreviousNext
Powered by