Hi, I am using the latest Ignite 2.13 and running this query from sqlline. On Mon, Jun 6, 2022 at 2:16 PM Stephen Darlington < [email protected]> wrote:
> What version of Ignite are you using? Statistics were added in Ignite 2.12 > (IIRC), so if you’re using an older version you’d get this error. > > On 2 Jun 2022, at 05:37, Sachin janani <[email protected]> wrote: > > 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 <[email protected]> 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* > > > > -- *Sachin Janani*
