phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pedro Boado <pedro.bo...@gmail.com>
Subject Re: ERROR 201 (22000): Unable to load CSV files using CsvBulkLoadTool due to blank columns
Date Thu, 30 Mar 2017 18:07:00 GMT
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" <anilgupta84@gmail.com> wrote:

> 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 <bdjeltema@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 <anilgupta84@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
>

Mime
View raw message