phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siva <sbhavan...@gmail.com>
Subject Fwd: Bulk loading error
Date Wed, 04 Feb 2015 23:49:38 GMT
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