Hi,
I cannot reproduce the issue with described steps.
Please check that the cache wasn't destroyed on the server.
i.e. please execute SELECT query again after failed CREATE INDEX.
On 30.11.2017 11:45, Naveen wrote:
Has anyone got a chance to look into into this issue where I am trying to
create an index, but its throwing an error saying cache does not exist
0: jdbc:ignite:thin://127.0.0.1> select ACCOUNT_ID_LIST from
"Customer".CUSTOMER where ACCOUNT_ID_LIST ='A100000001';
+--------------------------------+
| ACCOUNT_ID_LIST |
+--------------------------------+
| A100000001 |
+--------------------------------+
1 row selected (2.078 seconds)
**0: jdbc:ignite:thin://127.0.0.1> CREATE INDEX idx_customer_accountId ON
"Customer".CUSTOMER (ACCOUNT_ID_LIST);*
*Error: Cache doesn't exist: Customer (state=50000,code=0)
java.sql.SQLException: Cache doesn't exist: Customer
at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:671)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:130)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:299)
at sqlline.Commands.execute(Commands.java:823)
at sqlline.Commands.sql(Commands.java:733)
at sqlline.SqlLine.dispatch(SqlLine.java:795)
at sqlline.SqlLine.begin(SqlLine.java:668)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)
0: jdbc:ignite:thin://127.0.0.1>
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
--
Taras Ledkov
Mail-To: [email protected]
