Hello there, I recently posted this question in the hadoop-user mailing list and somebody suggested I might have more luck here…
I have an Oozie workflow that is failing on a Hive action with the following error: FAILED: SemanticException [Error 10001]: Table not found > attempted_calls_import_raw_logs_named_route_name If I run the query file from the command line (as described in the map task log), it works fine: hive --hivevar WORKING_DIR=/user/lpadm/working/attempted_calls --hivevar TABLE_NAME=attempted_calls_import_raw_logs_named_route_name -f hive-named_route_name.q Below are the contents of hive-named_route_name.q and the full output of the failing map task log can be found at https://gist.github.com/fc665aacb3aa9c663f04 — any ideas? DROP TABLE IF EXISTS ${TABLE_NAME}; CREATE EXTERNAL TABLE ${TABLE_NAME} ( named_route_name_id bigint, prefix string, handle string, name string, iso2 string, country_handle string, country_name string, dial_code string, category string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY '\002' MAP KEYS TERMINATED BY '\003' STORED AS SequenceFile LOCATION '${WORKING_DIR}/${TABLE_NAME}' ; SET hive.exec.compress.output=true; SET io.seqfile.compression.type=BLOCK; INSERT INTO TABLE ${TABLE_NAME} SELECT nrn.named_route_name_id, nrn.prefix, nrn.handle, nrn.name, nrn.iso2, nrn.country_handle, nrn.country_name, nrn.dial_code, nrn.category FROM named_route_name nrn ORDER BY nrn.prefix ASC ; -- Best wishes, Dave Cardwell. http://davecardwell.co.uk/
