[
https://issues.apache.org/jira/browse/DRILL-8048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17608716#comment-17608716
]
James Turton commented on DRILL-8048:
-------------------------------------
Hi would you mind retesting this using Drill master? We recently overhauled
Drill's implict casting in DRILL-8136 and different cast target might be
selected now. The images labelled master-* in Docker Hub are built from Drill
master automatically.
> Ability to cast unsigned int to int & float
> -------------------------------------------
>
> Key: DRILL-8048
> URL: https://issues.apache.org/jira/browse/DRILL-8048
> Project: Apache Drill
> Issue Type: Improvement
> Affects Versions: 1.19.0
> Reporter: Jason Gauci
> Priority: Major
>
> Loading a parquet file with an unsigned int64 and trying to group by that
> column fails because the casts from unsigned int to int/float are not
> implemented. Added uint casts to Casts.tdd fixes the issue.
>
> Before:
> {{apache drill> SELECT map_id FROM dfs.`...` group by map_id;}}
> {{{}Error: INTERNAL_ERROR ERROR: Failure while materializing
> expression.{}}}{{{}Errors:{}}}
> {{Error in expression at index 1. Error: Missing function implementation:
> [castFLOAT4(UINT8-OPTIONAL)]. Full expression: --UNKNOWN EXPRESSION-.}}
> {{{}Fragment: 3:2{}}}{{{}Please, refer to logs for more
> information.{}}}{{{}[Error Id: e521b4d4-3138-49d7-8284-58377af97238 on
> localhost:31010] (state=,code=0){}}}
>
> After, it works as expected.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
