[DRILL-7332] Drill requires parentheses in the empty file for 'LOAD' argument in the 'CREATE SCHEMA' command

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.17.0
• Labels: ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Denys Ordynskiy
• Reviewer: Vova Vysotskyi
• Created: 25/Jul/19 14:52
• Updated: 31/Jul/19 12:53
• Resolved: 29/Jul/19 09:25

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.

Issue Links

• links to: GitHub Pull Request #1828