Re: Phoenix 4.4+ on CDH

2015-08-22 Thread Lukáš Lalinský
On Sat, Aug 22, 2015 at 1:26 AM, Ns G nsgns...@gmail.com wrote: But, what I can suggest is with minimal changes to the phoenix code you will be able to build deploy phoenix on CDH 5.4.x version. I didn't try phoenix query server but I was able to generate all server and client jars and

Re: REG: Getting the current value of a sequence

2015-08-22 Thread Ns G
Thank you James and Ravi. This has helped Satya On 22-Aug-2015 11:29 pm, James Taylor jamestay...@apache.org wrote: Hi Satya, You can do a NEXT VALUE FOR in a SELECT clause without a from clause like this: SELECT NEXT VALUE FOR my_seq; This will allocate a block of sequences from the

Re: REG: Getting the current value of a sequence

2015-08-22 Thread Ravi Kiran
Hi Satya, Unless you call NEXT VALUE FOR on a sequence *the first time*, you wouldn't be getting the CURRENT VALUE . So , instead of getting the CURRENT VALUE, you can get the NEXT VALUE and then pass to your upsert query. Hope this helps On Sat, Aug 22, 2015 at 7:59 AM, Ns G

Re: REG: Getting the current value of a sequence

2015-08-22 Thread James Taylor
Hi Satya, You can do a NEXT VALUE FOR in a SELECT clause without a from clause like this: SELECT NEXT VALUE FOR my_seq; This will allocate a block of sequences from the server (as determined by the CACHE clause when you create the sequence), cache them on the client, and dole them out as NEXT

phoenix-server JAR not packaged in 4.5.1?

2015-08-22 Thread Lukáš Lalinský
I have just downloaded the 4.5.1 bin package and it seems that there is no phoenix-server JAR file in it. Running queryserver.py fails with: Error: Could not find or load main class org.apache.phoenix.queryserver.server.Main I assume this is just a mistake, or has the way to start the server

REG: Getting the current value of a sequence

2015-08-22 Thread Ns G
Hi All, I have a requirement where the sequence number is to be prefetched and then used in upsert query. I know that Current Value for a sequence number gives me the last used value. But It does not return value for the first time until and unless used in a upsert query. Is there any

Re: phoenix-server JAR not packaged in 4.5.1?

2015-08-22 Thread James Taylor
No, not intentional. Would you mind filing a JIRA and reference the pull request you found that caused the issue? Thanks, James On Saturday, August 22, 2015, Lukáš Lalinský lalin...@gmail.com wrote: I have just downloaded the 4.5.1 bin package and it seems that there is no phoenix-server JAR