Running pig and hcatalog in OOzie Workflow in Hue

[Harsh J Cloudera Employee]

While adding the hive-site.xml properties is the right way to make HCatalog
find your tables, unless your hive-site.xml actually points to the HMS or
DB that carries the Hive MetaStore, it won't be able to discover the tables.

If you use CM, try fetching the hive-site.xml from the zip found via CM ->
Hive -> Actions -> Download Client Configuration, or pick it up from a Hive
Gateway hosts' /etc/hive/conf/hive-site.xml.

[GordINV]

I use CM and used that to fetch the correct hive-site.xml file.  I previous used linux and the find command.  I was able to execute my script now.  Thanks for the assistance.

[ahmedreda]

Thank you downloading the right hive-site.xml from cloudera manager really helps.