[
https://issues.apache.org/jira/browse/PHOENIX-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17749550#comment-17749550
]
ASF GitHub Bot commented on PHOENIX-1755:
-----------------------------------------
stoty closed pull request #51: PHOENIX-1755 Improve error logging if csv line
has insufficient fields
URL: https://github.com/apache/phoenix/pull/51
> CSV loader needs a clearer error message for lines with insufficient fields
> ---------------------------------------------------------------------------
>
> Key: PHOENIX-1755
> URL: https://issues.apache.org/jira/browse/PHOENIX-1755
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.1.0
> Reporter: Karel Vervaeke
> Assignee: Gabriel Reid
> Priority: Major
> Fix For: 4.4.0
>
>
> Steps to reproduce
> Create a table
> {code}
> create table mytable(id bigint not null primary key, a_string varchar, a_long
> bigint);
> {code}
> Create some data (note line 2 has only 2 fields)
> {code}
> cat <<EOF
> 1,foo,4
> 2,bar
> EOF > mytable.csv
> {code}
> Import the data
> {code}
> karel@chicken:~/work/apache/phoenix$ bin/psql.py -h ID,A_STRING,A_LONG
> localhost mytable.csv
> csv columns from user. length=3, ID, A_STRING, A_LONG
> 15/03/19 16:03:24 ERROR util.CSVCommonsLoader: Error upserting record [2,
> bar]: 2
> {code}
> The error message doesn't say much, could be better.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
