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.

Sign up for GitHub

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

Jump to bottom

Using simpleSqlParser for the following SELECT statement #22

Open

jhiemer opened this issue Dec 28, 2015 · 1 comment

jhiemer commented Dec 28, 2015

Hi,
I am currently trying to use the following statement for a influx DB query which fails because of different aspects

SELECT derivate(mean(value)) AS value FROM "this.is.a.crazy.table" WHERE time() > now - 10m AND host = "blabla" AND ip = "192.168.1.1" GROUP BY time(10s) LIMIT 5

It seems that V2 of the parser does not like quoted table names "this.is.a.crazy.table"
Where does not like the function time() > now - 10m
The Group statement is also not parsed correctly with time(10s)

Are those things which maybe changed easily?

The text was updated successfully, but these errors were encountered:

dsferruzza added a commit that referenced this issue


          Fix issue 1 in #22

189b5c0

dsferruzza added a commit that referenced this issue


          Fix issue 2 in #22

8ad8021

Owner

dsferruzza commented Dec 29, 2015

Hi,

I tried to fix these issues here: https://github.com/dsferruzza/simpleSqlParser/tree/fix-influxdb (diff)
Can you have a look at this branch and tell me if this looks good to you?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment