In case of Cache_A and Cache_B you need to use quote symbols, since table schema is case-sensitive, but parser convert schemas in your query to upper case. Try these statements: SELECT * FROM "Cache_B".B0; SELECT * FROM "Cache_A".A;
2018-03-21 20:27 GMT+03:00 Wilhelm <wilhelm.tho...@anaplan.com>: > Super - Thanks a lot Alex. > > So the first one works well (sqlline, dbeaver and java) > SELECT * FROM B.B0; > > But the second one failed (dbeaver and sqlline), > SELECT * FROM A.A; > > So I thought may be if the cache name is different from object type the it > might work > so instead of "Cache/Schema.ObjectClass" like A.A or B.B0 I use Cache_A.A > and Cache_B.B0 but that is failing > The only thing I changed in the code is > private static String PREFIXTABLE = > "Cache_";//IgniteSQL.class.getSimpleName() + "Cache_"; > > +--------------------------------+-------------------------- > ------+--------------------------------+---------------------------------+ > | TABLE_CAT | TABLE_SCHEM | > TABLE_NAME | TABLE_TYPE | > +--------------------------------+-------------------------- > ------+--------------------------------+---------------------------------+ > | | Cache_B | B0 > | TABLE | > | | Cache_A | A > | TABLE | > +--------------------------------+-------------------------- > ------+--------------------------------+---------------------------------+ > 0: jdbc:ignite:thin://127.0.0.1/> SELECT * FROM Cache_A.A; > Error: Failed to parse query. Schema "CACHE_A" not found; SQL statement: > SELECT * FROM Cache_A.A [90079-195] (state=42000,code=0) > java.sql.SQLException: Failed to parse query. Schema "CACHE_A" not found; > SQL statement: > SELECT * FROM Cache_A.A [90079-195] > at > org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest( > JdbcThinConnection.java:648) > 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/> SELECT * FROM Cache_B.B0; > Error: Failed to parse query. Schema "CACHE_B" not found; SQL statement: > SELECT * FROM Cache_B.B0 [90079-195] (state=42000,code=0) > java.sql.SQLException: Failed to parse query. Schema "CACHE_B" not found; > SQL statement: > SELECT * FROM Cache_B.B0 [90079-195] > at > org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest( > JdbcThinConnection.java:648) > 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 > w > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
