[
https://issues.apache.org/jira/browse/TRAFODION-2195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16413052#comment-16413052
]
Pierre Smits commented on TRAFODION-2195:
-----------------------------------------
Hi,
Is this still a valid issue with our latest release (trafodion-2.2.0)?
> create Trafodion table with hbase options DATA_BLOCK_ENCODING and
> COMPRESSION together won't get all results when executing queries
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-2195
> URL: https://issues.apache.org/jira/browse/TRAFODION-2195
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: QiaoYanke
> Priority: Major
>
> I create a table using the follow ddl, and I insert into the table 1
> million lines, and the 'select count(*) from event' will get the right
> result. But when I execute 'select * from event', I only get several hundred
> lines.
> After I create the table just using 'HBASE_OPTIONS(
> COMPRESSION='snappy',
> MEMSTORE_FLUSH_SIZE = '1073741824') ' without data_block_encoding, I will get
> the data I insert .
> here is a link make help me just using compression.
> http://hadoop-hbase.blogspot.com/2016/02/hbase-compression-vs-blockencoding_17.html
> CREATE TABLE EVENT (
> v_date timestamp(6) NOT NULL,
> sid varchar(16 BYTES) NOT NULL DEFAULT '',
> uid varchar(20 BYTES) NOT NULL DEFAULT '',
> vid int unsigned NOT NULL ,
> idx tinyint NOT NULL,
> created_at int unsigned NOT NULL ,
> p_id bigint NOT NULL ,
> category varchar(255) CHARACTER SET UTF8 NOT NULL,
> e_action varchar(255) CHARACTER SET UTF8 NOT NULL,
> label varchar(255) CHARACTER SET UTF8 NOT NULL,
> e_value int NOT NULL,
> is_bounced tinyint NOT NULL DEFAULT 0,
> primary key (sid,v_date desc,uid,vid,idx)
> )
> salt using 4 partitions on (sid)
> division by (date_trunc('day', v_date))
> HBASE_OPTIONS( DATA_BLOCK_ENCODING = 'FAST_DIFF',
> COMPRESSION='snappy',
> MEMSTORE_FLUSH_SIZE = '1073741824');
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
