Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7767

When fetching Timestamp all text mode and empty to null not honoured

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.17.0
    • Fix Version/s: None
    • Component/s: Storage - MongoDB
    • Labels:
      None

      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.

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              swat Swatantra Agrawal
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: