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