Thanks Suresh, that worked like a charm! I created the /user/hive/warehouse directory and chmod'd to 777.
regards, imran On Wed, Feb 24, 2016 at 2:48 PM, Suresh Thalamati < suresh.thalam...@gmail.com> wrote: > 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 > > > >