Try creating /user/hive/warehouse/ directory if it does not exists , and check it has write permission for the user. Note the lower case ‘user’ in the path.
> On Feb 24, 2016, at 2:42 PM, skunkwerk <skunkw...@gmail.com> wrote: > > I have downloaded the Spark binary with Hadoop 2.6. > When I run the spark-sql program like this with the CSV library: > ./bin/spark-sql --packages com.databricks:spark-csv_2.11:1.3.0 > > I get into the console for spark-sql. > However, when I try to import a CSV file from my local filesystem: > > CREATE TABLE customerview USING com.databricks.spark.csv OPTIONS (path > "/Users/imran/Downloads/test.csv", header "true", inferSchema "true"); > > I get the following error: > org.apache.hadoop.hive.ql.metadata.HiveException: > MetaException(message:file:/user/hive/warehouse/test is not a directory or > unable to create one) > > http://pastebin.com/BfyVv14U > > How can I fix this? > > thanks > > > > -- > View this message in context: > http://apache-spark-user-list.1001560.n3.nabble.com/Error-reading-a-CSV-tp26329.html > Sent from the Apache Spark User List mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@spark.apache.org > For additional commands, e-mail: user-h...@spark.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org
