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