[
https://issues.apache.org/jira/browse/IGNITE-17117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551147#comment-17551147
]
Sachin Janani commented on IGNITE-17117:
----------------------------------------
[~jooger] Here are the steps of how i reproduced it:
1. Download apache ignite 2.13 from this link:
https://dlcdn.apache.org/ignite/2.13.0/apache-ignite-2.13.0-bin.zip
2. Start ignite with the default config using following command
{code:java}
./ignite.sh ../config/default-config.xml{code}
3. Start sqlline and create table with using the following sql:
{code:java}
create table test2(a int, b int, c int, primary key(a,b)) with "affinity_key=a
, template=PARTITIONED";{code}
4. Run analyze command:
{code:java}
ANALYZE test2;{code}
The above command throws the following error:
{code:java}
0: jdbc:ignite:thin://127.0.0.1/> ANALYZE test2;
Error: Failed to parse query. Syntax error in SQL statement "ANALYZE TEST2[*]
"; SQL statement:
ANALYZE test2 [42000-197] (state=42000,code=1001)
java.sql.SQLException: Failed to parse query. Syntax error in SQL statement
"ANALYZE TEST2[*] "; SQL statement:
ANALYZE test2 [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) {code}
> Analyze Table SQL Statement not working with Ignite 2.13.0
> ----------------------------------------------------------
>
> Key: IGNITE-17117
> URL: https://issues.apache.org/jira/browse/IGNITE-17117
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.13
> Reporter: Sachin Janani
> Priority: Critical
> Fix For: 2.14
>
>
> Running ANALYZE table SQL statement is failing with following exception:
> {code:java}
> 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/>
> {code}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
