search

Qihoo360 / Quicksql

A Flexible, Fast, Federated(3F) SQL Analysis Middleware for Multiple Data Sources
https://quicksql.readthedocs.io
MIT License
2.06k stars 583 forks source link

Explain sql execute error #269

Open zebozhuang opened 2 years ago

zebozhuang commented 2 years ago

Versions

eg: 0.7.1

Describe the bug

I build quicksql and start up the server, I ran by using quicksql.sh command as following

./bin/quicksql.sh -e "EXPLAIN select * from example limit 5"

To Reproduce

Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior

The description about the sql performance.

Actual behavior

RuntimeException

Full Output Logs

2022-04-01 15:09:33,133 [main] INFO - job.execute.start:2022-04-01 15:09:33:133 2022-04-01 15:09:33,190 [main] INFO - Your SQL is 'EXPLAIN select * from example limit 5' java.lang.RuntimeException: Encountered "select" at line 1, column 10. Was expecting: "PLAN" ...

at com.qihoo.qsql.utils.SqlUtil.parseTableName(SqlUtil.java:26)
at com.qihoo.qsql.launcher.ExecutionDispatcher.main(ExecutionDispatcher.java:84)

2022-04-01 15:09:33,267 [main] ERROR - execution.error:Encountered "select" at line 1, column 10. Was expecting: "PLAN" ...

Additional context

Add any other context about the problem here.