IBM Support

PI78044: EXPORT OF HIVE TABLES FAILS WITH DATA GREATER THAN 32 MB FAILS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • While attempting to export a Hive table which has more than 32
    MB of Data in Hive 1.2.1, the following two JIRAs may be
    encountered:
    https://issues.apache.org/jira/browse/HIVE-11607
    https://issues.apache.org/jira/browse/HIVE-11820
    
    Symptoms include:
    java.io.IOException: Cannot get DistCp constructor:
    org.apache.hadoop.tools.DistCp.<init>()
     at
    org.apache.hadoop.hive.shims.Hadoop23Shims.runDistCp(Hadoop23Shi
    ms.java:1160)
     at
    org.apache.hadoop.hive.common.FileUtils.copy(FileUtils.java:553)
     at
    org.apache.hadoop.hive.ql.exec.CopyTask.execute(CopyTask.java:82
    )
    
    and
    
    2015-09-14 21:44:16,817 ERROR [main]: exec.Task
    (SessionState.java:printError(960)) - Failed with exception
    Skip CRC is valid only with update options
    java.lang.IllegalArgumentException: Skip CRC is valid only with
    update options
    
    being reported
    

Local fix

  • Request Special Build for BigInsights 4.1 from IBM detailing
    this APAR.
    Fixed in BI 4.2 (Hive 1.2.1-IBM-19)
    

Problem summary

  • Fixed in IBM IOP 4.2 (hive.1.2.1-IBM-19)
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI78044

  • Reported component name

    INFO BIGINSIGHT

  • Reported component ID

    5725C0900

  • Reported release

    410

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-13

  • Closed date

    2017-03-13

  • Last modified date

    2017-03-13

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • Hive
    

Fix information

Applicable component levels

  • R420 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 August 2020