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/ <http://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/ <http://127.0.0.1/>>
Thanks and Regards,
--
*/Sachin Janani/*
