Re: Define parameters in queries

or should I say "declare variables in Phoenix" instead of "defining variables in Phoenix"?

Re: Define parameters in queries

Can you show me an example of defining variables in Phoenix (not send a parameter)? I am getting errors, how would I do this in phoenix: *@my_variable := CASE WHEN my_column IS NULL THEN "this value" ELSE "that value" END*

Re: python-phoenixdb

Thanks, Dimitri! If you're interested, I think the community would welcome this as a contribution to Apache Phoenix so it can appear in our regular distributions. Regards, James On Thu, Mar 23, 2017 at 5:21 PM, Dimitri wrote: > Hi, > > I make some update on my fork of Lukáš

[ANNOUNCE] Apache Phoenix 4.10 released

The Apache Phoenix team is pleased to announce the immediate availability of the 4.10.0 release. Apache Phoenix enables SQL-based OLTP and operational analytics for Hadoop using Apache HBase as its backing store and providing integration with other projects in the ecosystem such as Spark, Hive,

Re: Define parameters in queries

Yes, it will work. Pure JDBC only supports index, not named parameters. Named parameter (:userId) is not part of Java. There are third party libraries supporting it. http://www.javaworld.com/article/2077706/core-java/named-parameters-for-preparedstatement.html Regards, Will

Re: Define parameters in queries

Will I be able to change the value of userId from in the query? *:**userId = CASE WHEN **userId > 10 THEN **userId ELSE **(userId + 1) END*

Re: Define parameters in queries

?Hi Cheyenne, Phoenix connections are standard JDBC connections. This means you can use prepareStatement API to do parameter substitution. >From SO: >http://stackoverflow.com/questions/12745186/passing-parameters-to-a-jdbc-preparedstatement statement =con.prepareStatement("SELECT * from

Re: Define parameters in queries

Anyone?