Support Questions
Find answers, ask questions, and share your expertise

hive create external table problem

hive create external table problem

Explorer

hi, I'm using hiveserver2 on CDH5.4, when I create a external table with location parameter, if the hdfs location directory is not exist, the hiveserver2 will not response any query ,like in a hung state, and it will not to create the directory automaticly.....
on CDH5.0 I haven't meet this problem, please tell me what the problem is?

2 REPLIES 2

Re: hive create external table problem

Expert Contributor

make sure the user you are using has a write permission to the directory you are trying to write on 

Re: hive create external table problem

Explorer

the location dir is not exist before, but I'm very ensure the user has wirte permission on the parent dir of location dir ,  likes user a is the ower of  the hdfs dir '/input/data/recommend' , if I used  user a  which authenticated in hiveserver2 to create a external table `testtable` and set location to '/input/data/recommend/testtable' , the hiveserver2 will be hung, It is so strange