The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

Hive / HCatalog Forum

Error with join

  • #48404
    Andrey Ivanov
    Participant

    Hello all, trying to run script
    select * from s1 where s_ik = ‘1’

    where s1 is:
    CREATE OR REPLACE VIEW s1 AS
    SELECT
    main.*,
    CASE t1.name
    WHEN ” THEN main.name
    ELSE ”
    END as name_fixed,
    CASE t2.name
    WHEN ” THEN main.name2
    ELSE ”
    END as name2_fixed
    FROM
    main
    left join pre_table t1 on main.name = t1.name
    left join pre_table t2 on main.name2 = t2.name

    When pre_table is limit 1000000 it works. Without limit it returns error:

    4/02/10 02:32:47 INFO mr.MapredLocalTask: Executing: /usr/lib/hadoop/bin/hadoop jar /usr/lib/hive/lib/hive-exec-0.12.0.2.0.6.1-101.jar org.apache.hadoop.hive.ql.exec.mr.ExecDriver -localtask -plan file:/tmp/hue/hive_2014-02-10_02-32-47_026_6637299637707327990-39/-local-10007/plan.xml -jobconffile file:/tmp/hue/hive_2014-02-10_02-32-47_026_6637299637707327990-39/-local-10008/jobconf.xml
    Execution failed with exit status: 3
    14/02/10 02:33:03 ERROR exec.Task: Execution failed with exit status: 3
    Obtaining error information
    14/02/10 02:33:03 ERROR exec.Task: Obtaining error information

    Task failed!
    Task ID:
    Stage-7

    Logs:

    14/02/10 02:33:03 ERROR exec.Task:
    Task failed!
    Task ID:
    Stage-7

    Logs:

    14/02/10 02:33:03 ERROR mr.MapredLocalTask: Execution failed with exit status: 3
    14/02/10 02:33:03 INFO ql.Driver: </PERFLOG method=task.MAPREDLOCAL.Stage-7 start=1392028367152 end=1392028383224 duration=16072>
    FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
    14/02/10 02:33:03 ERROR ql.Driver: FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
    14/02/10 02:33:03 INFO ql.Driver: </PERFLOG method=Driver.execute start=1392028367151 end=1392028383224 duration=16073>
    14/02/10 02:33:03 ERROR beeswax.BeeswaxServiceImpl: Exception while processing query
    BeeswaxException(message:Driver returned: 3. Errors: OK
    Total MapReduce jobs = 2
    Execution failed with exit status: 3
    Obtaining error information

    Task failed!
    Task ID:
    Stage-7

    Logs:

    FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
    , log_context:4863c35d-a88b-4729-a234-e17047ca0075, handle:QueryHandle(id:4863c35d-a88b-4729-a234-e17047ca0075, log_context:4863c35d-a88b-4729-a234-e17047ca0075), SQLState: )
    at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState.execute(BeeswaxServiceImpl.java:351)
    at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState$1$1.run(BeeswaxServiceImpl.java:609)
    at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState$1$1.run(BeeswaxServiceImpl.java:598)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:337)
    at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1471)
    at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState$1.run(BeeswaxServiceImpl.java:598)
    at java.util.concurrent.Executors$RunnableAdapter.call

  • Author
    Replies
  • #48405
    Andrey Ivanov
    Participant

    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)
    14/02/10 02:33:03 ERROR security.UserGroupInformation: PriviledgedActionException as:hdfs (auth:SIMPLE) cause:BeeswaxException(message:Driver returned: 3. Errors: OK
    Total MapReduce jobs = 2
    Execution failed with exit status: 3
    Obtaining error information

    Task failed!
    Task ID:
    Stage-7

    Logs:

    FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
    , log_context:4863c35d-a88b-4729-a234-e17047ca0075, handle:QueryHandle(id:4863c35d-a88b-4729-a234-e17047ca0075, log_context:4863c35d-a88b-4729-a234-e17047ca0075), SQLState: )
    14/02/10 02:33:03 ERROR beeswax.BeeswaxServiceImpl: Caught unexpected exception.
    java.lang.reflect.UndeclaredThrowableException
    at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1504)
    at com.cloudera.beeswax.BeeswaxServiceImpl.doWithState(BeeswaxServiceImpl.java:772)
    at com.cloudera.beeswax.BeeswaxServiceImpl.fetch(BeeswaxServiceImpl.java:980)
    at com.cloudera.beeswax.api.BeeswaxService$Processor$fetch.getResult(BeeswaxService.java:987)
    at com.cloudera.beeswax.api.BeeswaxService$Processor$fetch.getResult(BeeswaxService.java:971)
    at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
    at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
    at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)
    Caused by: BeeswaxException(message:Driver returned: 3. Errors: OK
    Total MapReduce jobs = 2
    Execution failed with exit status: 3
    Obtaining error information

    Task failed!
    Task ID:
    Stage-7

    Logs:

    FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
    , log_context:4863c35d-a88b-4729-a234-e17047ca0075, handle:QueryHandle(id:4863c35d-a88b-4729-a234-e17047ca0075, log_context:4863c35d-a88b-4729-a234-e17047ca0075), SQLState: )
    at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState.execute(BeeswaxServiceImpl.java:351)
    at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState$1$1.run(BeeswaxServiceImpl.java:609)
    at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState$1$1.run(BeeswaxServiceImpl.java:598)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:337)
    at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1471)
    at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState$1.run(BeeswaxServiceImpl.jav

The forum ‘Hive / HCatalog’ is closed to new topics and 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.