Re: Phoenix CSV Bulk Load Tool Date format for TIMESTAMP

2017-09-05 Thread Josh Elser
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

Phoenix CSV Bulk Load Tool Date format for TIMESTAMP

2017-09-05 Thread Sriram Nookala
I'm trying to bulkload data using the CsvBulkLoadTool, one of the columns is a data in the format YYDD 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

How to speed up write performance

2017-09-05 Thread Hef
Hi guys, I'm evaluating using Phoenix to replace MySQL for better scalability. The version I'm evaluating is 4.11-HBase-1.2, with some dependencies modified to match CDH5.9 which we are using. The problem I'm having is the write performance to Phoenix from JDBC is too poor, only 500writes/second,