[jira] [Created] (SPARK-29316) CLONE - schemaInference option not to convert strings with leading zeros to int/long

["Ambar Raghuvanshi (Jira)" <ji...@apache.org>]

Ambar Raghuvanshi created SPARK-29316:
-----------------------------------------

             Summary: 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: Improvement
          Components: Spark Core
    Affects Versions: 2.1.0, 2.1.1, 2.2.0, 2.3.0
            Reporter: Ambar Raghuvanshi


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