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

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

VotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.0.0
    • 4.0.0
    • None
    • None
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment