phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: Full text query in Phoenix
Date Sun, 18 Sep 2016 16:34:37 GMT
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.


On Sun, Sep 18, 2016 at 9:26 AM, Cheyenne Forbes <> 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?

View raw message