The record in question 45056, 82851, Both, Deal.com, 23, MODERNFHICKORY, '', '', Internal API, 2017-03-19 21:56:39.0, Tim , 2016-02-25 07:53:05.0
doesn’t appear to have a blank or null value. There are either two columns containing a single quote character, or more likely a column containinig a quoted comma which the parser treats a two fields. > On Mar 30, 2017, at 3:09 AM, anil gupta <anilgupt...@gmail.com> wrote: > > Hi, > > We are trying load a simple CSV file to a table via CsvBulkLoadTool and some > of the columns have blank/null value. We are using HDP 2.3 and Phoenix 4.4. > We are getting following error: > 2017-03-29 21:53:34,106 ERROR [main] > org.apache.phoenix.mapreduce.CsvToKeyValueMapper: Error on record [45056, > 82851, Both, Deal.com, 23, MODERNFHICKORY, '', '', Internal API, 2017-03-19 > 21:56:39.0, Tim , 2016-02-25 07:53:05.0]: java.sql.SQLException: ERROR 201 > (22000): Illegal data. > > Isn't there a way to handle blank or null value in input dataset while using > CsvBulkLoadTool? I have looked at documentation but i am unable to find a > solution for this. > > -- > Thanks & Regards, > Anil Gupta
