You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hbase.apache.org by raddad555 <wb...@comcast.net> on 2014/04/23 17:32:19 UTC
Leaving the world of SQL, need some basic guidance and/or ideas
Anyone that has worked with SQL has sometime used views to allow the server
to do have results sets handled by the server . I am looking for an
equivalent in hbase and any other business logic thoughts or ideas that
would take some weight off of the application side of the equation.
--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Leaving-the-world-of-SQL-need-some-basic-guidance-and-or-ideas-tp4058499.html
Sent from the HBase Developer mailing list archive at Nabble.com.
Re: Leaving the world of SQL, need some basic guidance and/or ideas
Posted by Ted Yu <yu...@gmail.com>.
Use this link in the interim:
http://webcache.googleusercontent.com/search?q=cache:http://blogs.apache.org/hbase/entry/coprocessor_introduction
Please also consider using Filter:
https://hbase.apache.org/book/client.filter.html
Cheers
On Wed, Apr 23, 2014 at 8:50 AM, Bryan Beaudreault <bbeaudreault@hubspot.com
> wrote:
> Coprocessors:
> https://blogs.apache.org/hbase/entry/coprocessor_introduction
>
> The blog appears to be down or slow right now though.
>
>
> On Wed, Apr 23, 2014 at 11:32 AM, raddad555 <wblackwell555@comcast.net
> >wrote:
>
> > Anyone that has worked with SQL has sometime used views to allow the
> server
> > to do have results sets handled by the server . I am looking for an
> > equivalent in hbase and any other business logic thoughts or ideas that
> > would take some weight off of the application side of the equation.
> >
> >
> >
> > --
> > View this message in context:
> >
> http://apache-hbase.679495.n3.nabble.com/Leaving-the-world-of-SQL-need-some-basic-guidance-and-or-ideas-tp4058499.html
> > Sent from the HBase Developer mailing list archive at Nabble.com.
> >
>
Re: Leaving the world of SQL, need some basic guidance and/or ideas
Posted by lars hofhansl <la...@apache.org>.
2nd'ed... That is *exactly* what Phoenix was built to do.
________________________________
From: Jesse Yates <je...@gmail.com>
To: dev@hbase.apache.org
Sent: Wednesday, April 23, 2014 9:22 AM
Subject: Re: Leaving the world of SQL, need some basic guidance and/or ideas
If you want to stay with the SQL syntax, give Phoenix (
http://phoenix.incubator.apache.org) - its a light 'skin' on HBase that
supports most sql syntax. Its got views, predicate push down, secondary
indexes and some join support.
I'm a little biased as im a phoenix committer :)
On Apr 23, 2014 9:13 AM, "raddad555" <wb...@comcast.net> wrote:
> Bryan thanks for the quick response , I will take a look at coprocessors
> and
> the blog when its up.
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/Leaving-the-world-of-SQL-need-some-basic-guidance-and-or-ideas-tp4058499p4058501.html
> Sent from the HBase Developer mailing list archive at Nabble.com.
>
Re: Leaving the world of SQL, need some basic guidance and/or ideas
Posted by raddad555 <wb...@comcast.net>.
yes i saw that but presently working with a mongo db , so not so much looking
for syntax preservation but thanks.
--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Leaving-the-world-of-SQL-need-some-basic-guidance-and-or-ideas-tp4058499p4058511.html
Sent from the HBase Developer mailing list archive at Nabble.com.
Re: Leaving the world of SQL, need some basic guidance and/or ideas
Posted by Jesse Yates <je...@gmail.com>.
If you want to stay with the SQL syntax, give Phoenix (
http://phoenix.incubator.apache.org) - its a light 'skin' on HBase that
supports most sql syntax. Its got views, predicate push down, secondary
indexes and some join support.
I'm a little biased as im a phoenix committer :)
On Apr 23, 2014 9:13 AM, "raddad555" <wb...@comcast.net> wrote:
> Bryan thanks for the quick response , I will take a look at coprocessors
> and
> the blog when its up.
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/Leaving-the-world-of-SQL-need-some-basic-guidance-and-or-ideas-tp4058499p4058501.html
> Sent from the HBase Developer mailing list archive at Nabble.com.
>
Re: Leaving the world of SQL, need some basic guidance and/or ideas
Posted by raddad555 <wb...@comcast.net>.
Bryan thanks for the quick response , I will take a look at coprocessors and
the blog when its up.
--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Leaving-the-world-of-SQL-need-some-basic-guidance-and-or-ideas-tp4058499p4058501.html
Sent from the HBase Developer mailing list archive at Nabble.com.
Re: Leaving the world of SQL, need some basic guidance and/or ideas
Posted by Bryan Beaudreault <bb...@hubspot.com>.
Coprocessors: https://blogs.apache.org/hbase/entry/coprocessor_introduction
The blog appears to be down or slow right now though.
On Wed, Apr 23, 2014 at 11:32 AM, raddad555 <wb...@comcast.net>wrote:
> Anyone that has worked with SQL has sometime used views to allow the server
> to do have results sets handled by the server . I am looking for an
> equivalent in hbase and any other business logic thoughts or ideas that
> would take some weight off of the application side of the equation.
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/Leaving-the-world-of-SQL-need-some-basic-guidance-and-or-ideas-tp4058499.html
> Sent from the HBase Developer mailing list archive at Nabble.com.
>