sercanCyberVision opened a new pull request, #5952:
URL: https://github.com/apache/hive/pull/5952

   **MOTIVATION:**
   Hive-3 reads RCFile timestamps written by Hive-2 incorrectly. Please see 
https://issues.apache.org/jira/browse/HIVE-22167 for more details.
    
   **SOLUTION:**
   A new property has been added to switch between current and legacy 
interpretation.
   ```
   <property>
     <name>hive.rcfile.timestamp.legacy.conversion</name>
     <value>true</value>
     <description>Whether to convert legacy RCFile timestamps (Hive 2.x 
format)</description>
   </property>
   ```
   
   **CHECKS:** 
   ```
   hive> set hive.rcfile.timestamp.legacy.conversion;
   hive.rcfile.timestamp.legacy.conversion=false --------->> DEFAULT
   hive> SELECT * FROM t;
   OK
   2025-07-01 12:48:15.01295 -------->> Incorrect value
   
   --SET TO TRUE:
   
   hive> set hive.rcfile.timestamp.legacy.conversion=true;
   hive> SELECT * FROM t;
   OK
   2025-07-01 14:48:15.01295 -------->> Correct value
   Time taken: 0.222 seconds, Fetched: 1 row(s)
   hive>
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org

Reply via email to