You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Vladimir Rodionov <vl...@gmail.com> on 2014/05/16 19:48:27 UTC
Can't load .csv file in 3.0 (At least one column must be provided for upserts)
This worked in 2.x. It seems not working in 3.0
./psql.py -t ods.events localhost ods_flow_events.csv
csv columns from database.
java.lang.IllegalArgumentException: At least one column must be provided
for upserts
at
org.apache.phoenix.util.QueryUtil.constructUpsertStatement(QueryUtil.java:67)
at
org.apache.phoenix.util.csv.CsvUpsertExecutor.create(CsvUpsertExecutor.java:91)
at
org.apache.phoenix.util.CSVCommonsLoader.upsert(CSVCommonsLoader.java:227)
at
org.apache.phoenix.util.CSVCommonsLoader.upsert(CSVCommonsLoader.java:196)
at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:208)
.csv file does not have any column info, of course.
-Vladimir
Re: Can't load .csv file in 3.0 (At least one column must be provided for upserts)
Posted by Gabriel Reid <ga...@gmail.com>.
Thanks for reporting back on that. I'll add a jira ticket to make the error message clear, as well as documenting that the table name is case-sensitive.
> On 16 May 2014, at 21:51, Vladimir Rodionov <vl...@gmail.com> wrote:
>
> yep, case sensitive. Thanks, Gabriel.
>
>
>> On Fri, May 16, 2014 at 11:20 AM, Gabriel Reid <ga...@gmail.com> wrote:
>> On Fri, May 16, 2014 at 7:48 PM, Vladimir Rodionov
>> <vl...@gmail.com> wrote:
>> > This worked in 2.x. It seems not working in 3.0
>> >
>> > ./psql.py -t ods.events localhost ods_flow_events.csv
>> > csv columns from database.
>> > java.lang.IllegalArgumentException: At least one column must be provided for
>> > upserts
>>
>>
>> I think that the -t option is case-senstive. I'm assuming that the
>> HBase table name is "ODS.EVENTS". Could you try running the same
>> command with -t ODS.EVENTS (or whatever the correct case is of the
>> table)?
>>
>> In any case, case-sensitive or not, there should be a clear error
>> message for that case.
>>
>> - Gabriel
>
Re: Can't load .csv file in 3.0 (At least one column must be provided
for upserts)
Posted by Vladimir Rodionov <vl...@gmail.com>.
yep, case sensitive. Thanks, Gabriel.
On Fri, May 16, 2014 at 11:20 AM, Gabriel Reid <ga...@gmail.com>wrote:
> On Fri, May 16, 2014 at 7:48 PM, Vladimir Rodionov
> <vl...@gmail.com> wrote:
> > This worked in 2.x. It seems not working in 3.0
> >
> > ./psql.py -t ods.events localhost ods_flow_events.csv
> > csv columns from database.
> > java.lang.IllegalArgumentException: At least one column must be provided
> for
> > upserts
>
>
> I think that the -t option is case-senstive. I'm assuming that the
> HBase table name is "ODS.EVENTS". Could you try running the same
> command with -t ODS.EVENTS (or whatever the correct case is of the
> table)?
>
> In any case, case-sensitive or not, there should be a clear error
> message for that case.
>
> - Gabriel
>
Re: Can't load .csv file in 3.0 (At least one column must be provided
for upserts)
Posted by Gabriel Reid <ga...@gmail.com>.
On Fri, May 16, 2014 at 7:48 PM, Vladimir Rodionov
<vl...@gmail.com> wrote:
> This worked in 2.x. It seems not working in 3.0
>
> ./psql.py -t ods.events localhost ods_flow_events.csv
> csv columns from database.
> java.lang.IllegalArgumentException: At least one column must be provided for
> upserts
I think that the -t option is case-senstive. I'm assuming that the
HBase table name is "ODS.EVENTS". Could you try running the same
command with -t ODS.EVENTS (or whatever the correct case is of the
table)?
In any case, case-sensitive or not, there should be a clear error
message for that case.
- Gabriel