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