drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Swatantra Agrawal (Jira)" <j...@apache.org>
Subject [jira] [Created] (DRILL-7765) Query failing for Mixed Datatype Date and String
Date Mon, 06 Jul 2020 01:07:00 GMT
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)

Mime
View raw message