how to write a row_number function in phoenix?

2015-08-17 Thread 曾柏棠
how to write a row_number function in phoenix? -- 本邮件中所包含的信息是保密并受相关法律保护的。本邮件仅供收件人参阅。我们特此告知,如果您不是特定的收件人,您对本邮件任何使用、转发、传播或复制是被严令禁止的,并且可能是违法的,请立即联系发件人,并且销毁所有的原始邮件。 This E-mail and any attachments are confidential and intended solely for the addressees. If you receive this E-mail in error, please

Re: how to write a row_number function in phoenix?

2015-08-17 Thread James Taylor
You might be able to mimic what NEXT VALUE FOR does for sequences, but you wouldn't need any server-side code. We do something similar for query more support by creating a sequence on the fly and using a very big cache value (see WueryMoreIT). On Monday, August 17, 2015, 曾柏棠 zengbait...@ppdai.com

Re: REG: Using Sequences in Phoenix Data Frame

2015-08-17 Thread Josh Mahonin
Oh, neat! I was looking for some references to it in code, unit tests and docs and didn't see anything relevant. It's possible they might just work then, although it's definitely an untested scenario. On Mon, Aug 17, 2015 at 10:48 AM, James Taylor jamestay...@apache.org wrote: Sequences are

Re: REG: Using Sequences in Phoenix Data Frame

2015-08-17 Thread Ns G
It would be really helpful if links to resources are provided where sequences are used in Map reduce which I will try to replicate in spark. Thank you James and Josh for your answers. On 17-Aug-2015 8:25 pm, Josh Mahonin jmaho...@interset.com wrote: Oh, neat! I was looking for some references