[DRILL-7767] When fetching Timestamp all text mode and empty to null not honoured

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.17.0
• Component/s: Storage - MongoDB
• Assignee: Unassigned
• Reporter: Swatantra Agrawal
• Created: 19/Jul/20 00:42
• Updated: 19/Jul/20 00:45

Description

Apache Drill does not honour these flags when dealing with ISODate.

store.mongo.all_text_mode
drill.exec.functions.cast_empty_string_to_null

 

Steps to Reproduce:

Set both the properties to true or exclusively set to true.

Insert 2 records in a collection as below

db.temp.save({reportDate:ISODate()});
db.temp.save({reportDate:""});

 

Execute Query

SELECT reportDate from mongo.drill.temp 

 

An 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.