apache / apache/pinot

Invalid query executing without any error message.

Open
#6,325 0 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

Invalid queries seems to run successfully in the Pinot sql console without producing any error. This gives the impression that the query ran, but returned an empty result.

**select playerId as a, yearid as a from baseballStats limit 100
select xyz from baseballStats limit 100**

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the two invalid queries in the Pinot SQL console and verify that they appear to succeed with empty results. Trace how the console reports query errors, then confirm that duplicate aliases and unknown columns produce visible errors when the issue is fixed.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
backend, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 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.