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

["Ruslan Dautkhanov (JIRA)" <ji...@apache.org>]

Ruslan Dautkhanov created SPARK-21978:
-----------------------------------------

             Summary: schemaInference option not to convert strings with leading zeros to int/long 
                 Key: SPARK-21978
                 URL: https://issues.apache.org/jira/browse/SPARK-21978
             Project: Spark
          Issue Type: Improvement
          Components: Spark Core
    Affects Versions: 2.2.0, 2.1.1, 2.1.0, 2.3.0
            Reporter: Ruslan Dautkhanov


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
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org