[
https://issues.apache.org/jira/browse/KUDU-2168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roger Marin updated KUDU-2168:
------------------------------
Description:
Kudu currently supports unique constraints via primary keys but some times a
unique value constraint on (nullable) arbitrary column(s) independent of the
primary key column(s) may also be required.
Example impala syntax:
{code:sql}
CREATE TABLE my_first_table
(
id BIGINT,
name STRING,
unique_val_1 BIGINT,
unique_val_2 BIGINT,
PRIMARY KEY(id)
UNIQUE CONSTRAINT(unique_val_1,unique_val_2)
)
PARTITION BY HASH PARTITIONS 16
STORED AS KUDU;
{code}
Example api syntax:
{code:java}
val kuduTableSchema = StructType(
StructField("id", IntegerType , false) ::
StructField("name" , IntegerType, true ) ::
StructField("unique_val_1", IntegerType , true ) ::
StructField("unique_val_2", IntegerType , true ) :: Nil)
val kuduPrimaryKey = Seq("id")
val kuduTableOptions = new CreateTableOptions()
kuduTableOptions.
setUniqueConstraintColumns(List("unique_val_1", "unique_val_2").asJava).
setRangePartitionColumns(List("name").asJava).
setNumReplicas(3)
kuduContext.createTable(kuduTableName, kuduTableSchema, kuduPrimaryKey,
kuduTableOptions)
{code}
was:
Kudu currently supports unique constraints via primary keys but some times a
unique value constraint on (nullable) arbitrary column(s) independent of the
primary key column(s) may also be required.
Example impala syntax:
{code:sql}
CREATE TABLE my_first_table
(
id BIGINT,
name STRING,
unique_val_1 BIGINT,
unique_val_2 BIGINT,
PRIMARY KEY(id)
UNIQUE CONSTRAINT(unique_val_1,unique_val_2)
)
PARTITION BY HASH PARTITIONS 16
STORED AS KUDU;
{code}
Example api syntax:
{code:scala}
val kuduTableSchema = StructType(
StructField("id", IntegerType , false) ::
StructField("name" , IntegerType, true ) ::
StructField("unique_val_1", IntegerType , true ) ::
StructField("unique_val_2", IntegerType , true ) :: Nil)
val kuduPrimaryKey = Seq("id")
val kuduTableOptions = new CreateTableOptions()
kuduTableOptions.
setUniqueConstraintColumns(List("unique_val_1", "unique_val_2").asJava).
setRangePartitionColumns(List("name").asJava).
setNumReplicas(3)
kuduContext.createTable(kuduTableName, kuduTableSchema, kuduPrimaryKey,
kuduTableOptions)
{code}
> Add support for unique constraints
> ----------------------------------
>
> Key: KUDU-2168
> URL: https://issues.apache.org/jira/browse/KUDU-2168
> Project: Kudu
> Issue Type: New Feature
> Components: client, master, tablet
> Reporter: Roger Marin
>
> Kudu currently supports unique constraints via primary keys but some times a
> unique value constraint on (nullable) arbitrary column(s) independent of the
> primary key column(s) may also be required.
> Example impala syntax:
> {code:sql}
> CREATE TABLE my_first_table
> (
> id BIGINT,
> name STRING,
> unique_val_1 BIGINT,
> unique_val_2 BIGINT,
> PRIMARY KEY(id)
> UNIQUE CONSTRAINT(unique_val_1,unique_val_2)
> )
> PARTITION BY HASH PARTITIONS 16
> STORED AS KUDU;
> {code}
> Example api syntax:
> {code:java}
> val kuduTableSchema = StructType(
> StructField("id", IntegerType , false) ::
> StructField("name" , IntegerType, true ) ::
> StructField("unique_val_1", IntegerType , true ) ::
> StructField("unique_val_2", IntegerType , true ) :: Nil)
> val kuduPrimaryKey = Seq("id")
>
> val kuduTableOptions = new CreateTableOptions()
> kuduTableOptions.
> setUniqueConstraintColumns(List("unique_val_1", "unique_val_2").asJava).
> setRangePartitionColumns(List("name").asJava).
> setNumReplicas(3)
>
> kuduContext.createTable(kuduTableName, kuduTableSchema, kuduPrimaryKey,
> kuduTableOptions)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
