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

["Gabriel Reid (JIRA)" <ji...@apache.org>]

     [ 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)