ISSUE WITH HIVE TO HDFS == >
hive (ashoo1234)> create external table movie_ratings1 (id string, id1 string, id2 string,id3 string) row format delimited fields terminated by ’ ’ location ‘/user/ashoo1234/moviesdata/u.data’
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:hdfs://nn01.itversity.com:8020/user/ashoo1234/moviesdata/u.data is not a directory or unable to create one)
Here is the file on HDFS == >
[ashoo1234@gw03 ~]$ hdfs dfs -ls /user/ashoo1234/moviesdata/u.data
-rw-r–r-- 3 ashoo1234 hdfs 1979173 2018-01-27 13:18 /user/ashoo1234/moviesdata/u.data
Since the URL pointed to “nn01” , I tried ssh. but that too failed. “nn01-itversity-com” . Permission denied.