Yes I am able to run DML queries on the PRODUCT_TABLE but the ANALYZE statement query is failing with parsing error.
Thanks and Regards, Sachin Janani On Thu, Jun 2, 2022 at 7:50 AM Ilya Korol <llivezk...@gmail.com> wrote: > Hi, are you able to run simple DML query like: SELECT * FROM > PRODUCT_TABLE; ? > 02.06.2022 00:13, Sachin janani пишет: > > Hi, > I am trying to run Analyze table command from sqlline to collect the > statistics of a table but its failing with parsing error. Following is the > error that i am getting. Can someone please help me in getting the right > syntax?. I am following this document: > https://ignite.apache.org/docs/latest/SQL/sql-statistics > > > 0: jdbc:ignite:thin://127.0.0.1/> ANALYZE PRODUCT_TABLE; > Error: Failed to parse query. Syntax error in SQL statement "ANALYZE > PRODUCT_TABLE[*]"; SQL statement: > ANALYZE PRODUCT_TABLE [42000-197] (state=42000,code=1001) > java.sql.SQLException: Failed to parse query. Syntax error in SQL statement > "ANALYZE PRODUCT_TABLE[*]"; SQL statement: > ANALYZE PRODUCT_TABLE [42000-197] > at > org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1009) > at > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:234) > at > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:560) > at sqlline.Commands.executeSingleQuery(Commands.java:1054) > at sqlline.Commands.execute(Commands.java:1003) > at sqlline.Commands.sql(Commands.java:967) > at sqlline.SqlLine.dispatch(SqlLine.java:734) > at sqlline.SqlLine.begin(SqlLine.java:541) > at sqlline.SqlLine.start(SqlLine.java:267) > at sqlline.SqlLine.main(SqlLine.java:206) > 0: jdbc:ignite:thin://127.0.0.1/> > > > Thanks and Regards, > -- > *Sachin Janani* > > > -- *Sachin Janani*
