drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2558) Four different errors are returned when running one COALESCE with multiple arguments of incompatible data types
Date Fri, 05 Jun 2015 00:08:37 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14573852#comment-14573852
] 

Victoria Markman commented on DRILL-2558:
-----------------------------------------

Same in 1.0.0

{code}
0: jdbc:drill:schema=dfs> select coalesce(c_varchar, c_integer, c_bigint, c_float, c_double,
c_date, c_time, c_timestamp, c_boolean) from j2;
Error: SYSTEM ERROR: org.apache.drill.exec.exception.SchemaChangeException: Failure while
trying to materialize incoming schema.  Errors:
 
Error in expression at index -1.  Error: Missing function implementation: [castBIT(TIMESTAMP-OPTIONAL)].
 Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1.  Error: Missing function implementation: [castBIT(TIME-OPTIONAL)].
 Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1.  Error: Missing function implementation: [castBIT(DATE-OPTIONAL)].
 Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1.  Error: Missing function implementation: [castFLOAT8(BIT-OPTIONAL)].
 Full expression: --UNKNOWN EXPRESSION--..

Fragment 0:0

[Error Id: e3df965e-e879-4391-bfd5-258cb2ca7086 on atsqa4-133.qa.lab:31010] (state=,code=0)
0: jdbc:drill:schema=dfs> 

{code}

> Four different errors are returned when running one COALESCE with multiple arguments
of incompatible data types
> ---------------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-2558
>                 URL: https://issues.apache.org/jira/browse/DRILL-2558
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>    Affects Versions: 0.8.0
>            Reporter: Victoria Markman
>            Assignee: Daniel Barclay (Drill)
>             Fix For: 1.1.0
>
>
> Drill tries to do implicit cast during runtime,  and we agreed that if particular cast
is not implemented run time exception is fine for now.
> However, it feels weird to get four of them at the same time.
> I think we should throw exception on the first incompatibility and stop processing rest
of the arguments.
> {code}
> 0: jdbc:drill:schema=dfs> select coalesce(c_varchar, c_integer, c_bigint, c_float,
c_double, c_date, c_time, c_timestamp, c_boolean) from j2;
> Query failed: Query stopped., Failure while trying to materialize incoming schema.  Errors:
>  
> Error in expression at index -1.  Error: Missing function implementation: [castBIT(TIMESTAMP-OPTIONAL)].
 Full expression: --UNKNOWN EXPRESSION--.
> Error in expression at index -1.  Error: Missing function implementation: [castBIT(TIME-OPTIONAL)].
 Full expression: --UNKNOWN EXPRESSION--.
> Error in expression at index -1.  Error: Missing function implementation: [castBIT(DATE-OPTIONAL)].
 Full expression: --UNKNOWN EXPRESSION--.
> Error in expression at index -1.  Error: Missing function implementation: [castFLOAT8(BIT-OPTIONAL)].
 Full expression: --UNKNOWN EXPRESSION--.. [ e2effaf7-6fcc-4d7d-b408-2031aab2a344 on atsqa4-133.qa.lab:31010
]
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {code}



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

Mime
View raw message