Suresh Subbiah created TRAFODION-1804: -----------------------------------------
Summary: 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 Assignee: 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)