Prefixing with the ks is best practice, since it allows you to use a single session for multiple keyspaces. Otherwise you'd have to have a desicated session and set the keyspace by calling cluster.connect(ks) On Sun, Mar 26, 2017 at 19:39 S G <sg.online.em...@gmail.com> wrote:
> Thanks, got it working now :) > > Just wish that an error like: > "Table x not found in keyspace y" > would have been much better than: > "Table x not configured". > > > On Sat, Mar 25, 2017 at 6:13 AM, Arvydas Jonusonis < > arvydas.jonuso...@gmail.com> wrote: > > Make sure to prefix the table with the keyspace. > On Sat, Mar 25, 2017 at 13:28 Anuj Wadehra <anujw_2...@yahoo.co.in> wrote: > > Ensure that all the nodes are on same schema version such that table2 > schema is replicated properly on all the nodes. > > Thanks > Anuj > > Sent from Yahoo Mail on Android > <https://overview.mail.yahoo.com/mobile/?.src=Android> > > On Sat, Mar 25, 2017 at 3:19 AM, S G > <sg.online.em...@gmail.com> wrote: > Hi, > > I have a keyspace with two tables. > > I run a different query for each table: > > Table 1: > Select * from table1 where id = ? > > Table 2: > Select * from table2 where id1 = ? and id = ? > > > My code using datastax fires above two queries one after the other. > While it never fails for table 1, it never succeeds for table 2 > And gives an error: > > > com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table table2 > at > com.datastax.driver.core.Responses$Error.asException(Responses.java:136) > at > com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:179) > at > com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:177) > at > com.datastax.driver.core.RequestHandler.access$2500(RequestHandler.java:46) > at > com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:799) > at > com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:633) > at > com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1070) > at > com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:993) > at > io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321) > at > io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:266) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321) > at > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321) > at > io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:293) > at > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:267) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321) > at > io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1280) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) > at > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:890) > at > io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) > at > io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:564) > at > io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:505) > at > io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:419) > at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:391) > > Any idea what might be wrong? > > I have confirmed that all table-names and columns names are lowercase. > Datastax java version tried : 3.1.2 and 3.1.4 > Cassandra version: 3.10 > > > Thanks > SG > > > >
