Could you execute failed query and grep exception with mongo and send us?.
On Tue, Jun 2, 2015 at 5:15 AM, Rangaswamy, Manoharan <[email protected]> wrote: > Here is the error message from the log file for now. I will try to upload > if they are huge enough during further troubleshooting. > > *************** > 2015-06-01 14:52:15,173 [Client-1] INFO > o.a.d.j.i.DrillResultSetImpl$ResultsListener - Query failed: > org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: > Schema [meteor] is not valid with respect to either root schema or current > default schema. > > Current default schema: No default schema selected > > [Error Id: 7a1bfcc2-9684-4bcb-be71-4ab5c846a65a on > corpmapr-inf01.qualcomm.com:31010] > at > org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:118) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:111) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:47) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:32) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:61) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:233) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:205) > [drill-java-exec-1.0.0-mapr-r1-rebuffed.jar:1.0.0-mapr-r1] > at > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254) > [netty-handler-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:618) > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > at > io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:329) > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > at > io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:250) > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > at > io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) > [netty-common-4.0.27.Final.jar:4.0.27.Final] > at java.lang.Thread.run(Thread.java:744) [na:1.7.0_51] > *************** > > Thanks, > Mano > -----Original Message----- > From: Jason Altekruse [mailto:[email protected]] > Sent: Monday, June 01, 2015 4:25 PM > To: [email protected] > Cc: [email protected] > Subject: Re: MapR Drill - mongodb collections does not show up > > Hi Mano, > > Unfortunately the apache mail lists aren't very good with attachments, can > you upload it to a public host and share a link? > > - Jason Altekruse > > On Mon, Jun 1, 2015 at 3:01 PM, Rangaswamy, Manoharan < > [email protected]> > wrote: > > > Hi Hanifi, > > > > As you can see in the log file, I am unable to connect to the connect > > to the schema/database and query on the tables. > > > > I did a query like "use meteor" and here is the log file for that query. > > > > We are running Drill 1.0 and connecting to mongo 2.6 > > > > Thanks, > > Mano > > -----Original Message----- > > From: Hanifi Gunes [mailto:[email protected]] > > Sent: Monday, June 01, 2015 12:45 PM > > To: user > > Cc: [email protected] > > Subject: Re: MapR Drill - mongodb collections does not show up > > > > It would be great if you could give some more context failing queries, > > log, environment etc. > > > > -Hanifi > > > > On Mon, Jun 1, 2015 at 10:47 AM, Rangaswamy, Manoharan < > > [email protected] > > > wrote: > > > > > Hi Jacques, > > > > > > I saw your reply in the mail list and responding to your question. > > > > > > Can you please let me know if you want me to execute the failing > > > operation now and send the log files or setup some more debug info > > > options and send the log file. Please let me know. > > > > > > Thanks, > > > Mano > > > From: Rangaswamy, Manoharan > > > Sent: Monday, June 01, 2015 8:24 AM > > > To: '[email protected]' > > > Subject: MapR Drill - mongodb collections does not show up > > > > > > We are using MapR Drill 1.0 and configured a mongodb storage plugin > > > as below. > > > > > > { > > > "type": "mongo", > > > "connection": "mongodb://uid:pwd@host:port/dbname", > > > "enabled": true > > > } > > > > > > We are able to connect through CLI and Drill Explorer, but it does > > > display any databases and query against any collection fail as well. > > > > > > Robomongo connects well with the same user and it works. > > > > > > Are we missing any additional configuration? Please let us know. > > > > > > Thanks, > > > Mano > > > > > > > > > > > > -- Kamesh.
