[DRILL-7765] Query failing for Mixed Datatype Date and String

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 1.17.0
• Component/s: Storage - MongoDB
• Assignee: Unassigned
• Reporter: Swatantra Agrawal
• Created: 06/Jul/20 01:06
• Updated: 08/Jul/20 03:24

Description

When a single field has 2 datatypes i.e. String and Date, the following exception is thrown:

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.

 

Steps to Reproduce:

Create 2 records in a collection say tmp:

db.tmp.save({"_id" : "date", "reportDate" : ISODate("1970-01-01T00:00:00Z")});
db.tmp.save({"_id" : "string", "reportDate" : "1970-01-01T00:00:00Z"}); 

 

Fire Drill Query to see the above Exception:

Select reportDate from tmp;

 

Additional Setting: 

store.mongo.all_text_mode is set to true.