Re: Can't query MongoDB

[Kamesh]

Hi Xiao,
 Is zips collection sharded or unsharded in the mongo cluster?


On Wed, Aug 26, 2015 at 10:34 AM, Xiao Yang <xiao.yan...@gmail.com> 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.