I am using hibernate to query Hbase which has a Phoenix on top of it to facilitate SQL querries But i am getting response code 500 from the DB but the exact same query is giving me result from Phoenix Sql client....I have tried changing the cfg file and found that the error remains the same if I provide a different dialect so I am guessing I am giving the wrong dialect in the first place. Currently i am giving MySql dialect for the query. I could not find a specific name for Phoenix dialect. Do i have to write my own?? If not which dialect should i use. I am using hibernateb 3.x with phoenix thin client 4.4 jar. Connection is success but error is response code 500 from Java end

I don't recall any Hibernate Dialect for Apache Pheonix.

Michalces,
Are you saying nothing exist or that you dont have info....If you dont have an info on this could you give me some links to research cause till now i havent found anything..

This is the list of Dialects that Hibernate supports:

http://docs.jboss.org/hibernate/orm/5.2 ... frame.html