[
https://issues.apache.org/jira/browse/SPARK-42359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17684689#comment-17684689
]
Willi Raschkowski commented on SPARK-42359:
-------------------------------------------
This repeats SPARK-26406 but it's worth reconsidering now that SQL / DataFrame
APIs established themselves as "preferred" way to interact with Spark and
platforms like Databricks SQL increase collaboration with less-technical users.
Meanwhile, the RDD and {{zipWithIndex}} workaround is awkward because it
implies some ordering that can't be assumed at the RDD-level but the datasource
_can_ assume at the CSV-level.
> Support row skipping when reading CSV files
> -------------------------------------------
>
> Key: SPARK-42359
> URL: https://issues.apache.org/jira/browse/SPARK-42359
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.3.1
> Reporter: Willi Raschkowski
> Priority: Major
> Attachments: Screenshot 2023-02-06 at 13.23.34.png
>
>
> Spark currently can't read CSV files that contain lines with comments or
> annotations above the header and data. Work-arounds include pre-processing
> CSVs, or using RDDs and something like {{zipWithIndex}}. But all of these
> increase friction for less technical users.
> This issue proposes a {{skipLines}} option for Spark's CSV parser to drop a
> number of unwanted lines at the top of a CSV file.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
