hbase-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "He Yongqiang (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HBASE-5457) add inline index in data block for data which are not clustered together
Date Thu, 23 Feb 2012 20:10:50 GMT

    [ 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

        

Mime
View raw message