[
https://issues.apache.org/jira/browse/PHOENIX-53?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13920140#comment-13920140
]
James Violette commented on PHOENIX-53:
---------------------------------------
Output with ColumnInfo.toString()
$ ./bin/psql.py -t WEB_STAT blvdevhdp04 examples/web_stat.sql
examples/web_stat.csv
no rows upserted
Time: 0.216 sec(s)
csv columns from database.
phoenix columnInfo length=7, HOST CHAR, DOMAIN VARCHAR, FEATURE VARCHAR, DATE
DATE, CORE BIGINT, DB BIGINT, ACTIVE_VISITOR INTEGER
CSV Upsert complete. 39 rows upserted
Time: 0.086 sec(s)
> Replace CSV loader with Apache Commons CSV loader
> -------------------------------------------------
>
> Key: PHOENIX-53
> URL: https://issues.apache.org/jira/browse/PHOENIX-53
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 2.2.3, 3.0.0
> Reporter: James Violette
> Labels: patch
> Fix For: 3.0.0
>
> Attachments: colInfoToString.patch,
> commons-csv-1.0-SNAPSHOT-sources.jar, commons-csv-1.0-SNAPSHOT.jar,
> csvloaderoverrides.diff, csvloadersource.diff,
> incubator-phoenix-commons-csv-rev2-3.0.0.patch
>
>
> in org.apache.phoenix.util.CSVLoader, the upsert fails if it encounters an
> empty line. This occurs if all lines end with the new line character and the
> reader returns an empty line at the end. Other issues, such as encapsulated
> meta characters also occur.
> The fix is to replace the opencsv library with the current apache commons-csv
> library.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
