You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by Cesar Garcia <ce...@ceos.com.ve> on 2020/05/22 05:18:30 UTC
Parsing sql query
First of all a cordial greeting,
I am using the JDBC driver to access the IoTDB database.
I am being processed a problem with the processing of certain functions, in
specific "SHOW" and "COUNT", for example.
I have not been able to see the problem as it works perfectly for example
for a "SELECT" statement.
In IoTDB's own client it works without problems.
I already checked the client code and I don't see any kind of
differentiation for these functions.
Annex two comparisons with the instructions, as well as the capture of the
fault in the Log.
Thanking you for your guidance,
Best regards,
karaf@root()> query iotdb_local 'select * from root'
root.ln.wf01.wt01.temperature | Time
------------------------------+--------------
28.22 | 1509466620000
28.22 | 1509466621000
29.22 | 1509466622000
karaf@root()> query iotdb_local 'show storage group'
Error executing command: Parsing error, statement [show storage group]
failed when parsing AST tree to generate logical operator. Detailed
information: [line 1:5 'show']
karaf@root()>
01:17:20.411 ERROR [Karaf local console user karaf] Exception caught while
executing command
org.apache.iotdb.jdbc.IoTDBSQLException: Parsing error, statement [show
storage group] failed when parsing AST tree to generate logical operator.
Detailed information: [line 1:5 'show']
at
org.apache.iotdb.jdbc.IoTDBStatement.executeQuerySQL(IoTDBStatement.java:416)
~[?:?]
at
org.apache.iotdb.jdbc.IoTDBStatement.executeQuery(IoTDBStatement.java:391)
~[?:?]
at
org.apache.karaf.jdbc.internal.JdbcServiceImpl.query(JdbcServiceImpl.java:140)
~[?:?]
at
org.apache.karaf.jdbc.command.QueryCommand.execute(QueryCommand.java:50)
~[?:?]
at
org.apache.karaf.shell.impl.action.command.ActionCommand.execute(ActionCommand.java:84)
~[?:?]
at
org.apache.karaf.shell.impl.console.osgi.secured.SecuredCommand.execute(SecuredCommand.java:68)
~[?:?]
at
org.apache.karaf.shell.impl.console.osgi.secured.SecuredCommand.execute(SecuredCommand.java:86)
~[?:?]
at
org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:599) ~[?:?]
at
org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:526)
~[?:?]
at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:415)
~[?:?]
at org.apache.felix.gogo.runtime.Pipe.doCall(Pipe.java:416) ~[?:?]
at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:229) ~[?:?]
at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:59) ~[?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
~[?:?]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
~[?:?]
at java.lang.Thread.run(Thread.java:834) [?:?]
--
*CEOS Automatización, C.A.*
*GALPON SERVICIO INDUSTRIALES Y NAVALES FA, C.A.,*
*PISO 1, OFICINA 2, AV. RAUL LEONI, SECTOR GUAMACHITO,*
*FRENTE A LA ASOCIACION DE GANADEROS,BARCELONA,EDO. ANZOATEGUI*
*Ing. César García*
*Cel: +58 414-760.98.95*
*Hotline Técnica SIEMENS: 0800 1005080*
*Email: support.aan.automation@siemens.com
<su...@siemens.com>*
Re: Parsing sql query
Posted by Cesar Garcia <ce...@ceos.com.ve>.
Hello,
Thanks for your quick response,
I am indeed using version 0.9.3.
I will be doing some tests and I inform you through this way.
Grateful for the help,
Best regards,
El vie., 22 may. 2020 a las 2:08, Haonan Hou (<hh...@outlook.com>)
escribió:
> Hi,
>
> I think you are using version 0.9 IoTDB.
>
> Actually in v0.9, we are using Antlr3 to parse the SQL statements excepts
> the ’SHOW’ statements.
> I think that’s the reason why JDBC driver doesn’t support ‘SHOW’
> statements.
>
> In v0.10, we upgrade to Antlr4 to parse the SQL and now support all
> statement with JDBC driver.
>
> Best wishes,
>
> Haonan Hou
>
>
> > On May 22, 2020, at 1:18 PM, Cesar Garcia <ce...@ceos.com.ve>
> wrote:
> >
> > First of all a cordial greeting,
> >
> > I am using the JDBC driver to access the IoTDB database.
> >
> > I am being processed a problem with the processing of certain functions,
> in
> > specific "SHOW" and "COUNT", for example.
> >
> > I have not been able to see the problem as it works perfectly for example
> > for a "SELECT" statement.
> >
> > In IoTDB's own client it works without problems.
> >
> > I already checked the client code and I don't see any kind of
> > differentiation for these functions.
> >
> > Annex two comparisons with the instructions, as well as the capture of
> the
> > fault in the Log.
> >
> > Thanking you for your guidance,
> >
> > Best regards,
> >
> >
> > karaf@root()> query iotdb_local 'select * from root'
> > root.ln.wf01.wt01.temperature | Time
> > ------------------------------+--------------
> > 28.22 | 1509466620000
> > 28.22 | 1509466621000
> > 29.22 | 1509466622000
> >
> >
> > karaf@root()> query iotdb_local 'show storage group'
> > Error executing command: Parsing error, statement [show storage group]
> > failed when parsing AST tree to generate logical operator. Detailed
> > information: [line 1:5 'show']
> > karaf@root()>
> >
> > 01:17:20.411 ERROR [Karaf local console user karaf] Exception caught
> while
> > executing command
> > org.apache.iotdb.jdbc.IoTDBSQLException: Parsing error, statement [show
> > storage group] failed when parsing AST tree to generate logical operator.
> > Detailed information: [line 1:5 'show']
> > at
> >
> org.apache.iotdb.jdbc.IoTDBStatement.executeQuerySQL(IoTDBStatement.java:416)
> > ~[?:?]
> > at
> >
> org.apache.iotdb.jdbc.IoTDBStatement.executeQuery(IoTDBStatement.java:391)
> > ~[?:?]
> > at
> >
> org.apache.karaf.jdbc.internal.JdbcServiceImpl.query(JdbcServiceImpl.java:140)
> > ~[?:?]
> > at
> > org.apache.karaf.jdbc.command.QueryCommand.execute(QueryCommand.java:50)
> > ~[?:?]
> > at
> >
> org.apache.karaf.shell.impl.action.command.ActionCommand.execute(ActionCommand.java:84)
> > ~[?:?]
> > at
> >
> org.apache.karaf.shell.impl.console.osgi.secured.SecuredCommand.execute(SecuredCommand.java:68)
> > ~[?:?]
> > at
> >
> org.apache.karaf.shell.impl.console.osgi.secured.SecuredCommand.execute(SecuredCommand.java:86)
> > ~[?:?]
> > at
> > org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:599) ~[?:?]
> > at
> > org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:526)
> > ~[?:?]
> > at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:415)
> > ~[?:?]
> > at org.apache.felix.gogo.runtime.Pipe.doCall(Pipe.java:416) ~[?:?]
> > at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:229) ~[?:?]
> > at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:59) ~[?:?]
> > at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
> > at
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> > ~[?:?]
> > at
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> > ~[?:?]
> > at java.lang.Thread.run(Thread.java:834) [?:?]
> >
> >
> >
> >
> >
> > --
> > *CEOS Automatización, C.A.*
> > *GALPON SERVICIO INDUSTRIALES Y NAVALES FA, C.A.,*
> > *PISO 1, OFICINA 2, AV. RAUL LEONI, SECTOR GUAMACHITO,*
> >
> > *FRENTE A LA ASOCIACION DE GANADEROS,BARCELONA,EDO. ANZOATEGUI*
> > *Ing. César García*
> >
> > *Cel: +58 414-760.98.95*
> >
> > *Hotline Técnica SIEMENS: 0800 1005080*
> >
> > *Email: support.aan.automation@siemens.com
> > <su...@siemens.com>*
>
>
--
*CEOS Automatización, C.A.*
*GALPON SERVICIO INDUSTRIALES Y NAVALES FA, C.A.,*
*PISO 1, OFICINA 2, AV. RAUL LEONI, SECTOR GUAMACHITO,*
*FRENTE A LA ASOCIACION DE GANADEROS,BARCELONA,EDO. ANZOATEGUI*
*Ing. César García*
*Cel: +58 414-760.98.95*
*Hotline Técnica SIEMENS: 0800 1005080*
*Email: support.aan.automation@siemens.com
<su...@siemens.com>*
Re: Parsing sql query
Posted by Haonan Hou <hh...@outlook.com>.
Hi,
I think you are using version 0.9 IoTDB.
Actually in v0.9, we are using Antlr3 to parse the SQL statements excepts the ’SHOW’ statements.
I think that’s the reason why JDBC driver doesn’t support ‘SHOW’ statements.
In v0.10, we upgrade to Antlr4 to parse the SQL and now support all statement with JDBC driver.
Best wishes,
Haonan Hou
> On May 22, 2020, at 1:18 PM, Cesar Garcia <ce...@ceos.com.ve> wrote:
>
> First of all a cordial greeting,
>
> I am using the JDBC driver to access the IoTDB database.
>
> I am being processed a problem with the processing of certain functions, in
> specific "SHOW" and "COUNT", for example.
>
> I have not been able to see the problem as it works perfectly for example
> for a "SELECT" statement.
>
> In IoTDB's own client it works without problems.
>
> I already checked the client code and I don't see any kind of
> differentiation for these functions.
>
> Annex two comparisons with the instructions, as well as the capture of the
> fault in the Log.
>
> Thanking you for your guidance,
>
> Best regards,
>
>
> karaf@root()> query iotdb_local 'select * from root'
> root.ln.wf01.wt01.temperature | Time
> ------------------------------+--------------
> 28.22 | 1509466620000
> 28.22 | 1509466621000
> 29.22 | 1509466622000
>
>
> karaf@root()> query iotdb_local 'show storage group'
> Error executing command: Parsing error, statement [show storage group]
> failed when parsing AST tree to generate logical operator. Detailed
> information: [line 1:5 'show']
> karaf@root()>
>
> 01:17:20.411 ERROR [Karaf local console user karaf] Exception caught while
> executing command
> org.apache.iotdb.jdbc.IoTDBSQLException: Parsing error, statement [show
> storage group] failed when parsing AST tree to generate logical operator.
> Detailed information: [line 1:5 'show']
> at
> org.apache.iotdb.jdbc.IoTDBStatement.executeQuerySQL(IoTDBStatement.java:416)
> ~[?:?]
> at
> org.apache.iotdb.jdbc.IoTDBStatement.executeQuery(IoTDBStatement.java:391)
> ~[?:?]
> at
> org.apache.karaf.jdbc.internal.JdbcServiceImpl.query(JdbcServiceImpl.java:140)
> ~[?:?]
> at
> org.apache.karaf.jdbc.command.QueryCommand.execute(QueryCommand.java:50)
> ~[?:?]
> at
> org.apache.karaf.shell.impl.action.command.ActionCommand.execute(ActionCommand.java:84)
> ~[?:?]
> at
> org.apache.karaf.shell.impl.console.osgi.secured.SecuredCommand.execute(SecuredCommand.java:68)
> ~[?:?]
> at
> org.apache.karaf.shell.impl.console.osgi.secured.SecuredCommand.execute(SecuredCommand.java:86)
> ~[?:?]
> at
> org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:599) ~[?:?]
> at
> org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:526)
> ~[?:?]
> at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:415)
> ~[?:?]
> at org.apache.felix.gogo.runtime.Pipe.doCall(Pipe.java:416) ~[?:?]
> at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:229) ~[?:?]
> at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:59) ~[?:?]
> at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> ~[?:?]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> ~[?:?]
> at java.lang.Thread.run(Thread.java:834) [?:?]
>
>
>
>
>
> --
> *CEOS Automatización, C.A.*
> *GALPON SERVICIO INDUSTRIALES Y NAVALES FA, C.A.,*
> *PISO 1, OFICINA 2, AV. RAUL LEONI, SECTOR GUAMACHITO,*
>
> *FRENTE A LA ASOCIACION DE GANADEROS,BARCELONA,EDO. ANZOATEGUI*
> *Ing. César García*
>
> *Cel: +58 414-760.98.95*
>
> *Hotline Técnica SIEMENS: 0800 1005080*
>
> *Email: support.aan.automation@siemens.com
> <su...@siemens.com>*