[
https://issues.apache.org/jira/browse/PHOENIX-7309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17851827#comment-17851827
]
Viraj Jasani edited comment on PHOENIX-7309 at 6/3/24 9:49 PM:
---------------------------------------------------------------
{quote}{quote}While Phoenix can do something similar to what HBase shell does
{quote}
Yes, you see what is implemented in jruby for the shell. Simply reimplement
this in Java for your purposes, and modify for requirements.
{quote}
For the purpose of creating the table, I was mainly looking for improvement
that does not have to involve large array of split points (hundreds of
thousands of split points) to be sent over the wire and rather let server
perform the task of reading the file and creating split points.
was (Author: vjasani):
{quote}{quote}While Phoenix can do something similar to what HBase shell does
{quote}
Yes, you see what is implemented in jruby for the shell. Simply reimplement
this in Java for your purposes, and modify for requirements.
{quote}
For the purpose of creating the table, I was mainly looking for improvement
that does not have to involve large array of split points (hundreds of
thousands of split points) to be sent over the wire and rather let server
perform the task of reading the file and creating split points.
> 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
> Priority: Major
>
> 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)
