Jason Gauci created DRILL-8048:
----------------------------------

             Summary: 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


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.1#820001)

Reply via email to