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 [email protected]. Cheers. On Fri, 24 Jul 2020, 16:42 Goulven Rozec, <[email protected]> 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 >
