You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Doug Meil <do...@explorysmedical.com> on 2013/07/11 02:16:40 UTC
Kudos for Phoenix
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
doug.meil@explorysmedical.com
Re: Kudos for Phoenix
Posted by Doug Meil <do...@explorysmedical.com>.
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" <ji...@gmail.com> wrote:
>Could you give us the test performance, especially use the view of table？
>
>
>2013/7/11 Doug Meil <do...@explorysmedical.com>
>
>>
>> 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" <ji...@gmail.com> 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 <do...@explorysmedical.com>
>> >
>> >> 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
>> >> doug.meil@explorysmedical.com
>> >>
>> >>
>> >>
>> >
>> >
>> >--
>> >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
Re: Kudos for Phoenix
Posted by Bing Jiang <ji...@gmail.com>.
Could you give us the test performance, especially use the view of table？
2013/7/11 Doug Meil <do...@explorysmedical.com>
>
> 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" <ji...@gmail.com> 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 <do...@explorysmedical.com>
> >
> >> 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
> >> doug.meil@explorysmedical.com
> >>
> >>
> >>
> >
> >
> >--
> >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
Re: Kudos for Phoenix
Posted by Doug Meil <do...@explorysmedical.com>.
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" <ji...@gmail.com> 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 <do...@explorysmedical.com>
>
>> 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
>> doug.meil@explorysmedical.com
>>
>>
>>
>
>
>--
>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
Re: Kudos for Phoenix
Posted by Bing Jiang <ji...@gmail.com>.
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 <do...@explorysmedical.com>
> 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
> doug.meil@explorysmedical.com
>
>
>
--
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