You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Sachin janani <sa...@gmail.com> on 2022/06/01 14:13:41 UTC
Analyze table query failing with syntax error from sqlline
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*
Re: Analyze table query failing with syntax error from sqlline
Posted by Sachin janani <sa...@gmail.com>.
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.darlington@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 <sa...@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.darlington@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 <sa...@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 <ll...@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*
Re: Analyze table query failing with syntax error from sqlline
Posted by Stephen Darlington <st...@gridgain.com>.
You should open a ticket (https://issues.apache.org/ <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 <sa...@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.darlington@gridgain.com <ma...@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.janani203@gmail.com <ma...@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 <llivezking@gmail.com <ma...@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 <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
>>>
>>
>>
>> --
>> Sachin Janani
>>
>
>
>
> --
> Sachin Janani
>
Re: Analyze table query failing with syntax error from sqlline
Posted by Sachin janani <sa...@gmail.com>.
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.darlington@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 <sa...@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 <ll...@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*
Re: Analyze table query failing with syntax error from sqlline
Posted by Stephen Darlington <st...@gridgain.com>.
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 <sa...@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 <llivezking@gmail.com <ma...@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 <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
>>
>
>
> --
> Sachin Janani
>
Re: Analyze table query failing with syntax error from sqlline
Posted by Sachin janani <sa...@gmail.com>.
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 <ll...@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*
Re: Analyze table query failing with syntax error from sqlline
Posted by Ilya Korol <ll...@gmail.com>.
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/*