Issue #1 - I can't just specify some of the options - the issue appears to be that I didn't also include some other options:
0: jdbc:drill:zk=local> select columns[0] as a, cast(columns[1] as bigint) as b from table(dfs.tmp.`sample_cast.tsv`(skipFirstLine => true)); Apr 13, 2016 8:48:51 AM org.apache.calcite.sql.validate.SqlValidatorException <init> *SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: DEFAULT is only allowed for optional parameters* Apr 13, 2016 8:48:51 AM org.apache.calcite.runtime.CalciteException <init> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 76 to line 1, column 115: DEFAULT is only allowed for optional parameters Error: VALIDATION ERROR: From line 1, column 76 to line 1, column 115: DEFAULT is only allowed for optional parameters SQL Query null [Error Id: 0e17e5a8-9b34-46a4-a029-441d1a305fd1 on 172.30.1.144:31010] (state=,code=0) Issue #2 - I can't specify a tab delimiter in the table function because it maybe counts the characters rather than trying to interpret as a character escape code? 0: jdbc:drill:zk=local> select columns[0] as a, cast(columns[1] as bigint) as b from table(dfs.tmp.`sample_cast.tsv`(type => 'text', fieldDelimiter => '\t', skipFirstLine => true)); *Error: PARSE ERROR: Expected single character but was String: \t* table sample_cast.tsv parameter fieldDelimiter SQL Query null [Error Id: 3efa82e1-3810-4d4a-b23c-32d6658dffcf on 172.30.1.144:31010] (state=,code=0) ---- Vince Gonzalez Systems Engineer 212.694.3879 mapr.com
