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
