phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carter Shanklin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-1277) CSVCommonsLoader not allowing null CHAR values (non PK)
Date Tue, 23 Sep 2014 00:28:34 GMT
Carter Shanklin created PHOENIX-1277:
----------------------------------------

             Summary: 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
            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)

Mime
View raw message