[jira] [Created] (ARROW-11013) [Rust] CSV Reader cannot handle leading/trailing WhiteSpace

["Mike Seddon (Jira)" <ji...@apache.org>]

Mike Seddon created ARROW-11013:
-----------------------------------

             Summary: [Rust] CSV Reader cannot handle leading/trailing WhiteSpace
                 Key: ARROW-11013
                 URL: https://issues.apache.org/jira/browse/ARROW-11013
             Project: Apache Arrow
          Issue Type: Bug
          Components: Rust, Rust - DataFusion
    Affects Versions: 2.0.0
            Reporter: Mike Seddon


Currently the CSV Reader assumes very clean input data which does not have things like leading spaces. This means parsing data like the TPC-H 'answers' set from the databricks/tpch_dbgen repo does not work (like below).

Spark uses the Univocity parser library provides the options 'ignoreLeadingWhitespace' and 'ignoreTrailingWhitespace' which would help fix this issue.

```
l|l|sum_qty|sum_base_price|sum_disc_pricesum_chargeavg_qtyavg_priceavg_disccount_order           
A|F|37734107.00|56586554400.73|53758257134.87|55909065222.83|25.52|38273.13|0.05|               1478493
```



--
This message was sent by Atlassian Jira
(v8.3.4#803005)