apache / apache/pinot

'EXPLAIN PLAN FOR' not worked for apache-pinot-0.9.3-bin.tar.gz

Open
#8,275 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 3h
Merged PRs (30d)
195

Description

I download `apache-pinot-0.9.3-bin.tar.gz` from [pinot official website](https://pinot.apache.org/download/) and set up a cluster using this [guide,](https://docs.pinot.apache.org/developers/advanced/advanced-pinot-setup) .

My machine OS is `CentOS Linux release 7.4.1708 (Core)`.

My java version is like this:

```
openjdk version "11.0.14" 2022-01-18 LTS
OpenJDK Runtime Environment 18.9 (build 11.0.14+9-LTS)
OpenJDK 64-Bit Server VM 18.9 (build 11.0.14+9-LTS, mixed mode, sharing)
```

I want to check whether sqls use indexes, etc. But I got an error like this:

![](https://user-images.githubusercontent.com/24871202/156322457-12457212-ba6c-4d3b-91f5-735bfe320116.png)

And from the broker instance log, I only got this log:

```
Caught exception while compiling SQL request 10: EXPLAIN PLAN FOR select count(*) from transcript_benchmark limit 10, class org.apache.calcite.sql.SqlExplain cannot be cast to class org.apache.calcite.sql.SqlSelect (org.apache.calcite.sql.SqlExplain and org.apache.calcite.sql.SqlSelect are in unnamed module of loader 'app')
```
It seems like pinot uses calcite do sql parser, I don't know why it doesn't work. Could you help me?

Contributor guide

Open the contributing guide

Research direction

Start with the broker instance log and reproduce the reported `EXPLAIN PLAN FOR select count(*) from transcript_benchmark limit 10` query against the apache-pinot-0.9.3-bin.tar.gz setup. Trace the SQL compilation path around the reported SqlExplain-to-SqlSelect cast; done means the query executes without that exception and returns an explain plan.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
database
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.