drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4943) need better error message - DrillRuntimeException: Failure while materializing expression in constant expression evaluator
Date Wed, 12 Oct 2016 19:13:20 GMT
Khurram Faraaz created DRILL-4943:
-------------------------------------

             Summary: need better error message  - DrillRuntimeException: Failure while materializing
expression in constant expression evaluator
                 Key: DRILL-4943
                 URL: https://issues.apache.org/jira/browse/DRILL-4943
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types
    Affects Versions: 1.9.0
         Environment: Drill 1.9.0
            Reporter: Khurram Faraaz
            Priority: Minor


We need a better error message , rather than DrillRuntimeException

{noformat}
0: jdbc:drill:schema=dfs.tmp> SELECT case res1 WHEN true THEN res1 ELSE null END
. . . . . . . . . . . . . . > FROM
. . . . . . . . . . . . . . > (
. . . . . . . . . . . . . . >       SELECT
. . . . . . . . . . . . . . >          (CASE WHEN (false) THEN null ELSE 1 end) res1
. . . . . . . . . . . . . . >      FROM (values(1))
. . . . . . . . . . . . . . > );
Error: SYSTEM ERROR: DrillRuntimeException: Failure while materializing expression in constant
expression evaluator [CASE(=(CASE(false, null, 1), true), CASE(false, null, 1), null)].  Errors:
Error in expression at index -1.  Error: Missing function implementation: [castINT(BIT-REQUIRED)].
 Full expression: --UNKNOWN EXPRESSION--.


[Error Id: 1fba5a4e-89b6-415c-8982-97bf841869ef on centos-01.qa.lab:31010] (state=,code=0)
{noformat}

Calcite gives a very easy to understand message
{noformat}
0: jdbc:calcite:model=target/test-classes/mod> SELECT case res1 WHEN true THEN res1 ELSE
null END
. . . . . . . . . . . . . . . . . . . . . . .> FROM
. . . . . . . . . . . . . . . . . . . . . . .> (
. . . . . . . . . . . . . . . . . . . . . . .>       SELECT
. . . . . . . . . . . . . . . . . . . . . . .>          (CASE WHEN (false) THEN null ELSE
1 end) res1
. . . . . . . . . . . . . . . . . . . . . . .>      FROM (values(1)) foo
. . . . . . . . . . . . . . . . . . . . . . .> ) foobar ;
Error: Error while executing SQL "SELECT case res1 WHEN true THEN res1 ELSE null END
FROM
(
      SELECT
         (CASE WHEN (false) THEN null ELSE 1 end) res1
     FROM (values(1)) foo
) foobar ": From line 1, column 8 to line 1, column 50: Cannot apply '=' to arguments of type
'<INTEGER> = <BOOLEAN>'. Supported form(s): '<COMPARABLE_TYPE> = <COMPARABLE_TYPE>'
(state=,code=0)
{noformat}



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

Mime
View raw message