oracle.hadoop.exttab.ExternalTableException: Unsupported Hive table serialization library org.apache.hadoop.hive.contrib.serde2.JsonSerde

Oracle Community | 967981 | 3 years ago
  1. 0

    Load JSON from HDFS into ORACLE via OSCH

    Oracle Community | 3 years ago | 967981
    oracle.hadoop.exttab.ExternalTableException: Unsupported Hive table serialization library org.apache.hadoop.hive.contrib.serde2.JsonSerde

    Root Cause Analysis

    1. oracle.hadoop.exttab.ExternalTableException

      Unsupported Hive table serialization library org.apache.hadoop.hive.contrib.serde2.JsonSerde

      at oracle.hadoop.exttab.hive.HiveSource.initialize()
    2. oracle.hadoop.exttab
      ExternalTable.run
      1. oracle.hadoop.exttab.hive.HiveSource.initialize(HiveSource.java:262)
      2. oracle.hadoop.exttab.hive.HiveSource.getDataSet(HiveSource.java:444)
      3. oracle.hadoop.exttab.ExternalTable.doCreateTable(ExternalTable.java:1367)
      4. oracle.hadoop.exttab.ExternalTable.run(ExternalTable.java:1673)
      5. oracle.hadoop.exttab.ExternalTable.run(ExternalTable.java:1745)
      5 frames
    3. Hadoop
      ToolRunner.run
      1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
      1 frame
    4. oracle.hadoop.exttab
      ExternalTable.main
      1. oracle.hadoop.exttab.ExternalTable.main(ExternalTable.java:1851)
      1 frame
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    6. Hadoop
      RunJar.main
      1. org.apache.hadoop.util.RunJar.main(RunJar.java:208)
      1 frame