IBM Support

PH15845: AFTER UPGRADE TO BIG SQL VERSION 6.0.0.0, PARQUET FILES MAY SHOW INCORRECT TIMESTAMP VALUES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • After upgrading to Big SQL version 6.0.0.0, tables that have
timestamp columns and are stored as parquet format may display
incorrect values for those columns.  These columns will display
correctly after this fix is applied.
.
If any data was ingested with Load or Insert on a 6.0 level
without this fix, those parquet data must be removed and
ingested again on a build level with the APAR fix.  Any data
ingested with Hive 3.1 without HIVE-21290 must be re-ingested
with HIVE-21290.

Local fix

  • 



Problem summary


    

  • Please see problem discription.

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH15845
    • 

  • Reported component name
    IBM BIG SQL
    • 

  • Reported component ID
    5737E7400
    • 

  • Reported release
    600
    • 

  • Status
    CLOSED  FIN
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2019-08-19
    • 

  • Closed date
    2020-09-09
    • 

  • Last modified date
    2020-09-09
    • 





    

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

    • 

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

    • 



Fix information


    



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"600"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            10 September 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback