[jira] [Commented] (DRILL-7893) Column alias is not working for a parquet file

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

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

ASF GitHub Bot commented on DRILL-7893:
---------------------------------------

vvysotskyi opened a new pull request #2208:
URL: https://github.com/apache/drill/pull/2208


   # [DRILL-7893](https://issues.apache.org/jira/browse/DRILL-7893): Column alias is not working for a parquet file
   
   ## Description
   Updated visitors applied after optimizations to prevent creating unnecessary copies that will lose actual row type.
   Added a call to create a top project after all optimizations to ensure that column names will match the name from row type.
   
   ## Documentation
   NA
   
   ## Testing
   Added unit test.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> Column alias is not working for a parquet file
> ----------------------------------------------
>
>                 Key: DRILL-7893
>                 URL: https://issues.apache.org/jira/browse/DRILL-7893
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Parquet
>    Affects Versions: 1.17.0
>            Reporter: Matthias Rosenthaler
>            Assignee: Vova Vysotskyi
>            Priority: Major
>             Fix For: 1.19.0
>
>         Attachments: values.parquet
>
>
> The following query results in a column name of "shot_id" instead of the expected "x".
> SELECT shot_id as x FROM values.parquet WHERE step = 'RPCurve_001'
> The strange thing is, if I modify the query, like adding a limit clause, it is working:
> SELECT shot_id as x FROM values.parquet WHERE step = 'RPCurve_001' LIMIT 1000
> [^values.parquet]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)