You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (Jira)" <ji...@apache.org> on 2022/01/23 01:27:00 UTC
[jira] [Commented] (SPARK-37980) Extend METADATA column to support row indexes for file based data sources
[ 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org