Re: Full text query in Phoenix

[Jean-Marc Spaggiari]

HBase + Lily Indexer + SOLR will do that very well. As James said, Phoenix
might not help with the full time. Google for that and you will find many
pointers for web articules or even books.

JMS

2016-09-19 9:05 GMT-04:00 Cheyenne Forbes :

> Hi James,
>
> Thanks a lot, I found a link showing how to integrate hbase with lucene
> https://itpeernetwork.intel.com/idh-hbase-lucene-integration/
>

Re: Full text query in Phoenix

[Cheyenne Forbes]

Hi James,

Thanks a lot, I found a link showing how to integrate hbase with lucene
https://itpeernetwork.intel.com/idh-hbase-lucene-integration/

Re: Full text query in Phoenix

[James Taylor]

Phoenix isn't going to help with full text search. You need to use some
kind of search solution with HBase (i.e. revive HBASE-3529). Elastic Search
may have something available - have you asked them? If you need to do SQL
querying in addition to full text search, you could potentially use an
Elastic Search adapter in Calcite (I believe something is available, but
you can ask the Apache Calcite community) in combination with Phoenix on
our calcite branch. The Phoenix/Calcite integration is a work-in-progress.
We're making good progress, but it's not ready for production usage yet.

Thanks,
James

On Sun, Sep 18, 2016 at 9:26 AM, Cheyenne Forbes <
cheyenne.osanu.for...@gmail.com> wrote:

> Hi Anil,
>
> If I have:
>
> users table with these columns ( id, first_name, last_name )
>
>
> friends table with these columns ( friend_1, friend_2 )
>
>
>
>> user_posts table with these columns ( user_id, post_text, date_time )
>
>
> in hbase (phoenix) and I want to view all user posts (post_text) with
> similar things (full test search) to "children playing at the beach" that
> were posted by people in my friends list, how could I achieve this if I use
> phoenix?
>

Re: Full text query in Phoenix

[Cheyenne Forbes]

Hi Anil,

If I have:

users table with these columns ( id, first_name, last_name )


friends table with these columns ( friend_1, friend_2 )



> user_posts table with these columns ( user_id, post_text, date_time )


in hbase (phoenix) and I want to view all user posts (post_text) with
similar things (full test search) to "children playing at the beach" that
were posted by people in my friends list, how could I achieve this if I use
phoenix?

Re: Full text query in Phoenix

[anil gupta]

IMO, you should not use HBase or anyone other Database for full text query.
You should look into using search engines like Solr, Elastic Search, etc
for implementing full text search/query.

On Sun, Sep 18, 2016 at 7:10 AM, Cheyenne Forbes <
cheyenne.osanu.for...@gmail.com> wrote:

> Hi James,
>
> I found this for Hbase
> https://issues.apache.org/jira/browse/HBASE-3529
>
> its patch that can be added to hbase based on what I am seeing
>



-- 
Thanks & Regards,
Anil Gupta

Re: Full text query in Phoenix

[Cheyenne Forbes]

Hi James,

I found this for Hbase
https://issues.apache.org/jira/browse/HBASE-3529

its patch that can be added to hbase based on what I am seeing

Re: Full text query in Phoenix

[James Taylor]

Hi Cheyenne,
Phoenix does not have full text query capability, so the best you can do
today is use our regex built-in functions (which won't be particularly
performant). Would you mind filing a JIRA with any ideas for how best to
expose this functionality?
Thanks,
James

On Wednesday, September 7, 2016, Cheyenne Forbes <
cheyenne.osanu.for...@gmail.com> wrote:

> I am using phoenix for my platform but I cant do full text queries
>
> "SELECT ID, FirstName, Lastname FROM users
>WHERE MATCH (FirstName, Lastname)
>  AGAINST ('first_name last_name' IN BOOLEAN MODE)
>AND [Searcher not blocked by user]
>
> Regards,
> Cheyenne
>

Full text query in Phoenix

[Cheyenne Forbes]

I am using phoenix for my platform but I cant do full text queries

"SELECT ID, FirstName, Lastname FROM users
   WHERE MATCH (FirstName, Lastname)
 AGAINST ('first_name last_name' IN BOOLEAN MODE)
   AND [Searcher not blocked by user]

Regards,
Cheyenne