You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Guillaume Champion (JIRA)" <ji...@apache.org> on 2016/12/01 16:20:58 UTC
[jira] [Created] (DRILL-5088) Error when reading DBRef column
Guillaume Champion created DRILL-5088:
-----------------------------------------
Summary: Error when reading DBRef column
Key: DRILL-5088
URL: https://issues.apache.org/jira/browse/DRILL-5088
Project: Apache Drill
Issue Type: Bug
Components: Execution - Data Types
Environment: drill 1.9.0
mongo 3.2
Reporter: Guillaume Champion
In a mongo database with DBRef, when a DBRef is inserted in the first line of mongo's collection drill query failed :
{code}
0: jdbc:drill:zk=local> select * from mongo.mydb.contact2;
Error: SYSTEM ERROR: CodecConfigurationException: Can't find a codec for class com.mongodb.DBRef.
{code}
Simple example to reproduce:
In mongo instance
{code}
db.contact2.drop();
db.contact2.insert({ "_id" : ObjectId("582081d96b69060001fd8938"), "account" : DBRef("contact", ObjectId("999cbf116b69060001fd8611")) });
{code}
In drill :
{code}
0: jdbc:drill:zk=local> select * from mongo.mydb.contact2;
Error: SYSTEM ERROR: CodecConfigurationException: Can't find a codec for class com.mongodb.DBRef.
[Error Id: 2944d766-e483-4453-a706-3d481397b186 on Analytics-Biznet:31010] (state=,code=0)
{code}
If the first line doesn't contain de DBRef, drill will querying correctly :
In a mongo instance :
{code}
db.contact2.drop();
db.contact2.insert({ "_id" : ObjectId("582081d96b69060001fd8939") });
db.contact2.insert({ "_id" : ObjectId("582081d96b69060001fd8938"), "account" : DBRef("contact", ObjectId("999cbf116b69060001fd8611")) });
{code}
In drill :
{code}
0: jdbc:drill:zk=local> select * from mongo.mydb.contact2;
+--------------------------------------+---------------------------------------------------------------+
| _id | account |
+--------------------------------------+---------------------------------------------------------------+
| {"$oid":"582081d96b69060001fd8939"} | {"$id":{}} |
| {"$oid":"582081d96b69060001fd8938"} | {"$ref":"contact","$id":{"$oid":"999cbf116b69060001fd8611"}} |
+--------------------------------------+---------------------------------------------------------------+
2 rows selected (0,563 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)