phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>
Subject Re: Fwd: Bulk loading error
Date Thu, 05 Feb 2015 01:17:40 GMT
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

Mime
View raw message