It works in the integration test because the date format is specifically set (as an extra bit of testing)
https://github.com/apache/phoenix/blob/master/phoenix-core/src/it/java/org/apache/phoenix/mapreduce/CsvBulkLoadToolIT.java#L105 On Tue, May 26, 2015 at 9:33 PM Nick Dimiduk <[email protected]> wrote: > This is working for me as expected, thanks Gabriel. I find it odd that we > don't have an issue in our IT test though > > printWriter.println("1,Name 1,1970/01/01"); > printWriter.println("2,Name 2,1970/01/02"); > > > https://github.com/apache/phoenix/blob/master/phoenix-core/src/it/java/org/apache/phoenix/mapreduce/CsvBulkLoadToolIT.java#L99-L100 > > On Sat, May 16, 2015 at 9:14 AM, Gabriel Reid <[email protected]> > wrote: > >> Hi Nick, >> >> The date format is (if I'm not mistaken) ISO-8601, so I think you'll have >> to format your date values as 1970-01-01. >> >> - Gabriel >> >> >> On Fri, May 15, 2015 at 02:02 Nick Dimiduk <[email protected]> wrote: >> >>> Heya, >>> >>> Giving the RC a spin, and also investigating the impact of HBASE-13604, >>> I'm >>> having a spot of trouble with bulk load. I'm executing CsvBulkLoadToolIT >>> manually. Seems like date string parsing is not working, but I may well >>> be >>> doing something wrong. >>> >>> Thanks. >>> >>> $ cat /tmp/input1.csv >>> 1,Name 1,1970/01/01 >>> 2,Name 2,1970/01/02 >>> >>> 0: jdbc:phoenix:localhost> select COLUMN_NAME,DATA_TYPE from >>> SYSTEM.CATALOG >>> where TABLE_NAME='TABLE1'; >>> >>> +------------------------------------------+-----------------------------------+ >>> | COLUMN_NAME | DATA_TYPE >>> | >>> >>> +------------------------------------------+-----------------------------------+ >>> | | null >>> | >>> | ID | 4 >>> | >>> | NAME | 12 >>> | >>> | T | 91 >>> | >>> >>> +------------------------------------------+-----------------------------------+ >>> 4 rows selected (0.027 seconds) >>> >>> $ HADOOP_CLASSPATH=/tmp/hbase-1.0.1/lib/hbase-protocol-1.0.1.jar hadoop >>> jar >>> phoenix-4.4.0-HBase-1.0-client.jar >>> org.apache.phoenix.mapreduce.CsvBulkLoadTool --table TABLE1 --input >>> /tmp/input1.csv --zookeeper localhost:2181 >>> ... >>> Caused by: java.lang.RuntimeException: Error on record, >>> java.lang.IllegalArgumentException: Invalid format: "1970/01/01" is >>> malformed at "/01/01", record =[1, Name 1, 1970/01/01] >>> at >>> >>> org.apache.phoenix.mapreduce.CsvToKeyValueMapper$MapperUpsertListener.errorOnRecord(CsvToKeyValueMapper.java:277) >>> at >>> >>> org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:168) >>> at >>> >>> org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:136) >>> at >>> >>> org.apache.phoenix.mapreduce.CsvToKeyValueMapper.map(CsvToKeyValueMapper.java:160) >>> ... 10 more >>> >>> On Mon, May 11, 2015 at 5:41 PM, [email protected] < >>> [email protected]> wrote: >>> >>> > Hi Everyone, >>> > >>> > This is a call for a vote on Apache Phoenix 4.4.0-HBase-1.0 RC1. This >>> is >>> > the >>> > next minor release of Phoenix 4, compatible with the 1.0(branch of >>> > Apache HBase(1.0.1+) . The release includes both a source-only release >>> and >>> > a >>> > convenience binary release. >>> > >>> > The 4.4.0-HBase-1.0 release has feature parity with our pending >>> > 4.4.0-HBase-0.98 release. New features include: >>> > - Support HBase HA Query(timeline-consistent region replica read)[1] >>> > - Alter session query support(at present changing query consistency >>> level. >>> > Can be used for changing connection properties.) >>> > >>> > The source tarball, including signatures, digests, etc can be found at: >>> > >>> > >>> https://dist.apache.org/repos/dist/dev/phoenix/phoenix-4.4.0-HBase-1.0-rc1/src/ >>> > >>> > The binary artifacts can be found at: >>> > >>> > >>> https://dist.apache.org/repos/dist/dev/phoenix/phoenix-4.4.0-HBase-1.0-rc1/bin/ >>> > >>> > Release artifacts are signed with the following key: >>> > http://people.apache.org/~rajeshbabu/E3A65DBC.asc >>> > >>> > KEYS file available here: >>> > https://dist.apache.org/repos/dist/release/phoenix/KEYS >>> > >>> > The hash and tag to be voted upon: >>> > >>> > >>> https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=09d1840876d7b55e32d753b6666541eb7df22b85 >>> > >>> > >>> https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=tag;h=refs/tags/v4.4.0-HBase-1.0-rc1 >>> > >>> > Vote will be open for at least 72 hours. Please vote: >>> > >>> > [ ] +1 approve >>> > [ ] +0 no opinion >>> > [ ] -1 disapprove (and reason why) >>> > >>> > Thanks, >>> > The Apache Phoenix Team >>> > >>> > [1] https://issues.apache.org/jira/browse/PHOENIX-1683 >>> > >>> >> >
