Skip to content

Explain sql execute error #269

@zebozhuang

Description

@zebozhuang

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions