[
https://issues.apache.org/jira/browse/PHOENIX-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-1277.
-----------------------------------
Resolution: Fixed
Fix Version/s: 4.4.1
4.5.0
5.0.0
Pushed to 4.4.x, 4.x, and master branches.
> CSVCommonsLoader not allowing null CHAR values (non PK)
> -------------------------------------------------------
>
> Key: PHOENIX-1277
> URL: https://issues.apache.org/jira/browse/PHOENIX-1277
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.0.0
> Reporter: Carter Shanklin
> Assignee: Gabriel Reid
> Priority: Minor
> Fix For: 5.0.0, 4.5.0, 4.4.1
>
> Attachments: PHOENIX-1277.patch
>
>
> With this simple table:
> {code}
> create table dummy ( x integer primary key, y char(10) );
> {code}
> And dataset
> {code}
> $ cat DummyValues.csv
> 1,x
> 2,
> 3,z
> {code}
> And running psql.py I get this:
> {code}
> psql.py -t DUMMY localhost:2181:/hbase-unsecure DummyValues.csv
> 14/09/22 16:31:02 ERROR util.CSVCommonsLoader: Error upserting record [2, ]:
> CHAR may not be null
> CSV Upsert complete. 2 rows upserted
> Time: 0.052 sec(s)
> {code}
> In sqlline I can insert nulls just fine into column y.
> Didn't check to see if this affects other types, e.g. varchar.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
