Using COUNT() with columns that don't use COUNT() when the table is join fails

this query fails: SELECT COUNT(fr.friend_1), u.first_name > > FROM users AS u > > LEFT JOIN friends AS fr ON u.id = fr.friend_2 > > with: SQLException: ERROR 1018 (42Y27): Aggregate may not contain columns not in > GROUP BY. U.FIRST_NAME > TABLES: users table with these

Re: using MapReduce java.sql.SQLException: No suitable driver found for jdbc:phoenix occured.

Hi. I created a fat jar with client.jar. there is thePhoenixDriver class in that fat jar. and class.forName call has no error. Can I have other check list? Regards. > On Sep 15, 2016, at 8:59 AM, Josh Elser wrote: > > phoenix-4.8.0-HBase-1.1-client.jar is the jar which

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: Phoenix "LIKE 'query%' " performance

On Sunday, September 18, 2016, Cheyenne Forbes < cheyenne.osanu.for...@gmail.com> wrote: > >- Can it be fast? >- does it use the Hbase regex feature? > > It's a similar implementation, but with some optimizations around the prefix patterns mentioned below. > >- how can I make it case

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

Phoenix "LIKE 'query%' " performance

- Can it be fast? - does it use the Hbase regex feature? - how can I make it case insensitive? so when I do "LIKE 'query%' " the results include "Query" - Can I get millisecond results using "WHERE column LIKE" on a large table? couple terabytes of data - is it recommended

Re: Joins dont work

Thank you, I got the error because I copied the queryserver jar instead of the server jar :)

Re: Joins dont work

Maybe this might help you: https://issues.apache.org/jira/browse/PHOENIX-1531 It seems like a classpath problem in your setup. On Sat, Sep 17, 2016 at 2:14 PM, Cheyenne Forbes < cheyenne.osanu.for...@gmail.com> wrote: > does anyone have an idea whats causing this? > -- Thanks & Regards,