2 Replies Latest reply on Feb 11, 2018 10:56 PM by Arief Handany

    Problem when extracting joined table using Cloudera Hadoop/Hive

    Arief Handany

      Here is my configuration for my Cloudera Hadoop data connection:

      Type: Hive Server2
      Auth: Username
      ODBC Driver: x64 2.5.25.1020

      Cloudera ver: 5.4

       

      I can successfully connect and extract single table without any problem but whenever i join new table like below (with any configuration):testing.png

      I will encounter this error message whenever i extract:

      [Cloudera][Hardy] (35) Error from server: error code: '1' error message: 'Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask'.

      Unable to create extract


      I have also already tried convert it to custom SQL or using this solutions but the result are the same.

      If you guys have any other solutions please help.