Mailing-List: contact issues-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Date: Thu, 23 Feb 2012 20:10:50 +0000 (UTC)
From: "He Yongqiang (Commented) (JIRA)" <jira@apache.org>
To: issues@hbase.apache.org
Message-ID: 
 <821629245.11361.1330027850128.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <219814322.6418.1329947988689.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (HBASE-5457) add inline index in data block for
 data which are not clustered together
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/HBASE-5457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13215002#comment-13215002 ] 

He Yongqiang commented on HBASE-5457:
-------------------------------------

@lars, in today's implementation we actually create another column family and reorg the column name to be 'ts and string', so the data is sorted by ts in this new column family. And we redirect the query to use the second column family. But this approach duplicates data. 
Without the second column family, we can do a search once we found the row. but that requires searching all data with the target row key. It hurts cpu. 
                
> add inline index in data block for data which are not clustered together
> ------------------------------------------------------------------------
>
>                 Key: HBASE-5457
>                 URL: https://issues.apache.org/jira/browse/HBASE-5457
>             Project: HBase
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>
> As we are go through our data schema, and we found we have one large column family which is just duplicating data from another column family and is just a re-org of the data to cluster data in a different way than the original column family in order to serve another type of queries efficiently.
> If we compare this second column family with similar situation in mysql, it is like an index in mysql. So if we can add inline block index on required columns, the second column family then is not needed.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira