[jira] [Commented] (DRILL-4038) [MongoDB] Exception on bson mixin

["Bhallamudi Venkata Siva Kamesh (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-4038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14993020#comment-14993020 ] 

Bhallamudi Venkata Siva Kamesh commented on DRILL-4038:
-------------------------------------------------------

Could you run the queries by setting the following property and let us know still you are having any issues.
{code}
ALTER SYSTEM SET `store.json.read_numbers_as_double` = true;
{code}


> [MongoDB] Exception on bson mixin
> ---------------------------------
>
>                 Key: DRILL-4038
>                 URL: https://issues.apache.org/jira/browse/DRILL-4038
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - MongoDB
>    Affects Versions: 1.2.0
>         Environment: Drill running on Linux Suse 2.6
>            Reporter: W.
>
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IllegalArgumentException: You tried to write a BigInt type when you are using a ValueWriter of type NullableFloat8WriterImpl. Fragment 0:0 [Error Id: 337c58a4-2f3c-4f12-bb9b-ecd2c58a9b65
> If collection owns data of different bson type 1 (double) and 16 (32 bits integer), I'm getting the given exception
> Data:
> // 2 documents in the collection
> > db.test.find().pretty()
> { "_id" : ObjectId("5622bcebf9f16d8b892d498e"), "MoyLignesPreparees" : 0 }
> { "_id" : ObjectId("5622bcebf9f16d8b892d498d"), "MoyLignesPreparees" : 0.5 }
> // 2 types of data
> > db.test.count({ "MoyLignesPreparees": { $type: 1 } })
> 1
> > db.test.count({ "MoyLignesPreparees": { $type: 16 } })
> 1



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