Ravi Kiran , Can you explain me how can i use LAST_VALUE and FIRST_VALUE of aggregate function ? i am running SELECT LAST_VALUE( SUBSTATUS ) FROM EVENTLOG WITHIN GROUP (ORDER BY CASEID DESC) ;
where caseid,substatus are attribute and eventlog is table. it shows me error Thanks , Kunal On Mon, Dec 29, 2014 at 10:11 PM, Kunal Gupta <[email protected]> wrote: > Thanks , it worked for me ..... :) > > Thanks , Kunal > > > On Mon, Dec 29, 2014 at 10:03 PM, Anirudha Khanna < > [email protected]> wrote: > >> You should either call "connection.commit()" after executing the >> statement or set auto commit "ON" on the connection. >> >> Anirudha >> >> On Mon, Dec 29, 2014 at 7:48 PM, Kunal Gupta <[email protected]> >> wrote: >> >>> Please see the attached file of code and let me know where can i change >>> so that it start working >>> >>> Thanks , Kunal >>> >>> >>> On Mon, Dec 29, 2014 at 7:47 PM, Kunal Gupta <[email protected]> >>> wrote: >>> >>>> Please see the attached file of code and let me know where can i change >>>> so that it start working >>>> >>>> Thanks , Kunal >>>> >>>> >>>> On Mon, Dec 29, 2014 at 1:14 AM, Ravi Kiran <[email protected]> >>>> wrote: >>>> >>>>> 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 >>>>>> >>>>>> >>>>> >>>> >>> >> >
