Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-9917

After HIVE-3454 is done, make int to timestamp conversion configurable

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.2.0
    • None
    • Hide

      With the change of HIVE-9917, we support an additional configuration "hive.int.timestamp.conversion.in.seconds" to enable the interpretation the BOOLEAN/BYTE/TINYINT/SMALLINT/INT/BIGINT value in seconds during the timestamp conversion without breaking the existing customers. By default, the existing functionality is kept.
      Show
      With the change of HIVE-9917 , we support an additional configuration "hive.int.timestamp.conversion.in.seconds" to enable the interpretation the BOOLEAN/BYTE/TINYINT/SMALLINT/INT/BIGINT value in seconds during the timestamp conversion without breaking the existing customers. By default, the existing functionality is kept.

    Description

      After HIVE-3454 is fixed, we will have correct behavior of converting int to timestamp. While the customers are using such incorrect behavior for so long, better to make it configurable so that in one release, it will default to old/inconsistent way and the next release will default to new/consistent way. And then we will deprecate it.

      Attachments

        1. HIVE-9917.patch
          353 kB
          Aihua Xu

        Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. HIVE-3454 Problem with CAST(BIGINT as TIMESTAMP)

          • Major - Major loss of function.
          • Closed
          is depended upon by

          Bug - A problem which impairs or prevents the functions of the product. HIVE-10212 When timestamp is converted to bigint, it's always interpreted as seconds while bigint to timestamp is in milliseconds.

          • Major - Major loss of function.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-11168 Followup on HIVE-9917, set the default value of hive.int.timestamp.conversion.in.seconds to true

          • Major - Major loss of function.
          • Open

          Activity

            People

              aihuaxu Aihua Xu
              aihuaxu Aihua Xu
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: