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

Queries fail if timestamp data not in expected format

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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:
      

        Attachments

        1. HIVE-4188-2.patch
          4 kB
          Prasad Mujumdar
        2. HIVE-4122-1.patch
          3 kB
          Prasad Mujumdar

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: