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
