[HIVE-4122] Queries fail if timestamp data not in expected format

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.11.0
• Component/s: SQL
• Assignee: Prasad Suresh Mujumdar
• Reporter: Lenni Kuff
• Created: 05/Mar/13 17:48
• Updated: 16/May/13 21:10
• Resolved: 31/Mar/13 03:45

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: