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-4122-1.patch
        3 kB
        Prasad Mujumdar
      2. HIVE-4188-2.patch
        4 kB
        Prasad Mujumdar

        Activity

        Hide
        Prasad Mujumdar added a comment -

        Patch attached

        Show
        Prasad Mujumdar added a comment - Patch attached
        Hide
        Prasad Mujumdar added a comment -
        Show
        Prasad Mujumdar added a comment - Review request on https://reviews.facebook.net/D9117
        Hide
        Prasad Mujumdar added a comment -

        Updated test per review feedback

        Show
        Prasad Mujumdar added a comment - Updated test per review feedback
        Hide
        Ashutosh Chauhan added a comment -

        Committed to trunk. Thanks, Prasad!

        Show
        Ashutosh Chauhan added a comment - Committed to trunk. Thanks, Prasad!
        Hide
        Hudson added a comment -

        Integrated in Hive-trunk-h0.21 #2038 (See https://builds.apache.org/job/Hive-trunk-h0.21/2038/)
        HIVE-4122 : Queries fail if timestamp data not in expected format (Prasad Mujumdar via Ashutosh Chauhan) (Revision 1462874)

        Result = FAILURE
        hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1462874
        Files :

        • /hive/trunk/ql/src/test/queries/clientpositive/timestamp_null.q
        • /hive/trunk/ql/src/test/results/clientpositive/timestamp_null.q.out
        • /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyTimestamp.java
        Show
        Hudson added a comment - Integrated in Hive-trunk-h0.21 #2038 (See https://builds.apache.org/job/Hive-trunk-h0.21/2038/ ) HIVE-4122 : Queries fail if timestamp data not in expected format (Prasad Mujumdar via Ashutosh Chauhan) (Revision 1462874) Result = FAILURE hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1462874 Files : /hive/trunk/ql/src/test/queries/clientpositive/timestamp_null.q /hive/trunk/ql/src/test/results/clientpositive/timestamp_null.q.out /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyTimestamp.java
        Hide
        Hudson added a comment -

        Integrated in Hive-trunk-hadoop2 #138 (See https://builds.apache.org/job/Hive-trunk-hadoop2/138/)
        HIVE-4122 : Queries fail if timestamp data not in expected format (Prasad Mujumdar via Ashutosh Chauhan) (Revision 1462874)

        Result = FAILURE
        hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1462874
        Files :

        • /hive/trunk/ql/src/test/queries/clientpositive/timestamp_null.q
        • /hive/trunk/ql/src/test/results/clientpositive/timestamp_null.q.out
        • /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyTimestamp.java
        Show
        Hudson added a comment - Integrated in Hive-trunk-hadoop2 #138 (See https://builds.apache.org/job/Hive-trunk-hadoop2/138/ ) HIVE-4122 : Queries fail if timestamp data not in expected format (Prasad Mujumdar via Ashutosh Chauhan) (Revision 1462874) Result = FAILURE hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1462874 Files : /hive/trunk/ql/src/test/queries/clientpositive/timestamp_null.q /hive/trunk/ql/src/test/results/clientpositive/timestamp_null.q.out /hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyTimestamp.java

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development