[jira] [Created] (DRILL-5225) Needs better error message for table function when having incorrect table path

["Krystal (JIRA)" <ji...@apache.org>]

Krystal created DRILL-5225:
------------------------------

             Summary: Needs better error message for table function when having incorrect table path
                 Key: DRILL-5225
                 URL: https://issues.apache.org/jira/browse/DRILL-5225
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.9.0, 1.10.0
            Reporter: Krystal


When schema is missing from table path or full path to table is not given, the error message displayed is very misleading.  For example, the query below runs successfully with correct table path:

select columns[0],columns[1],columns[2] from table(`dfs.drillTestDir`.`/table_function/header.csv`(type=>'text',lineDelimiter=>'\r\n',fieldDelimiter=>',',skipFirstLine=>true));
+---------+---------+---------+
| EXPR$0  | EXPR$1  | EXPR$2  |
+---------+---------+---------+
| 1       | aaa     | bbb     |
| 2       | ccc     | ddd     |
| 3       | eee     | null    |
| 4       | fff     | ggg     |
+---------+---------+---------+

However if the part of the path is left out, for example the schema, then a very misleading error is thrown:

SQL>select columns[0] from table(`table_function/cr_lf.csv`(type=>'text', lineDelimiter=>'\r\n'))
1: SQLPrepare = [MapR][Drill] (1040) Drill failed to execute the query: select columns[0] from table(`table_function/cr_lf.csv`(type=>'text', lineDelimiter=>'\r\n'))
[30027]Query execution error. Details:[
SYSTEM ERROR: SqlValidatorException: No match found for function signature table_function/cr_lf.csv(type => <CHARACTER>, lineDelimiter => <CHARACTER>)

Error should indicate that table `table_function/cr_lf.csv` is not found.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)