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]>*
