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
