Swatantra Agrawal created DRILL-7765:
----------------------------------------
Summary: 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
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}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
|