[IMPALA-1105] Usage of TRUNC with string timestamp reliably crashes node

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 1.4
• Fix Version/s: Impala 2.0
• Environment: cdh5.1.0 on ubuntu, from packages
• Assignee: Victor Bittorf
• Reporter: Colin Marc
• Created: 22/Jul/14 11:21
• Updated: 20/Jan/16 01:29
• Resolved: 18/Sep/14 17:59

Description

Running the following query reliably crashes the node it is run on:

[impala1:21000] > select trunc('2014-07-22 01:34:55 +0100', 'year');
Query: select trunc('2014-07-22 01:34:55 +0100', 'year')
Error communicating with impalad: TSocket read 0 bytes
Not connected (use CONNECT to establish a connection)

This error is in the impalad log:

terminate called after throwing an instance of 'boost::exception_detail::clone_impl<boost::exception_detail::error_info_injector<boost::gregorian::bad_year> >'
  what():  Year is out of valid range: 1400..10000

Issue Links

• relates to: IMPALA-2868 Distant timestamp in GROUP BY reliably crashes node