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 <[email protected]> wrote: > ---------- Forwarded message ---------- > From: Ahmed Hussien <[email protected]> > Date: Wed, Jul 9, 2014 at 11:18 AM > Subject: Re: How can we add new keywords to Phoenix? > To: James Taylor <[email protected]> > > > 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 <[email protected]> > 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 <[email protected]> > > 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 [email protected]. > > > 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 >
