[jira] [Commented] (DRILL-8048) Ability to cast unsigned int to int & float

["James Turton (Jira)" <ji...@apache.org>]

    [ 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)