Re: Full text query in Phoenix

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

Re: Full text query in Phoenix

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

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

Re: Full text query in Phoenix

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

Re: Full text query in Phoenix

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, > >

Re: Full text query in Phoenix

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

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,

Full text query in Phoenix

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