[
https://issues.apache.org/jira/browse/DRILL-7765?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17153208#comment-17153208
]
Swatantra Agrawal commented on DRILL-7765:
------------------------------------------
[~paul-rogers]: Could you confirm if this is a defect or not?
Drill is not honouring *store.mongo.all_text_mode = true* for ISODate & String
combination.
> Query failing for Mixed Datatype Date and String
> ------------------------------------------------
>
> Key: DRILL-7765
> URL: https://issues.apache.org/jira/browse/DRILL-7765
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - MongoDB
> Affects Versions: 1.17.0
> Reporter: Swatantra Agrawal
> Priority: Critical
>
> When a single field has 2 datatypes i.e. String and Date, the following
> exception is thrown:
> {noformat}
> org.apache.drill.common.exceptions.UserRemoteException: INTERNAL_ERROR ERROR:
> You tried to write a VarChar type when you are using a ValueWriter of type
> NullableTimeStampWriterImpl.
> {noformat}
>
> Steps to Reproduce:
> Create 2 records in a collection say tmp:
> {noformat}
> db.tmp.save({"_id" : "date", "reportDate" : ISODate("1970-01-01T00:00:00Z")});
> db.tmp.save({"_id" : "string", "reportDate" : "1970-01-01T00:00:00Z"});
> {noformat}
>
> Fire Drill Query to see the above Exception:
> {noformat}
> Select reportDate from tmp;{noformat}
>
> Additional Setting:
> *store.mongo.all_text_mode* is set to true.
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
