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

Date and timestamp type converts invalid strings to '1970-01-01'

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 0.12.0
    • 0.12.0
    • Types
    • None

    Description

      select
        cast('abcd' as date),
        cast('abcd' as timestamp)
      from src limit 1;
      
      

      returns '1970-01-01'

      Attachments

        1. HIVE-5329.3.patch
          13 kB
          Jason Dere
        2. HIVE-5329.2.patch
          12 kB
          Jason Dere
        3. HIVE-5329.1.patch
          8 kB
          Jason Dere

        Issue Links

          Activity

            People

              jdere Jason Dere
              vikram.dixit Vikram Dixit K
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: