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

Re: Running Sqoop via Oozie causes ERROR 42X05: Table/View 'DBS' does not exist

Mentor

@Artur Bukowski

Did you set this in the oozie user's .profile or bashrc

HADOOP_CLASSPATH=$(hcat -classpath) 
export HADOOP_CLASSPATH

Can you attach the new error stack.

Re: Running Sqoop via Oozie causes ERROR 42X05: Table/View 'DBS' does not exist

Hi Geoffrey,

Thanks for answering!

To be precise, I did this for all users:

[root@server ~]# cat /etc/profile.d/hadoop-env.sh
export HADOOP_CLASSPATH=$(hcat -classpath)

I also double checked that oozie user has HADOOP_CLASSPATH defined and set (lot of jars).

Unfortunately, error stack is the same.

Re: Running Sqoop via Oozie causes ERROR 42X05: Table/View 'DBS' does not exist

New Contributor

Hi,

 

did you run the sqoop command on command line? 

like:

sqoop export .... --table xpto  --hcatalog-home /opt/cloudera/parcels/CDH/lib/hive-hcatalog/ --hcatalog-database default --hcatalog-table tout_table_xpto --verbose

 

Does it work?

 

I'm also facing the same error on oozie wf and sqoop in hue. The hive metastore is working just fine the somehow oozie/sqoop can not fund the right hive metastore info