[TRAFODION-2638] Make "hbase_options" as default setting and use cqd to change the default setting

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: any
• Fix Version/s: any
• Component/s: sql-general
• Assignee: Unassigned
• Reporter: Yuan Liu
• Created: 08/Jun/17 01:38
• Updated: 08/Jun/17 01:38

Description

As we know, for performance thinking, we always need to add below syntax in “create table” syntax. And I know in latest version, we have made “ATTRIBUTES ALIGNED FORMAT” as default, do we have a plan that make HBASE_OPTIONS(including ENCODING、COMPRESSION、MEMESTORE) as the default setting when creating table? I think this will be easier for end users?

ATTRIBUTES ALIGNED FORMAT
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'SNAPPY',
MEMSTORE_FLUSH_SIZE = '1073741824'
)
;