Thanks. It solved my issue.
On Mon, Mar 30, 2015 at 3:13 PM, Sergey Belousov <[email protected]> wrote: > make sure that in upper right conner check mark next to Limit Rows ____ is > unchecked > > On Mon, Mar 30, 2015 at 6:28 AM, Dark Hawk <[email protected]> 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 >> > >
