You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by Ahmed Hussien <aa...@gmail.com> on 2014/07/09 10:28:35 UTC
Fwd: How can we add new keywords to Phoenix?
---------- Forwarded message ----------
From: Ahmed Hussien <aa...@gmail.com>
Date: Wed, Jul 9, 2014 at 11:18 AM
Subject: Re: How can we add new keywords to Phoenix?
To: James Taylor <ja...@apache.org>
Dear James,
KEYWORD is some kind of properties for an attribute which we added in our
project.
Say for example i want to select the last approved value for a specific
attribute from a specific table, the keyword here is lastApproved so the
query would be:
Select lastApproved attribute from table;
Knowing That I have filters for Hbase the do the selection process, and
that all I want to do is to integrate this to pheonix as an SQL command.
On Tue, Jul 8, 2014 at 7:56 PM, James Taylor <ja...@apache.org> wrote:
> Hello,
> I'm not sure what you mean by KEYWORD. Would you be able to share a
> concrete example and use case?
>
> Have you seen our reference guide linked off our website?
> http://phoenix.apache.org/language/index.html
>
> Thanks,
> James
>
> On Mon, Jul 7, 2014 at 12:53 PM, Ahmed Hussien <aa...@gmail.com>
> wrote:
> > Hello,
> > Good Day...
> > I'm working in a project that requires adding new keywords to the regular
> > SQL statements and we decided to use Phoenix over hbase.
> > I actually have three (3) types of keywords, and I'll Give you an example
> > for them below:
> >
> > 1- Select (KEYWORD) attribute from table;
> > 2- Select (KEYWORD1) attribute from table1 where ((KEYWORD2)
> > table1.attribute1= (KEYWORD3)table2.attribute2);
> > 3- Select (KEYWORD1) attribute from table1 where ((KEYWORD2)
> > table1.attribute1= value);
> >
> > The Questions are:
> > 1- Which types are supported in Phoenix?
> > 2- What is the most easy way to implement these keywords?
> > 3- Does built in functions support the three types?
> > 4- if you have a detailed guide could you please send it to me
> > ----
> > Thanks and best regards
> > Ahmed
> >
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Phoenix HBase User" group.
> > To unsubscribe from this group and stop receiving emails from it, send an
> > email to phoenix-hbase-user+unsubscribe@googlegroups.com.
> > For more options, visit https://groups.google.com/d/optout.
>
--
Thanks and Best Regards
-------
Eng. Ahmed Hussien
+20101273114
--
Thanks and Best Regards
-------
Eng. Ahmed Hussien
+20101273114
Re: How can we add new keywords to Phoenix?
Posted by James Taylor <ja...@apache.org>.
Hi Ahmed,
If the motivation is to make SQL simple enough for an end-user
unfamiliar with it to write queries, then I'd recommend putting a GUI
front-end on top of Phoenix. You'd then have the GUI generate standard
SQL. This is a very typical scenario in the world of business
applications.
The mission of Phoenix is to be standards compliant and we have no
plans on deviating from this.
Thanks,
James
On Sun, Jul 13, 2014 at 7:57 AM, Anoop John <an...@gmail.com> wrote:
> Still not so clear.
>
> Can you say how you modelled your table schema in case of HBase and how was
> your Scan and what was FIlter implementation. Seeing these and the code
> we will be able to better understand your requirement.
>
> -Anoop-
>
> On Wed, Jul 9, 2014 at 1:58 PM, Ahmed Hussien <aa...@gmail.com> wrote:
>
>> ---------- Forwarded message ----------
>> From: Ahmed Hussien <aa...@gmail.com>
>> Date: Wed, Jul 9, 2014 at 11:18 AM
>> Subject: Re: How can we add new keywords to Phoenix?
>> To: James Taylor <ja...@apache.org>
>>
>>
>> Dear James,
>>
>> KEYWORD is some kind of properties for an attribute which we added in our
>> project.
>> Say for example i want to select the last approved value for a specific
>> attribute from a specific table, the keyword here is lastApproved so the
>> query would be:
>>
>> Select lastApproved attribute from table;
>>
>> Knowing That I have filters for Hbase the do the selection process, and
>> that all I want to do is to integrate this to pheonix as an SQL command.
>>
>>
>> On Tue, Jul 8, 2014 at 7:56 PM, James Taylor <ja...@apache.org>
>> wrote:
>>
>> > Hello,
>> > I'm not sure what you mean by KEYWORD. Would you be able to share a
>> > concrete example and use case?
>> >
>> > Have you seen our reference guide linked off our website?
>> > http://phoenix.apache.org/language/index.html
>> >
>> > Thanks,
>> > James
>> >
>> > On Mon, Jul 7, 2014 at 12:53 PM, Ahmed Hussien <aa...@gmail.com>
>> > wrote:
>> > > Hello,
>> > > Good Day...
>> > > I'm working in a project that requires adding new keywords to the
>> regular
>> > > SQL statements and we decided to use Phoenix over hbase.
>> > > I actually have three (3) types of keywords, and I'll Give you an
>> example
>> > > for them below:
>> > >
>> > > 1- Select (KEYWORD) attribute from table;
>> > > 2- Select (KEYWORD1) attribute from table1 where ((KEYWORD2)
>> > > table1.attribute1= (KEYWORD3)table2.attribute2);
>> > > 3- Select (KEYWORD1) attribute from table1 where ((KEYWORD2)
>> > > table1.attribute1= value);
>> > >
>> > > The Questions are:
>> > > 1- Which types are supported in Phoenix?
>> > > 2- What is the most easy way to implement these keywords?
>> > > 3- Does built in functions support the three types?
>> > > 4- if you have a detailed guide could you please send it to me
>> > > ----
>> > > Thanks and best regards
>> > > Ahmed
>> > >
>> > > --
>> > > You received this message because you are subscribed to the Google
>> Groups
>> > > "Phoenix HBase User" group.
>> > > To unsubscribe from this group and stop receiving emails from it, send
>> an
>> > > email to phoenix-hbase-user+unsubscribe@googlegroups.com.
>> > > For more options, visit https://groups.google.com/d/optout.
>> >
>>
>>
>>
>> --
>> Thanks and Best Regards
>> -------
>> Eng. Ahmed Hussien
>> +20101273114
>>
>>
>>
>> --
>> Thanks and Best Regards
>> -------
>> Eng. Ahmed Hussien
>> +20101273114
>>
Re: How can we add new keywords to Phoenix?
Posted by Anoop John <an...@gmail.com>.
Still not so clear.
Can you say how you modelled your table schema in case of HBase and how was
your Scan and what was FIlter implementation. Seeing these and the code
we will be able to better understand your requirement.
-Anoop-
On Wed, Jul 9, 2014 at 1:58 PM, Ahmed Hussien <aa...@gmail.com> wrote:
> ---------- Forwarded message ----------
> From: Ahmed Hussien <aa...@gmail.com>
> Date: Wed, Jul 9, 2014 at 11:18 AM
> Subject: Re: How can we add new keywords to Phoenix?
> To: James Taylor <ja...@apache.org>
>
>
> Dear James,
>
> KEYWORD is some kind of properties for an attribute which we added in our
> project.
> Say for example i want to select the last approved value for a specific
> attribute from a specific table, the keyword here is lastApproved so the
> query would be:
>
> Select lastApproved attribute from table;
>
> Knowing That I have filters for Hbase the do the selection process, and
> that all I want to do is to integrate this to pheonix as an SQL command.
>
>
> On Tue, Jul 8, 2014 at 7:56 PM, James Taylor <ja...@apache.org>
> wrote:
>
> > Hello,
> > I'm not sure what you mean by KEYWORD. Would you be able to share a
> > concrete example and use case?
> >
> > Have you seen our reference guide linked off our website?
> > http://phoenix.apache.org/language/index.html
> >
> > Thanks,
> > James
> >
> > On Mon, Jul 7, 2014 at 12:53 PM, Ahmed Hussien <aa...@gmail.com>
> > wrote:
> > > Hello,
> > > Good Day...
> > > I'm working in a project that requires adding new keywords to the
> regular
> > > SQL statements and we decided to use Phoenix over hbase.
> > > I actually have three (3) types of keywords, and I'll Give you an
> example
> > > for them below:
> > >
> > > 1- Select (KEYWORD) attribute from table;
> > > 2- Select (KEYWORD1) attribute from table1 where ((KEYWORD2)
> > > table1.attribute1= (KEYWORD3)table2.attribute2);
> > > 3- Select (KEYWORD1) attribute from table1 where ((KEYWORD2)
> > > table1.attribute1= value);
> > >
> > > The Questions are:
> > > 1- Which types are supported in Phoenix?
> > > 2- What is the most easy way to implement these keywords?
> > > 3- Does built in functions support the three types?
> > > 4- if you have a detailed guide could you please send it to me
> > > ----
> > > Thanks and best regards
> > > Ahmed
> > >
> > > --
> > > You received this message because you are subscribed to the Google
> Groups
> > > "Phoenix HBase User" group.
> > > To unsubscribe from this group and stop receiving emails from it, send
> an
> > > email to phoenix-hbase-user+unsubscribe@googlegroups.com.
> > > For more options, visit https://groups.google.com/d/optout.
> >
>
>
>
> --
> Thanks and Best Regards
> -------
> Eng. Ahmed Hussien
> +20101273114
>
>
>
> --
> Thanks and Best Regards
> -------
> Eng. Ahmed Hussien
> +20101273114
>