Thanks for the confirmation, I will open a ticket right away.
Regards, Sachin Janani On Mon, Jun 6, 2022 at 8:46 PM Stephen Darlington < stephen.darling...@gridgain.com> wrote: > You should open a ticket (https://issues.apache.org/). This looks like a > regression as it works in 2.12. Also, the documentation talks about a > refresh command that doesn’t appear to exist in either 2.12 or 2.13. > > On 6 Jun 2022, at 14:11, Sachin janani <sachin.janani...@gmail.com> wrote: > > 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 < > stephen.darling...@gridgain.com> 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 <sachin.janani...@gmail.com> >> 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 <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* >> >> >> >> > > -- > *Sachin Janani* > > > > -- *Sachin Janani*
