Sorry for the delay. Glad you find the solution. ... View more

This worked for me: --remove existing directory sudo -u hdfs hadoop fs rm /user/hive/warehouse/original_access_logs   --create the directory again   --see the results. must be drwxr ... hadoop fs -ls /user/hive/warehouse --Found 9 items drwxr-xr-x - cloudera hive 0 2015-10-03 18:51 /user/hive/warehouse/categories drwxr-xr-x - cloudera hive 0 2015-10-03 18:52 /user/hive/warehouse/customers drwxr-xr-x - cloudera hive 0 2015-10-03 18:53 /user/hive/warehouse/departments drwxr-xr-x - cloudera hive 0 2015-10-03 18:53 /user/hive/warehouse/order_items drwxr-xr-x - cloudera hive 0 2015-10-03 18:54 /user/hive/warehouse/orders drwxr-xr-x - hdfs hive 0 2015-10-03 21:17 /user/hive/warehouse/original_access_logs drwxr-xr-x - hdfs hive 0 2015-10-03 19:33 /user/hive/warehouse/originala_access_logs drwxr-xr-x - cloudera hive 0 2015-10-03 18:55 /user/hive/warehouse/products drwxrwxrwx - admin hive 0 2015-10-03 20:37 /user/hive/warehouse/tokenized_access_logs ... View more

This is what i get when executing the query:   Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:hdfs://quickstart.cloudera:8020/user/hive/warehouse/original_access_logs is not a directory or unable to create one) (state=08S01,code=1) 0: jdbc:hive2://quickstart:10000/default> ... View more