hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lenni Kuff (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-4122) Queries fail if timestamp data not in expected format
Date Tue, 05 Mar 2013 17:50:13 GMT
Lenni Kuff created HIVE-4122:
--------------------------------

             Summary: Queries fail if timestamp data not in expected format
                 Key: HIVE-4122
                 URL: https://issues.apache.org/jira/browse/HIVE-4122
             Project: Hive
          Issue Type: Bug
          Components: SQL
    Affects Versions: 0.10.0
            Reporter: Lenni Kuff


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

{code}
# 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:
{code}


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message