drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5225) Needs better error message for table function when having incorrect table path
Date Thu, 26 Jan 2017 18:31:24 GMT
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)

Mime
View raw message