[PHOENIX-256] Allow Select of entire Families Key/values

• Type: Task
• Status: Resolved
• Resolution: Fixed
• Labels: enhancement
• old issue number: 125
• Assignee: Unassigned
• Reporter: nicolas maillard
• Created: 10/Mar/14 23:46
• Updated: 16/Mar/14 07:18
• Resolved: 16/Mar/14 07:18

Description

One of the key strength of Hbase is to not be to strict on the schema. You can create logical buckets of data aka columFamilies and store what you want in it as time goes by.

It would be a greate feature to be able to query on one or more Families without specifiying explicitely the qualifier, for select FAMILY_A.,FAMILY_B. from my_table

Added bonus would to be able to filter on qualifier or value with either a regexp or standard "like",">","<" ,[position] filters. This kind of looks like the map or array functionnality from Hive.

This of course has a number of issues:

• Size limit these families could have thousands of entries.
• Type: without prior notion of data type (BIGINT..) how to work out the where clauses.