AM using 2.3
What could be the issue with below create index command.
: jdbc:ignite:thin://127.0.0.1> select * from "Customer".CUSTOMER
where ACCOUNT_ID_LIST ='A100000001';
+--------------------------------+--------------------------------+--------------------------------+--------------------------------+-------------------------------+
| ACCOUNT_ID_LIST | CUST_ADDRESS_ID_LIST |
PARTYROLE | PARTY_STATUS_CODE |
REFREE_ID |
+--------------------------------+--------------------------------+--------------------------------+--------------------------------+-------------------------------+
| A100000001 | custAddressIdList1 |
partyrole1 | partyStatusCode1 |
refreeId1 |
+--------------------------------+--------------------------------+--------------------------------+--------------------------------+-------------------------------+
1 row selected (3.324 seconds)
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>
--
Thanks & Regards,
Naveen Bandaru
