A library for parsing and querying CSV data with Apache Spark, for Spark SQL and DataFrames.
This library requires Spark 1.3+
You can link against this library in your program at the following coordiates:
groupId: com.databricks
artifactId: spark-csv_2.11
version: 1.0.3
This package can be added to Spark using the --jars
command line option. For example, to include it when starting the spark shell:
$ bin/spark-shell --packages com.databricks:spark-csv_2.10:1.0.3
This package allows reading CSV files in local or distributed filesystem as Spark DataFrames. When reading files the API accepts several options:
path
: location of files. Similar to Spark can accept standard Hadoop globbing expressions.header
: when set to true the first line of files will be used to name columns and will not be included in data. All types will be assumed string. Default value is false.delimiter
: by default lines are delimited using ',', but delimiter can be set to any characterquote
: by default the quote character is '"', but can be set to any character. Delimiters inside quotes are ignoredmode
: determines the parsing mode. By default it is PERMISSIVE. Possible values are:PERMISSIVE
: tries to parse all lines: nulls are inserted for missing tokens and extra tokens are ignored.DROPMALFORMED
: drops lines which have fewer or more tokens than expectedFAILFAST
: aborts with a RuntimeException if encounters any malformed line
The package also support saving simple (non-nested) DataFrame. When saving you can specify the delimiter and whether we should generate a header row for the table. See following examples for more details.
These examples use a CSV file available for download here:
$ wget https://github.com/databricks/spark-csv/raw/master/src/test/resources/cars.csv
CSV data can be queried in pure SQL by registering the data as a (temporary) table.
CREATE TABLE cars
USING com.databricks.spark.csv
OPTIONS (path "cars.csv", header "true")
You can also specify column names and types in DDL.
CREATE TABLE cars (yearMade double, carMake string, carModel string, comments string, blank string)
USING com.databricks.spark.csv
OPTIONS (path "cars.csv", header "true")
Spark 1.4+:
import org.apache.spark.sql.SQLContext
val sqlContext = new SQLContext(sc)
val df = sqlContext.read.format("com.databricks.spark.csv").option("header", "true").load("cars.csv")
df.select("year", "model").write.format("com.databricks.spark.csv").save("newcars.csv")
Spark 1.3:
import org.apache.spark.sql.SQLContext
val sqlContext = new SQLContext(sc)
val df = sqlContext.load("com.databricks.spark.csv", Map("path" -> "cars.csv", "header" -> "true"))
df.select("year", "model").save("newcars.csv", "com.databricks.spark.csv")
Spark 1.4+:
import org.apache.spark.sql.SQLContext
SQLContext sqlContext = new SQLContext(sc);
DataFrame sqlContext.read().format("com.databricks.spark.csv").option("header", "true").load("cars.csv");
df.select("year", "model").write().format("com.databricks.spark.csv").save("newcars.csv");
Spark 1.3:
import org.apache.spark.sql.SQLContext
SQLContext sqlContext = new SQLContext(sc);
HashMap<String, String> options = new HashMap<String, String>();
options.put("header", "true");
options.put("path", "cars.csv");
DataFrame df = sqlContext.load("com.databricks.spark.csv", options);
df.select("year", "model").save("newcars.csv", "com.databricks.spark.csv");
Spark 1.4+:
from pyspark.sql import SQLContext
sqlContext = SQLContext(sc)
df = sqlContext.read.format('com.databricks.spark.csv').options(header='true').load('cars.csv')
df.select('year', 'model').write.format('com.databricks.spark.csv').save('newcars.csv')
Spark 1.3:
from pyspark.sql import SQLContext
sqlContext = SQLContext(sc)
df = sqlContext.load(source="com.databricks.spark.csv", header="true", path = "cars.csv")
df.select("year", "model").save("newcars.csv", "com.databricks.spark.csv")
Spark 1.4+:
sqlContext <- sparkRSQL.init(sc)
df <- read.df(sqlContext, "cars.csv", source = “com.databricks.spark.csv”)
write.df(df, "newcars.csv", "com.databricks.spark.csv", "overwrite")
This library is built with SBT, which is automatically downloaded by the included shell script. To build a JAR file simply run sbt/sbt package
from the project root. The build configuration includes support for both Scala 2.10 and 2.11.