Hi Kamesh, The 'zips' database is not sharded. The MongoDB setup is configured with two shards. There are other databases that are sharded.
Thank you. Xiao On Wed, Aug 26, 2015 at 3:33 PM, Kamesh <[email protected]> wrote: > Hi Xiao, > Is zips collection sharded or unsharded in the mongo cluster? > > > On Wed, Aug 26, 2015 at 10:34 AM, Xiao Yang <[email protected]> wrote: > > > Hi, > > > > I setup a test environment for using Drill with MongoDB. I had problems > > getting queries to work. > > > > ======A brief description of my setup========= > > > > Mongo cluster configuration: > > 1 MongoDB router > > 1 config server > > 2 shards > > > > MongoDB versions: > > 3.0.4 > > Configured to use Wiredtiger as the storage engine > > > > The Linux version that I am using is: > > Ubuntu 14.04.2 LTS (GNU/Linux 3.13.0-54-generic x86_64 > > > > The Java version number is: > > OpenJDK 64-bit Server VM (build 24.79-b02, mixed mode) > > > > Drill version: 1.1.0 > > > > ======A brief description of the problems that I encountered========= > > > > 1. I imported the zips.json database > > 2. I started the drill console 'drill-embedded' > > 3. I then use the browser admin interfaced to enable MongoDB storage > engine > > 4. I followed the steps and was able to use zips collection > > 5. I was able to do count > > 6. I can't do queries for some reason: > > > > 0: jdbc:drill:zk=local> show Tables; > > +---------------+-------------+ > > | TABLE_SCHEMA | TABLE_NAME | > > +---------------+-------------+ > > | mongo.zips | zips | > > +---------------+-------------+ > > 1 row selected (0.131 seconds) > > 0: jdbc:drill:zk=local> alter system set > > `store.mongo.read_numbers_as_double` = true; > > +-------+----------------------------------------------+ > > | ok | summary | > > +-------+----------------------------------------------+ > > | true | store.mongo.read_numbers_as_double updated. | > > +-------+----------------------------------------------+ > > 1 row selected (0.088 seconds) > > 0: jdbc:drill:zk=local> select * from zips limit 10; > > Error: SYSTEM ERROR: IllegalArgumentException: Incoming endpoints 1 is > > greater than number of chunks 0 > > > > > > [Error Id: 4d8b145f-08bc-43a1-8156-b60b7c91fbc3 on cluster-server:31010] > > (state=,code=0) > > 0: jdbc:drill:zk=local> select count(*) from zips; > > +---------+ > > | EXPR$0 | > > +---------+ > > | 29353 | > > +---------+ > > 1 row selected (0.119 seconds) > > 0: jdbc:drill:zk=local> > > > > Please help. > > > > Thank you. > > Xiao > > > > > > -- > Kamesh. >
