Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ParserException illegal sql expr #34

Closed
daledude opened this issue Jan 13, 2015 · 2 comments
Closed

ParserException illegal sql expr #34

daledude opened this issue Jan 13, 2015 · 2 comments
Assignees

Comments

@daledude
Copy link

I'm not sure if these are expected behaviors...

Trying to execute this query from the sql web interface... (with or without the semicolon)...

SELECT min(id),max(id) FROM logs-2015.01.13;

Produces this error...

{"error":"ParserException[illegal sql expr : SELECT min(id),max(id) FROM logs-2015.01.13;]","status":500}

But, if I add a LIMIT clause then the query executes...

SELECT min(id),max(id) FROM logs-2015.01.13 limit 1

Also, running the above query with a semicolon at the end produces an error. Note that I also used a semicolon in the first query above for what it's worth...

SELECT min(id),max(id) FROM logs-2015.01.13 limit 1;
{"error":"ParserException[illegal sql expr : SELECT min(id),max(id) FROM TEMP_TABLE limit 1;]","status":500}
@omershelef
Copy link
Contributor

It looks like a bug, i will fix it on next release

@omershelef omershelef self-assigned this Jan 13, 2015
@omershelef
Copy link
Contributor

After a quick look at the code, It may be better if you just wrap your index name with backticks.

SELECT * FROM `logs-2015.01.13`

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants