phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <els...@apache.org>
Subject Re: Phoenix CSV Bulk Load Tool Date format for TIMESTAMP
Date Tue, 05 Sep 2017 18:50:30 GMT
Sriram,

Did you set the timezone and date-format configuration properties 
correctly for your environment?

See `phoenix.query.dateFormatTimeZone` and `phoenix.query.dateFormat` as 
described http://phoenix.apache.org/tuning.html

On 9/5/17 2:05 PM, Sriram Nookala wrote:
> I'm trying to bulkload data using the CsvBulkLoadTool, one of the 
> columns is a data in the format MMMMYYDD for example 20160912. I don't 
> get an error, but the parsing is wrong and when I use sqlline I see the 
> date show up asĀ 20160912-01-01 00:00:00.000. I had assumed as per the 
> fix for https://issues.apache.org/jira/browse/PHOENIX-1127 all data 
> values would be parsed correctly.

Mime
View raw message