[
https://issues.apache.org/jira/browse/SPARK-37980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17480530#comment-17480530
]
Hyukjin Kwon commented on SPARK-37980:
--------------------------------------
I am super curious about this because pandas API on Spark is currently
generating such numbers for row index concept.
> ROW_INDEX is basically an index of a row within a file.
But I don't think this makes much sense. This is virtually what
{{monotonically_increasing_id()}} does.
> Extend METADATA column to support row indexes 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 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.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
