Hive
  1. Hive
  2. HIVE-4122

Queries fail if timestamp data not in expected format

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.10.0
    • Fix Version/s: 0.11.0
    • Component/s: SQL
    • Labels:
      None

      Description

      Queries will fail if timestamp data not in expected format. The expected behavior is to return NULL for these invalid values.

      # Not all timestamps in correct format:
      echo "1999-10-10
      1999-10-10 90:10:10
      0000-01-01 00:00:00" > table.data
      hive -e "create table timestamp_tbl (t timestamp)"
      hadoop fs -put ./table.data HIVE_WAREHOUSE_DIR/timestamp_tbl/
      hive -e "select t from timestamp_tbl"
      
      Execution failed with exit status: 2
      13/03/05 09:47:05 ERROR exec.Task: Execution failed with exit status: 2
      Obtaining error information
      13/03/05 09:47:05 ERROR exec.Task: Obtaining error information
      
      Task failed!
      Task ID:
        Stage-1
      
      Logs:
      
      13/03/05 09:47:05 ERROR exec.Task: 
      Task failed!
      Task ID:
        Stage-1
      
      Logs:
      
      1. HIVE-4188-2.patch
        4 kB
        Prasad Mujumdar
      2. HIVE-4122-1.patch
        3 kB
        Prasad Mujumdar

        Activity

        Lenni Kuff created issue -
        Prasad Mujumdar made changes -
        Field Original Value New Value
        Assignee Prasad Mujumdar [ prasadm ]
        Prasad Mujumdar made changes -
        Attachment HIVE-4122-1.patch [ 12572190 ]
        Prasad Mujumdar made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Prasad Mujumdar made changes -
        Attachment HIVE-4188-2.patch [ 12576245 ]
        Ashutosh Chauhan made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Fix Version/s 0.11.0 [ 12323587 ]
        Resolution Fixed [ 1 ]
        Owen O'Malley made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Prasad Mujumdar
            Reporter:
            Lenni Kuff
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development