phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Reid <gabriel.r...@gmail.com>
Subject Re: Upsert command with prepared statement syntax
Date Thu, 10 Sep 2015 18:44:13 GMT
Hi,

Using prepared statements with Phoenix is basically the same as using
insert or update statements with any other JDBC driver (see
https://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html for
more details on this in general).

The one difference is that the actual SQL syntax that you use makes
use of the UPSERT keyword instead of INSERT or UPDATE. The specific
grammar is shown here:
http://phoenix.apache.org/language/index.html#upsert_values

- Gabriel


On Thu, Sep 10, 2015 at 6:33 PM, Hafiz Mujadid <hafizmujadid00@gmail.com> wrote:
> Hi
>
> I want to upsert data using prepared statement and batch update.
>
> Is there any example for it?

Mime
View raw message