Home Forums Hive / HCatalog Error with join

This topic contains 1 reply, has 1 voice, and was last updated by  Andrey Ivanov 6 months, 1 week ago.

  • Creator
    Topic
  • #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

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

  • 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

    Collapse
Viewing 1 replies (of 1 total)