[CALCITE-1072] CSV adapter incorrectly parses TIMESTAMP values after noon

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Assignee: Julian Hyde
• Reporter: Chris Albright
• Created: 01/Feb/16 07:43
• Updated: 22/Mar/16 01:18
• Resolved: 02/Feb/16 18:21

Description

When querying timestamp data using the CSV adapter, the time is always in A.M.

for example this input file: EXAMPLE_DATA.csv
ID:long,START:timestamp,END:timestamp
1,"2015-12-31 07:15:56","2015-12-31 13:31:21"

yields this output in sqlline:
select * from example_data;

ID	START	END
1	2015-12-31 07:15:56	2015-12-31 01:31:21

The bug appears to be in org.apache.calcite.adapter.csv.CsvEnumerator on lines 59 and 60. The parse formats use 'hh' instead of 'HH' for the hour part.