drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-3466) MongoDB issue with Drill 1.1.0 which was working in 1.0.0
Date Wed, 08 Jul 2015 16:12:06 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-3466:
----------------------------------
    Fix Version/s: 1.2.0

> MongoDB issue with Drill 1.1.0 which was working in 1.0.0
> ---------------------------------------------------------
>
>                 Key: DRILL-3466
>                 URL: https://issues.apache.org/jira/browse/DRILL-3466
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - MongoDB
>    Affects Versions: 1.1.0
>         Environment: Windows, Apache Drill 1.1.0
>            Reporter: Vikas
>            Assignee: Jacques Nadeau
>             Fix For: 1.2.0
>
>
> I was working with Drill 1.0.0 and MongoDB 3.0.4 and trying different queries, when I
found that some kind of queries are well supported in Drill 1.1.0. That's when I switched
to latest released Drill 1.1.0. But to my surprise the simplest query on MongoDB stopped working.
> For example MongoDB had following data:
> > db.events.find();
> { "_id" : ObjectId("559b4eaf014b4d18f8049d2a"), "deviceId" : 9876, "eventId" : "eventA",
"eventInfo" : { "eventStatus" : true, "at" : ISODate("2015-07-07T03:59:43.488Z") } }
> { "_id" : ObjectId("559b4eb0014b4d18f8049d2b"), "deviceId" : 9876, "eventId" : "eventA",
"eventInfo" : { "eventStatus" : false, "at" : ISODate("2015-07-07T03:59:44.655Z") } }
> { "_id" : ObjectId("559b4eb1014b4d18f8049d2c"), "deviceId" : 9876, "eventId" : "eventB",
"eventInfo" : { "eventStatus" : true, "at" : ISODate("2015-07-07T03:59:45.658Z") } }
> { "_id" : ObjectId("559b4eb2014b4d18f8049d2d"), "deviceId" : 9876, "eventId" : "eventB",
"eventInfo" : { "eventStatus" : false, "at" : ISODate("2015-07-07T03:59:46.664Z") } }
> { "_id" : ObjectId("559b4eb3014b4d18f8049d2e"), "deviceId" : 9876, "eventId" : "eventA",
"eventInfo" : { "eventStatus" : true, "at" : ISODate("2015-07-07T03:59:47.670Z") } }
> { "_id" : ObjectId("559b4eb4014b4d18f8049d2f"), "deviceId" : 9876, "eventId" : "eventA",
"eventInfo" : { "eventStatus" : false, "at" : ISODate("2015-07-07T03:59:48.676Z") } }
> Running with apache drill 1.1.0
> ==============================
> D:\Programs\apache_softwares\apache-drill-1.1.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
> DRILL_ARGS - " -u jdbc:drill:zk=local"
> HADOOP_HOME not detected...
> HBASE_HOME not detected...
> Calculating Drill classpath...
> Jul 07, 2015 9:31:06 AM org.glassfish.jersey.server.ApplicationHandler initialize
> INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
> apache drill 1.0.0
> "a drill in the hand is better than two in the bush"
> 0: jdbc:drill:zk=local> show databases;
> +---------------------+
> |     SCHEMA_NAME     |
> +---------------------+
> | INFORMATION_SCHEMA  |
> | cp.default          |
> | dfs.default         |
> | dfs.root            |
> | dfs.tmp             |
> | mongo.local         |
> | mongo.testDB        |
> | sys                 |
> +---------------------+
> 8 rows selected (0.225 seconds)
> 0: jdbc:drill:zk=local> select * from mongo.testDB.events;
> Error: SYSTEM ERROR: JsonParseException: Failure while reading ExtendedJSON typed value.
Expected a VALUE_STRING but received a token of type VALUE_NUMBER_INT
>  at [Source: org.apache.drill.exec.vector.complex.fn.SeekableBAIS@14c0bfbe; line: 1,
column: 116]
> Fragment 0:0
> [Error Id: ab808e76-228f-4dc5-bf48-acb106e7675d on BGHM32007.ad.aricent.com:31010] (state=,code=0)
> 0: jdbc:drill:zk=local> !quit
> Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl
> switching back to Drill 1.0.0
> ========================
> D:\Programs\apache_softwares\apache-drill-1.1.0\bin>cd ..
> D:\Programs\apache_softwares\apache-drill-1.1.0>cd ..
> D:\Programs\apache_softwares>cd apache-drill-1.0.0
> D:\Programs\apache_softwares\apache-drill-1.0.0>cd bin
> D:\Programs\apache_softwares\apache-drill-1.0.0\bin>dir
>  Volume in drive D is Data Disk
>  Volume Serial Number is D4B5-4BF9
>  Directory of D:\Programs\apache_softwares\apache-drill-1.0.0\bin
> 07/06/2015  06:00 PM    <DIR>          .
> 07/06/2015  06:00 PM    <DIR>          ..
> 05/16/2015  08:05 AM               978 drill-conf
> 05/16/2015  08:05 AM             6,342 drill-config.sh
> 05/16/2015  08:05 AM               964 drill-embedded
> 05/16/2015  08:05 AM               988 drill-localhost
> 05/16/2015  08:05 AM             6,581 drillbit.sh
> 05/16/2015  08:05 AM             1,078 dumpcat
> 05/16/2015  08:05 AM               104 hadoop-excludes.txt
> 05/16/2015  08:05 AM             1,114 runbit
> 05/16/2015  08:05 AM             2,288 sqlline
> 05/16/2015  08:05 AM             5,914 sqlline.bat
> 05/16/2015  08:05 AM             1,139 submit_plan
>               11 File(s)         27,490 bytes
>                2 Dir(s)  139,456,872,448 bytes free
> D:\Programs\apache_softwares\apache-drill-1.0.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
> DRILL_ARGS - " -u jdbc:drill:zk=local"
> HADOOP_HOME not detected...
> HBASE_HOME not detected...
> Calculating Drill classpath...
> Error setting configuration: isolation: java.lang.NullPointerException
> Jul 07, 2015 9:33:43 AM org.glassfish.jersey.server.ApplicationHandler initialize
> INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
> apache drill 1.0.0
> "the only truly happy people are children, the creative minority and drill users"
> 0: jdbc:drill:zk=local> show databases;
> +---------------------+
> |     SCHEMA_NAME     |
> +---------------------+
> | INFORMATION_SCHEMA  |
> | cp.default          |
> | dfs.default         |
> | dfs.root            |
> | dfs.tmp             |
> | mongo.local         |
> | mongo.testDB        |
> | sys                 |
> +---------------------+
> 8 rows selected (2.538 seconds)
> 0: jdbc:drill:zk=local> select * from mongo.testDB.events;
> +-----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------+
> | deviceId  | eventId  |                                                            
                                                                                  |
