phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Sequence Issue in Phoenix with JDBC
Date Tue, 25 Aug 2015 07:36:17 GMT
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 <divs.sheth@gmail.com> 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
>
>
>

Mime
View raw message