[PHOENIX-1277] CSVCommonsLoader not allowing null CHAR values (non PK)

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.5.0, 4.4.1
• Assignee: Gabriel Reid
• Reporter: Carter Shanklin
• Created: 23/Sep/14 00:28
• Updated: 21/Nov/15 02:16
• Resolved: 29/Jun/15 06:53

Description

With this simple table:

create table dummy ( x integer primary key, y char(10) );

And dataset

$ cat DummyValues.csv
1,x
2,
3,z

And running psql.py I get this:

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)

In sqlline I can insert nulls just fine into column y.

Didn't check to see if this affects other types, e.g. varchar.