Hive / HCatalog Forum

Hive Error: Execution Error Return Code 3

  • #39451
    Nick Martin
    Participant

    Hi,

    I’m trying to do a join in Hive and when I execute the query I get the following error:

    FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.MapredLocalTask

    We’re on HDP 1.3.2

    Query syntax is pretty simple:

    SELECT
    t1.col1,
    t2.col2
    FROM t1
    JOIN t2
    ON (t1.col1=t2.col1)

    The fields being joined are both BIGINT. One table is ~40GB combined, the other is substantially smaller.

    Need any additional info?

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #39556
    Yi Zhang
    Moderator

    Hi Nick,

    Is t2 the bigger table? How small is the smaller table?
    Can you check these hive settings:
    set hive.auto.convert.join;
    set hive.mapjoin.smalltable.filesize;

    Also a full log of the failed job?

    Thanks,
    Yi

    #39557
    Nick Martin
    Participant

    Hi Yi,

    I have an update on this. The error I reported above was a result of a Hive query executed within Hue. When I tried the same query in Hive CLI it worked just fine.

    Does that change any of your requests for additional data? If not, I’ll check those settings and get the log for you to review.

    Thanks for the help,
    Nick

    #39602
    Yi Zhang
    Moderator

    Hi Nick,

    Hue goes through hiveserver2. Can you try the query in beeline client?

    Thanks,
    Yi

    #39645
    Nick Martin
    Participant

    No luck on executing via beeline:

    Error: Error while processing statement: FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.MapredLocalTask (state=08S01,code=3)

    #41151
    Yi Zhang
    Moderator

    Hi Nick,

    Can you post the error message from hiveserver2.log/out about this failed query?

    Thanks,
    Yi

    #42772
    Nick Martin
    Participant

    Thanks for your help, Yi. I actually fixed this by upping the java heap size to 1024

The topic ‘Hive Error: Execution Error Return Code 3’ is closed to new replies.

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.