Re: Phoenix join on derived table and documentation

2017-09-25 Thread James Taylor
Ryan - did the work around solve the issue? Thanks, James On Fri, Sep 22, 2017 at 11:22 AM, Maryann Xue wrote: > Hi Ryan, > > Could you please try: > > select > > MAIN.EBELN as PO_DOC, > > MAIN.EBELP as PO_DOC_ITEM_NUM, > > XREF.DELV_DOC > > from EKPO as MAIN > > left

Phoenix Connection

2017-09-25 Thread Kumar Palaniappan
After we did upgrade to 4.10 on a CDH 5.10, we do see too many ZK connections (increased the max connections form 60->300->1000), but the problem still exist. Are there any known issues? Phoenix connection leak? Appreciate your time.

Re: [ANNOUNCE] New PMC Member: Sergey Soldatov

2017-09-25 Thread James Taylor
Great to have you on the PMC, Sergey. Congrats! James On Mon, Sep 25, 2017 at 10:28 AM, Josh Mahonin wrote: > Congratulations Sergey! > > On Sun, Sep 24, 2017 at 4:05 PM, Ted Yu wrote: > > > Congratulations, Sergey ! > > > > On Sun, Sep 24, 2017 at

Re: [ANNOUNCE] New PMC Member: Sergey Soldatov

2017-09-25 Thread Josh Mahonin
Congratulations Sergey! On Sun, Sep 24, 2017 at 4:05 PM, Ted Yu wrote: > Congratulations, Sergey ! > > On Sun, Sep 24, 2017 at 1:00 PM, Josh Elser wrote: > >> All, >> >> The Apache Phoenix PMC has recently voted to extend an invitation to >> Sergey to

Re: using index with "or" query

2017-09-25 Thread venkata subbarayudu
Hi Noam, You can evaluate below approach - Create a temp-table with your target-schema for the result-set - Have indexes created for all your OR clause queries - Fire one-query at a time (with one OR clause) and dump data to target-temp table (here, all later queries updates