Support Questions

ramus_plsql · ‎12-03-2016

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:hdfs://quickstart.cloudera:8020/user/cloudera/emp1/emp.txt is not a directory or unable to create one)

rajkumar_singh · ‎12-03-2016

@Ram M

can you try create table like this

create external table emp1(eno int,

ename string,

sal string)

row format delimited

fields terminate by '~'

location '/tmp';

this will create a table with name emp1 on hdfs under /tmp location. seems you are following some cloudera documentation to create table on hdp platform but user cloudera won't exist on HDP thats why you are facing problem.

View solution in original post

rajkumar_singh · ‎12-03-2016

you need to explicitly load data using load data inpath into table

ramus_plsql · ‎12-05-2016

Thanks Raj

Cloudera Community

Support Questions

I am getting below error while creating external table