I suspect you may not being doing a connection.commit() from your JDBC client. Sqline runs with autocommit on, but regular Phoenix connections do not (unless you set phoenix.connection.autoCommit to true in your hbase-sites-xml).
Thanks, James On Tue, Aug 25, 2015 at 12:28 AM, divye sheth <[email protected]> wrote: > Hi Team, > > I am using phoenix to store data, below are the details of the cluster: > Phoenix Version: 4.4.0 > Hadoop Version: 2.6.0 > Hbase Version: 0.98 > > I have three tables: > 1. Employee table: > EmpId > Name > Address > > 2. Salary Table: > SalId > EmpId - Foreign Key > Salary > > 3. Transaction Table: (This is a flat table containing fields combining > the above tables) > Employee Name > Address > Salary... > > Now while populating the Salary table I make use of the salary_seq which I > have created using the "CREATE SEQUENCE" command. > The query being created is: > UPSERT INTO SALARY(SALID, EMPID, SALARY) SELECT NEXT VALUE FOR SALARY_SEQ, > EMPID, SALARY FROM TRANSACTION INNER JOIN EMPLOYEE ON ( > TRANSCATION.EMPLOYEENAME = EMPLOYEE.EMPLOYEENAME ) > > The above query when executed from the sqlline interface inserts records > into the SALARY table but when the same is executed from JDBC there are no > inserts. I am sure it is to do with SEQUENCE, but cant figure out what is > wrong. > > Why is the sequence not getting incremented with JDBC call to Phoenix? > Please let me know if this is an issue, if yes then how can I resolve it. > If sequence is not the issue then please help me with giving pointers as to > what could be? > > Thanks > Divye Sheth > > >
