[
https://issues.apache.org/jira/browse/DRILL-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15396906#comment-15396906
]
Aman Sinha commented on DRILL-4806:
-----------------------------------
During Calcite planning we don't know the data type of first_name and it is
treated as 'ANY' type. That's why this generates a run time error.
Agree that this error message is unrelated to window function or DRILL-2330.
It might even be a duplicate.
> 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)
