Fwd: How to check "split on" option on table

[Goulven Rozec <go...@gmail.com>]

Hi folks,



I would like to create a table with the « split on » option on one part of
the primary key as follow  :



CREATE TABLE IF NOT EXISTS MYTABLE ("col1 " VARCHAR NOT NULL , "col2"
VARCHAR, "col3" VARCHAR NOT NULL, "col4" VARCHAR, "col5" VARCHAR, ……
CONSTRAINT ROWKEY PRIMARY KEY ("col1", "col2")) SPLIT ON ('col1
value1','col2 value2', …… );



How can I check if my « split on » is correctly setup on my table ?



Thanks in advance for your time

Re: How to check "split on" option on table

[Pedro Boado <pb...@apache.org>]

I would list table regions by either checking Hbase admin web UI or from
the Hbase shell with list_regions 'table_name' and check that each region
startKey matches your split points.

Afaik there is no way for checking this from phoenix console.

Also, these type of questions are a better fit for user@phoenix.apache.org.

Cheers.

On Fri, 24 Jul 2020, 16:42 Goulven Rozec, <go...@gmail.com> wrote:

> Hi folks,
>
>
>
> I would like to create a table with the « split on » option on one part of
> the primary key as follow  :
>
>
>
> CREATE TABLE IF NOT EXISTS MYTABLE ("col1 " VARCHAR NOT NULL , "col2"
> VARCHAR, "col3" VARCHAR NOT NULL, "col4" VARCHAR, "col5" VARCHAR, ……
> CONSTRAINT ROWKEY PRIMARY KEY ("col1", "col2")) SPLIT ON ('col1
> value1','col2 value2', …… );
>
>
>
> How can I check if my « split on » is correctly setup on my table ?
>
>
>
> Thanks in advance for your time
>