You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Parth Chandra (JIRA)" <ji...@apache.org> on 2015/06/18 07:26:00 UTC
[jira] [Updated] (DRILL-2558) Four different errors are returned
when running one COALESCE with multiple arguments of incompatible data
types
[ https://issues.apache.org/jira/browse/DRILL-2558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra updated DRILL-2558:
---------------------------------
Assignee: Mehant Baid (was: Daniel Barclay (Drill))
> 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: Mehant Baid
> 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)