LOAD DATA LOCAL INPUT PATH doesnt exist

Question

I am new to the Spark and Scala Technology. I'm getting the following exception while trying to load a file from local file system into table using Spark. Spark version -2.0 and Scala version - 2.11

scala> sqlContext.sql("LOAD DATA LOCAL INPATH 'file.txt' INTO TABLE student")

org.apache.spark.sql.AnalysisException: LOAD DATA input path does not exist: file.txt

is the file present in the path from where spark-shell has been initialised? please try by providing the complete path of the file . — Rajat Mishra
– Rajat Mishra, Commented Jan 8, 2017 at 6:20
@Sipra - are you working in "spark local mode"? do you have several executors? — Yaron
– Yaron, Commented Jan 8, 2017 at 7:58

Gurwinder Singh · Accepted Answer · 2017-01-08 08:10:24Z

1

Please try to give complete path as file:/complete path to the file.

In above case:

sqlContext.sql("LOAD DATA LOCAL INPATH 'file:/complete path to the file.txt' INTO TABLE student")

~Kedar

edited Jan 8, 2017 at 8:10

Gurwinder Singh

39.7k6 gold badges62 silver badges87 bronze badges

answered Jan 8, 2017 at 6:23

Kedar S. Dixit

7010 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

LOAD DATA LOCAL INPUT PATH doesnt exist

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related