Rushabh Shah created PHOENIX-7309:
-------------------------------------
Summary: Support specifying splits.txt file while creating a table.
Key: PHOENIX-7309
URL: https://issues.apache.org/jira/browse/PHOENIX-7309
Project: Phoenix
Issue Type: Improvement
Reporter: Rushabh Shah
Currently phoenix grammar support specifying splits points while creating a
table.
See grammar [here|https://phoenix.apache.org/language/index.html#create_table]
{noformat}
CREATE TABLE IF NOT EXISTS "my_case_sensitive_table"
( "id" char(10) not null primary key, "value" integer)
DATA_BLOCK_ENCODING='NONE',VERSIONS=5,MAX_FILESIZE=2000000 split on (?, ?,
?)
{noformat}
This works fine if you have few split points (less than 10-20).
But if you want to specify 1000 (or in 10,000s) split points then this API
becomes very cumbersome to use.
HBase provides API to create a table with split points text file.
{noformat}
hbase> create 't1', 'f1', SPLITS_FILE => 'splits.txt', OWNER => 'johndoe'
{noformat}
We should also have support in Phoenix to provide split points in a text file.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
