[jira] [Commented] (IMPALA-11168) Add pseudo-columns for Impala

["Baike Xia (Jira)" <ji...@apache.org>]

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

Baike Xia commented on IMPALA-11168:
------------------------------------

Hi, [~boroknagyz] , I'm very interested in this question, and i think it will be a challenge for me. Can you assign this ticket to me?

> Add pseudo-columns for Impala
> -----------------------------
>
>                 Key: IMPALA-11168
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11168
>             Project: IMPALA
>          Issue Type: New Feature
>          Components: Backend, Frontend
>            Reporter: Zoltán Borók-Nagy
>            Priority: Major
>
> Hive supports a few pseudo-columns (virtual column):
> [https://cwiki.apache.org/confluence/display/hive/languagemanual+virtualcolumns]
> It would be useful to add support for a few pseudo-columns for Impala as well.
> E.g. to implement support for Iceberg position-based deletes we'd need the file name and ordinal position for each row.
> Hive has {{INPUT_\_FILE_\_NAME}} which returns full URI of the data file. Unfortunately it doesn't have a pseudo-column for the ordinal position of rows. So we need to introduce a new pseudo-column for that, probably with the name {{ORDINAL_\_POSITION_\_INSIDE_\_FILE}}, or stg. like that.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org