Zoltán Borók-Nagy created IMPALA-11168:
------------------------------------------

             Summary: Add pseudo-columns for Impala
                 Key: IMPALA-11168
                 URL: https://issues.apache.org/jira/browse/IMPALA-11168
             Project: IMPALA
          Issue Type: Bug
          Components: Backend, Frontend
            Reporter: Zoltán Borók-Nagy


Hive Supports a few pseudo-column (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.1#820001)

Reply via email to