You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Ambar Raghuvanshi (Jira)" <ji...@apache.org> on 2019/10/01 13:13:00 UTC
[jira] [Updated] (SPARK-29316) CLONE - schemaInference option not
to convert strings with leading zeros to int/long
[ https://issues.apache.org/jira/browse/SPARK-29316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ambar Raghuvanshi updated SPARK-29316:
--------------------------------------
Priority: Critical (was: Major)
> CLONE - schemaInference option not to convert strings with leading zeros to int/long
> -------------------------------------------------------------------------------------
>
> Key: SPARK-29316
> URL: https://issues.apache.org/jira/browse/SPARK-29316
> Project: Spark
> Issue Type: Bug
> Components: Spark Core
> Affects Versions: 2.1.0, 2.1.1, 2.2.0, 2.3.0
> Reporter: Ambar Raghuvanshi
> Priority: Critical
> Labels: csv, csvparser, easy-fix, inference, ramp-up, schema
>
> It would be great to have an option in Spark's schema inference to *not* to convert to int/long datatype a column that has leading zeros. Think zip codes, for example.
> {code}
> df = (sqlc.read.format('csv')
> .option('inferSchema', True)
> .option('header', True)
> .option('delimiter', '|')
> .option('leadingZeros', 'KEEP') # this is the new proposed option
> .option('mode', 'FAILFAST')
> .load('csvfile_withzipcodes_to_ingest.csv')
> )
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org