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

Apache drill fails to execute when excel file has datetime column

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.17.0
    • Fix Version/s: 1.18.0
    • Component/s: Storage - Other
    • Labels:
      None

      Description

      I am getting below error when m trying to query an excel sheet having datetime column in it. While when we convert same excel sheet to csv, its working fine.

      org.apache.drill.common.exceptions.UserRemoteException: EXECUTION_ERROR ERROR: No instant converter found for type: java.lang.Double Read failed for reader ExcelBatchReader Fragment 0:0 [Error Id: 0d8bf3b7-d6f3-4a12-8633-eb10a36cc6cb on 192.168.1.20:31010]

      Attaching the sample excel sheet and converted csv file for reference.

       

        Attachments

        1. excel_date_testing.csv
          0.8 kB
          Shivam Saxena
        2. excel_date_testing.xlsx
          10 kB
          Shivam Saxena

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              shivamsaxena Shivam Saxena
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: