Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase, mail # user - Kudos for Phoenix


+
Doug Meil 2013-07-11, 00:16
+
Bing Jiang 2013-07-11, 02:13
+
Doug Meil 2013-07-11, 12:34
+
Bing Jiang 2013-07-12, 01:59
Copy link to this message
-
Re: Kudos for Phoenix
Doug Meil 2013-07-12, 02:39

This particular use case is effectively a full scan on the table, but with
server-side filters.  Internally, Hbase still has to scan all the data -
there's no magic.
On 7/11/13 9:59 PM, "Bing Jiang" <[EMAIL PROTECTED]> wrote:

>Could you give us the test performance, especially use the view of table?
>
>
>2013/7/11 Doug Meil <[EMAIL PROTECTED]>
>
>>
>> You still have to register the view to phoenix and define which CF's and
>> columns you are accessing, so this isn't entirely free form...
>>
>> create view
>> "myTable" ("cf" VARCHAR primary key,
>> "cf"."attr1" VARCHAR, "cf"."attr2"
>> VARCHAR);
>>
>> … however, "myTable" in the above example is the HBase table you created
>> outside Phoenix, so Phoenix doesn't need to copy any data, etc..
>>
>>
>>
>>
>>
>>
>>
>>
>> On 7/10/13 10:13 PM, "Bing Jiang" <[EMAIL PROTECTED]> wrote:
>>
>> >Hi, Doug.
>> >If build view upon Phoenix uncontrolled tables, whether it can be used
>>to
>> >column family or qualifier?
>> >
>> >I want to know your design details.
>> >
>> >
>> >2013/7/11 Doug Meil <[EMAIL PROTECTED]>
>> >
>> >> Hi folks,
>> >>
>> >> I just wanted to give a shout out to the Phoenix framework, and
>> >> specifically for the ability to create "view" against an HBase table
>> >>whose
>> >> schema was not being managed by Phoenix.  That's a really nice
>>feature
>> >>and
>> >> I'm not sure how many folks realize this.  I was initially nervous
>>that
>> >> this was only for data created with Phoenix, but that's not the case,
>> >>so if
>> >> you're looking for a lightweight framework for SQL-on-HBase I'd
>>check it
>> >> out.  For this particular scenario it's probably better for ad-hoc
>>data
>> >> exploration, but often that's what people are looking to do.
>> >>
>> >> Doug Meil
>> >> Chief Software Architect, Explorys
>> >> [EMAIL PROTECTED]
>> >>
>> >>
>> >>
>> >
>> >
>> >--
>> >Bing Jiang
>> >Tel:(86)134-2619-1361
>> >weibo: http://weibo.com/jiangbinglover
>> >BLOG: http://blog.sina.com.cn/jiangbinglover
>> >National Research Center for Intelligent Computing Systems
>> >Institute of Computing technology
>> >Graduate University of Chinese Academy of Science
>>
>>
>
>
>--
>Bing Jiang
>Tel:(86)134-2619-1361
>weibo: http://weibo.com/jiangbinglover
>BLOG: http://blog.sina.com.cn/jiangbinglover
>National Research Center for Intelligent Computing Systems
>Institute of Computing technology
>Graduate University of Chinese Academy of Science