> +-----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------+
> | 9876.0 | eventA | {"eventStatus":true,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34183488,"weekOfWeekyear":28,"yearOfCentu
|
> | 9876.0 | eventA | {"eventStatus":false,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34184655,"weekOfWeekyear":28,"yearOfCent
|
> | 9876.0 | eventB | {"eventStatus":true,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34185658,"weekOfWeekyear":28,"yearOfCentu
|
> | 9876.0 | eventB | {"eventStatus":false,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34186664,"weekOfWeekyear":28,"yearOfCent
|
> | 9876.0 | eventA | {"eventStatus":true,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34187670,"weekOfWeekyear":28,"yearOfCentu
|
> | 9876.0 | eventA | {"eventStatus":false,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34188676,"weekOfWeekyear":28,"yearOfCent
|
> | 9876.0 | eventB | {"eventStatus":true,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34189683,"weekOfWeekyear":28,"yearOfCentu
|
> | 9876.0 | eventB | {"eventStatus":false,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34190689,"weekOfWeekyear":28,"yearOfCent
|
> | 9876.0 | eventA | {"eventStatus":true,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34191694,"weekOfWeekyear":28,"yearOfCentu
|
> | 9876.0 | eventA | {"eventStatus":false,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34192696,"weekOfWeekyear":28,"yearOfCent
|
> | 9876.0 | eventB | {"eventStatus":true,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34193701,"weekOfWeekyear":28,"yearOfCentu
|
> | 9876.0 | eventB | {"eventStatus":false,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34194707,"weekOfWeekyear":28,"yearOfCent
|
> | 9876.0 | eventA | {"eventStatus":true,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34195712,"weekOfWeekyear":28,"yearOfCentu
|
> | 9876.0 | eventA | {"eventStatus":false,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34196718,"weekOfWeekyear":28,"yearOfCent
|
> | 9876.0 | eventB | {"eventStatus":true,"at":{"dayOfYear":188,"dayOfMonth":7,"dayOfWeek":2,"era":1,"year":2015,"millisOfDay":34197723,"weekOfWeekyear":28,"yearOfCentu
|
> +-----------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------+
> 15 rows selected (0.215 seconds)
> So it worked with Drill 1.0.0 but failed with 1.1.0.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message