Re: ERROR 201 (22000): Unable to load CSV files using CsvBulkLoadTool due to blank columns

I agree, It doesn't. Unfortunately, we have it for historical reasons. And pig-phoenix integration treats '' as null for an Integer column so the behavior of ingestion is varying. On Thu, Mar 30, 2017 at 11:07 AM, Pedro Boado wrote: > It doesn't make a lot of sense

Re: ERROR 201 (22000): Unable to load CSV files using CsvBulkLoadTool due to blank columns

It doesn't make a lot of sense having quotes in an integer column, does it? Maybe removing this quotes from the source would solve the problem. On 30 Mar 2017 18:43, "anil gupta" wrote: > Hi Brian, > > It seems like Phoenix is not liking ''(single quotes) in an integer >

Re: ERROR 201 (22000): Unable to load CSV files using CsvBulkLoadTool due to blank columns

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,

Re: ERROR 201 (22000): Unable to load CSV files using CsvBulkLoadTool due to blank columns

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

ERROR 201 (22000): Unable to load CSV files using CsvBulkLoadTool due to blank columns

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