[
https://issues.apache.org/jira/browse/DRILL-7765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Swatantra Agrawal updated DRILL-7765:
-------------------------------------
Description:
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" : "date", "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.
was:
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" : "date", "reportDate" : "1970-01-01T00:00:00Z"});
{noformat}
Fire Drill Query to see the above Exception:
{noformat}
Select reportDate from tmp;{noformat}
> 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" : "date", "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)
