sql - 配置单元加入失败 mr.MapredLocalTask

Question

我是 HIVE 和 HADOOP 的新手，在这里我试图在 hive 中加入两个示例表，其中表没有任何主外键关系只是为了练习:- 表格如下

  Employees table:-
                id   name    gender   salary  departmentid      

                 1    mark      male    3333    1
                 2    Steve     male    5464    3
                 3    Ben       male    3873    2
                 4    bender    male    9298    1
                 5    fender    male    654     2

 departments table:-
             id    name     location

             1     IT        NEW YORK
             2     HR        LONDON
             3     PAYROLL   SYDNEY  

hive>  select employees.name as employee_name, departments.name as department_name
    >  from employees         
    >  join departments on departments.id = employees.departmentid;

结果:-

Query ID = cloudera_20170911030505_93378edb-f8b8-45d0-9141-3fe065211f3d Total jobs = 1 FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask

因为我是 Hive 的新手，所以建议我如何解决这个错误？任何帮助，将不胜感激。

Answer 1

设置 hive.auto.convert.join=false;解决了我的问题..