[ https://issues.apache.org/jira/browse/PHOENIX-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gabriel Reid reassigned PHOENIX-1277: ------------------------------------- Assignee: Gabriel Reid > 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 > > 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)