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 (<[email protected]>) 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 <[email protected]> > 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: [email protected] > > <[email protected]>* > > -- *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: [email protected] <[email protected]>*
