[jira] [Commented] (DRILL-4806) need a better error message

["Gautam Kumar Parai (JIRA)" <ji...@apache.org>]

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

Gautam Kumar Parai commented on DRILL-4806:
-------------------------------------------

[~khfaraaz] This can be reduced to a simple testcase which seems unrelated to Drill-2330. Can you please confirm?

{code}select avg(first_name) from cp.`employee.json`;
Error: SYSTEM ERROR: SchemaChangeException: Failure while trying to materialize incoming schema.  Errors:
Error in expression at index -1.  Error: Missing function implementation: [castINT(BIT-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--..
Fragment 0:0
[Error Id: c36a67a8-c45e-4844-b988-c767316ea834 on 10.250.50.33:31010] (state=,code=0)
{code}

> need a better error message 
> ----------------------------
>
>                 Key: DRILL-4806
>                 URL: https://issues.apache.org/jira/browse/DRILL-4806
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 1.8.0
>            Reporter: Khurram Faraaz
>            Assignee: Gautam Kumar Parai
>            Priority: Minor
>              Labels: window_function
>
> Need a better error message, column c2 is of type CHAR.
> {noformat}
> 0: jdbc:drill:schema=dfs.tmp> SELECT MAX(AVG(c2)) OVER ( PARTITION BY c2 ORDER BY c2 ), c2 FROM `tblWnulls.parquet` GROUP BY c2;
> Error: SYSTEM ERROR: SchemaChangeException: Failure while trying to materialize incoming schema.  Errors:
> Error in expression at index -1.  Error: Missing function implementation: [castINT(BIT-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--..
> Fragment 0:0
> [Error Id: 076464ff-7385-4bee-9704-38dec781af32 on centos-01.qa.lab:31010] (state=,code=0)
> {noformat}



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