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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Trivial
    • Resolution: Duplicate
    • 0.12.0
    • None
    • Types
    • None

    Description

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

      This prints out 1970-01-01.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              vikram.dixit Vikram Dixit K
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: