Reply
Explorer
Posts: 7
Registered: ‎01-19-2017

Re: CREATE TABLE AS SELECT returns error 'Failed to open HDFS file for writing'

@venkatsambath
I did not do those actions! Must have missed that, thank you for pointing it out. Everything is working as expected now.
Cloudera Employee
Posts: 25
Registered: ‎12-11-2015

Re: CREATE TABLE AS SELECT returns error 'Failed to open HDFS file for writing'

You're welcome!

Cloudera Employee
Posts: 290
Registered: ‎10-16-2013

Re: CREATE TABLE AS SELECT returns error 'Failed to open HDFS file for writing'

Are you running with HDFS HA (i.e. a setup with an active and a standby NN)? It is a known issue that Impala CTAS may not work with HDFS HA. As a workaround, CREATE+INSERT should work.

Explorer
Posts: 7
Registered: ‎01-19-2017

Re: CREATE TABLE AS SELECT returns error 'Failed to open HDFS file for writing'

@alex.behm

No, I'm not. I just missed a final step when I moved our primary NN, which @venkatsambath pointed out.
Highlighted
Cloudera Employee
Posts: 290
Registered: ‎10-16-2013

Re: CREATE TABLE AS SELECT returns error 'Failed to open HDFS file for writing'

Thanks!
Announcements