hadoop-hdfs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Cardwell <d...@davecardwell.co.uk>
Subject Hive Action Failing in Oozie
Date Wed, 12 Dec 2012 22:27:19 GMT
Hello there,

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/

Mime
View raw message