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

Drill requires parentheses in the empty file for 'LOAD' argument in the 'CREATE SCHEMA' command

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.16.0
    • Fix Version/s: 1.17.0
    • Component/s: None
    • Labels:

      Description

      Description:

      • created csvh table: create table dfs.tmp.`test_table` (col1) as select full_name from cp.`employee.json` limit 3;
      • created text file on the local file system `for_load` with text without parentheses: col1 varchar not null
      • created some schema file: create or replace schema LOAD 'file:///home/user/for_load' for table dfs.tmp.`test_table` properties ('drill.strict' = 'false'); - schema was created successfully;
      • remove all text from the `for_load` file and try to create the same schema: create or replace schema LOAD 'file:///home/user/for_load' for table dfs.tmp.`test_table` properties ('drill.strict' = 'false');

      Actual result:
      Drill throws an error:
      Error: RESOURCE ERROR: Unable to parse schema []: Line [1], position [0], offending symbol [@0,0:-1='<EOF>',<-1>,1:0]: mismatched input '<EOF>' expecting {'(', ID, QUOTED_ID}

      Error while preparing / creating schema for [%s] dfs.tmp.test_table

      [Error Id: faad9c09-2e3e-428c-bd7a-6da8832a943b ] (state=,code=0)

      Expected result:
      Since Drill doesn't require parentheses for non empty `for_load` file (with some columns),
      It couldn't require parentheses for the empty file, used in the `LOAD` argument.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                denysord88 Denys Ordynskiy
                Reviewer:
                Vova Vysotskyi
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: