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
