Hi Kunal, Appreciate if you can show the code you have written to help you in the problems you are facing(if any). If you have setup Phoenix and Hadoop and HBase correctly , upserting values into a table is simple using the standard jdbc code.
You can have a look at this *toy code* here https://gist.github.com/mravi/501fa00b942764eb0dca#file-stocksampledatagenerator-java. Regards Ravi On Sun, Dec 28, 2014 at 11:31 AM, Kunal Gupta <[email protected]> wrote: > Hello > > I am doing MTech From IIIT-DELHI. Recently i am working on your > project(Apache Phoenix) and successful in Integrating Apache Phoenix on > Apache HBase under Hadoop File system in Pseudo Distributed. > > I want to implemet some algorithm in 2 tier way , where one tier is a JAVA > application and another is your Apache phoenix connected to HBase. By help > of JAVA application i am successful in making connection with phoenix using > JDBC Driver and tried to run all DML and DDL statement after creating > connection but when i ran UPSERT STATEMENT query in executeUpdate() > function of PhoenixStatement class then without giving error it runs but > when i check whether the value is inserted or not then it shows me 0 rows > affected in table and when i ran CREATE TABLE query statement in same > executeUpdate() function of PhoenixStatement class then it created the > table in HBase. > > So please can you help me , how can i UPSERT the values into table by java > application. > > Please help me how can i fix it to insert all values into table through > JAVA APPLICATION. > > Thanks , Kunal > >
