drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Xiao Yang <xiao.yan...@gmail.com>
Subject Can't query MongoDB
Date Wed, 26 Aug 2015 05:04:44 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message