Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1277

CSVCommonsLoader not allowing null CHAR values (non PK)

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.5.0, 4.4.1
    • Component/s: None
    • Labels:
      None

      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.

        Attachments

        1. PHOENIX-1277.patch
          6 kB
          Gabriel Reid

          Activity

            People

            • Assignee:
              gabriel.reid Gabriel Reid
              Reporter:
              cartershanklin Carter Shanklin
            • Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: