Hi Brian, It seems like Phoenix is not liking ''(single quotes) in an integer column. IMO, it will be better if phoenix can handle that by providing an option in csvbulkloadtool to specify '' to be treated as null. Single quotes works fine for varchar columns.
Thanks, Anil Gupta On Thu, Mar 30, 2017 at 4:15 AM, Brian Jeltema <bdjelt...@gmail.com> wrote: > 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 > > -- Thanks & Regards, Anil Gupta
