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:altekruseja...@gmail.com] Sent: Monday, June 01, 2015 4:25 PM To: user@drill.apache.org Cc: jacq...@apache.org 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 <mran...@qualcomm.com> 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:hgu...@maprtech.com] > Sent: Monday, June 01, 2015 12:45 PM > To: user > Cc: jacq...@apache.org > 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 < > mran...@qualcomm.com > > 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: 'user@drill.apache.org' > > 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 > > > > > > >