[
https://issues.apache.org/jira/browse/SPARK-42359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17689008#comment-17689008
]
Ted Chester Jenks commented on SPARK-42359:
-------------------------------------------
I have a PR that implements this feature: [[SPARK-42359][SQL] Support row
skipping when reading CSV files by ted-jenks · Pull Request #39907 ·
apache/spark (github.com)|https://github.com/apache/spark/pull/39907/files]
> 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]
