[
https://issues.apache.org/jira/browse/TRAFODION-1804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jian Jin updated TRAFODION-1804:
--------------------------------
Assignee: (was: Suresh Subbiah)
> Raise an error early during CREATE TABLE if requested compression type is not
> available
> ---------------------------------------------------------------------------------------
>
> Key: TRAFODION-1804
> URL: https://issues.apache.org/jira/browse/TRAFODION-1804
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-general
> Affects Versions: 1.2-incubating
> Reporter: Suresh Subbiah
> Priority: Minor
>
> If a table created with HBASE_OPTIONS (COMPRESSION = 'SNAPPY') but snappy
> compression is not available on the system, HBase will retry upto the
> configured number of retries (35 is default in some configurations) before
> raising an error.
> It will make the product more user friendly if Trafodion could detect this
> sooner and not send the DDL request to Hbase.
> Here is the DDL reported by Eric Owhadi
> create table Customer
> (
> c_customer_sk int not null,
> c_customer_id char(16) CHARACTER SET UTF8 not null,
> c_current_cdemo_sk int,
> c_current_hdemo_sk int,
> c_current_addr_sk int,
> c_first_shipto_date_sk int,
> c_first_sales_date_sk int,
> c_salutation char(10) CHARACTER SET UTF8,
> c_first_name char(20) CHARACTER SET UTF8,
> c_last_name char(30) CHARACTER SET UTF8,
> c_preferred_cust_flag char(1),
> c_birth_day integer,
> c_birth_month integer,
> c_birth_year integer,
> c_birth_country varchar(20) CHARACTER SET UTF8,
> c_login char(13) CHARACTER SET UTF8,
> c_email_address char(50) CHARACTER SET UTF8,
> c_last_review_date_sk int,
> primary key (c_customer_sk)
> )SALT USING 2 PARTITIONS
> HBASE_OPTIONS
> (
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
> COMPRESSION = 'SNAPPY'
> );
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
