[
https://issues.apache.org/jira/browse/SPARK-37980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Prakhar Jain updated SPARK-37980:
---------------------------------
Description:
Spark recently added hidden metadata column support for File based datasources
as part of SPARK-37273.
We should extend it to support ROW_INDEX/ROW_POSITION also.
Meaning of ROW_POSITION
ROW_INDEX/ROW_POSITION is basically an index of a row within a file. E.g. 5th
row in the file will have ROW_INDEX 5.
Use cases:
Row Indexes can be used in a variety of ways. A (fileName, rowIndex) tuple
uniquely identifies row in a table. This information can be used to mark rows
e.g. this can be used by indexer etc.
was:
Spark recently added hidden metadata column support for File based datasources
as part of SPARK-37273.
We should extend it to support ROW_INDEX also.
Definition:
ROW_INDEX is basically an index of a row within a file. E.g. 5th row in the
file will have ROW_INDEX 5.
Use cases:
Row Indexes can be used in a variety of ways. A (fileName, rowIndex) tuple
uniquely identifies row in a table. This information can be used to mark rows.
An Index can be easily created using the Row Indexes.
> Extend METADATA column to support row indices for file based data sources
> -------------------------------------------------------------------------
>
> Key: SPARK-37980
> URL: https://issues.apache.org/jira/browse/SPARK-37980
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.3
> Reporter: Prakhar Jain
> Priority: Major
>
> Spark recently added hidden metadata column support for File based
> datasources as part of SPARK-37273.
> We should extend it to support ROW_INDEX/ROW_POSITION also.
>
> Meaning of ROW_POSITION
> ROW_INDEX/ROW_POSITION is basically an index of a row within a file. E.g. 5th
> row in the file will have ROW_INDEX 5.
>
> Use cases:
> Row Indexes can be used in a variety of ways. A (fileName, rowIndex) tuple
> uniquely identifies row in a table. This information can be used to mark rows
> e.g. this can be used by indexer etc.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
