phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Reid <gabriel.r...@gmail.com>
Subject Re: UPSERT SELECT works partially
Date Mon, 30 Mar 2015 12:00:14 GMT
Hi,

I believe Squirrel does some kind of implicit "LIMIT 100" on statements, so
my guess would be that it's adding a "LIMIT 100" to your UPSERT SELECT
statement.

Could you try the same thing using sqlline to verify if it's a problem
there as well?

- Gabriel


On Mon, Mar 30, 2015 at 12:28 PM Dark Hawk <d4rxh4wx@gmail.com> wrote:

> Hello,
>
> I'm using Phoenix 4.3.0 on Cloudera CDH 5.3.
>
> I'm trying to use the "UPSERT SELECT" statement.
> It seems to work partially. Only a fews rows are updated in HBase.
>
> From Squirrel, I have created 2 tables:
>
> CREATE TABLE "PHOENIX_FROM" (id VARCHAR PRIMARY KEY, "CF1"."date" VARCHAR)
> CREATE TABLE "PHOENIX_TO" (id VARCHAR PRIMARY KEY, "CF1"."date" VARCHAR)
>
> Then I have inserted about 1000 rows in the PHOENIX_FROM table with Java
> HBase API.
> (verified with a "count" from hbase shell)
>
> Then from squirrel, when I launch the following command, only 100 rows are
> inserted in the destination table:
>
> UPSERT INTO "PHOENIX_TO" SELECT * FROM "PHOENIX_FROM"
>
> Do you know what's happening?
>
> Thanks
>

Mime
View raw message