Uploaded image for project: 'Oozie'
  1. Oozie
  2. OOZIE-1960

Cannot create a Hive table in ORC format using the Hive action of Oozie

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.0.0
    • Fix Version/s: 4.0.0
    • Component/s: None
    • Labels:
      None
    • Environment:

      CDH5-Hive.12,Oozie 4.0,

      Description

      CREATE TABLE schema1.test (col1 BIGINT,col2 BIGINT )
      ROW FORMAT DELIMITED
      FIELDS TERMINATED BY '|'
      STORED AS ORC;

      Above query works fine when submitted through Hive command prompt.But fails with the following error when submitted through Hive action of Oozie

      ARN: Error getting Hadoop Job IDs executed by Hive
      java.lang.NullPointerException
      at java.io.File.<init>(File.java:277)
      at org.apache.oozie.action.hadoop.HiveMain.writeExternalChildIDs(HiveMain.java:287)
      at org.apache.oozie.action.hadoop.HiveMain.run(HiveMain.java:265)
      at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:38)
      at org.apache.oozie.action.hadoop.HiveMain.main(HiveMain.java:64)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:226)
      at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
      at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:417)
      at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)
      at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
      at java.security.AccessController.doPrivileged(Native Method)
      at javax.security.auth.Subject.doAs(Subject.java:415)
      at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1548)
      at org.apache.hadoop.mapred.Child.main(Child.java:262)
      Intercepting System.exit(-101)

      <<< Invocation of Main class completed <<<

      Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.HiveMain], exit code [-101]

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              anuroopa george Anuroopa George
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: