apache / apache/pinot

issues on where clause 1=1

Open
#7,203 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
1d 21h
Merged PRs (30d)
189

Description

Hi ,

I am exploring Apache Pinot query console and found that some queries like -select * from transcript where 1=1 does not working.It gives error like - it gives error like - org.apache.pinot.pql.parsers.Pql2CompilationException: Comparison between two constants is not supported.

where 1 = 1 means no where clause.It will always be true, so all records will be returned.This is basically used for testing the query to return all rows.

Screenshot 2021-07-25 at 9 14 22 AM

while this query is working under presto.

Screenshot 2021-07-25 at 9 25 04 AM

Contributor guide

Open the contributing guide

Research direction

Start by reproducing `select * from transcript where 1=1` in the Apache Pinot query console and trace the reported Pql2CompilationException through the PQL parser. Compare the behavior with the working Presto query; done means the constant predicate is accepted and the query returns all records as described.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.