Hi,
Referencing this link for Date type :
http://phoenix.apache.org/language/datatypes.html#date_type
Thanks,
Sun.
CertusNet
From: Siva
Date: 2015-02-05 07:49
To: user
Subject: Fwd: Bulk loading error
Hi Everyone,
Encountered below error while bulk loading the data. Can you let me know What
is the format for date type?
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
Caused by: java.lang.RuntimeException: Error on record,
java.text.ParseException: Unparseable date: "2014-2-4", record =[3, asdf,
2014-2-4]
at
org.apache.phoenix.mapreduce.CsvToKeyValueMapper$MapperUpsertListener.errorOnRecord(CsvToKeyValueMapper.java:290)
at
org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:155)
at
org.apache.phoenix.util.csv.CsvUpsertExecutor.execute(CsvUpsertExecutor.java:128)
at
org.apache.phoenix.mapreduce.CsvToKeyValueMapper.map(CsvToKeyValueMapper.java:156)
... 9 more
Data in my csv file:
Table: TEST
| TABLE_NAME | COLUMN_NAME | DATA_TYPE | TYPE_NAME
+------------+-------------+------------+------------
| TEST | MYKEY | 4 | INTEGER
| TEST | MYCOLUMN | 12 | VARCHAR
| TEST | CHG_DT | 91 | DATE
Thanks
