You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Neil McGuigan (JIRA)" <ji...@apache.org> on 2018/08/22 18:08:00 UTC

[jira] [Created] (SPARK-25199) InferSchema "all Strings" if one of many CSVs is empty

Neil McGuigan created SPARK-25199:
-------------------------------------

             Summary: InferSchema "all Strings" if one of many CSVs is empty
                 Key: SPARK-25199
                 URL: https://issues.apache.org/jira/browse/SPARK-25199
             Project: Spark
          Issue Type: Bug
          Components: Input/Output
    Affects Versions: 2.2.1
         Environment: I discovered this on AWS Glue, which uses Spark 2.2.1
            Reporter: Neil McGuigan


Spark can load multiple CSV files in one read:

df = spark.read.format("csv").option("header", "true").option("inferSchema", "true").load("/*.csv")

However, if one of these files is empty (though it has a header), Spark will set all column types to "String"

Spark should skip a file for inference if it contains no (non-header) rows



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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