Query performance question

2014-12-11 Thread Perko, Ralph J
Hi, Thanks for all your help thus far with Phoenix. I am trying to understand the best way to construct a query that returns all the fields from a table but still takes advantage of a single field secondary index. I have a table with upwards of 50 fields and do not wish to index them all but

Re: Query performance question

2014-12-12 Thread Maryann Xue
Hi Ralph, Thanks for the question! According to the "explain" result you got, the optimization worked exactly as expected with this query: "DYNAMIC SERVER FILTER BY FILE_ID IN (SS.FILE_ID)" means a skip-scan instead of a full-scan over BULK_TABLE will be executed at runtime based on the values of

Re: Query performance question

2014-12-15 Thread Perko, Ralph J
ailto:user@phoenix.apache.org>> Date: Friday, December 12, 2014 at 8:07 AM To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" mailto:user@phoenix.apache.org>> Subject: Re: Query performance question Hi Ralph, Thanks for the question! According to the "explai

Re: Query performance question

2014-12-15 Thread Maryann Xue
elect file_id, recnum from > BULK_TABLE) as SS on BULK_TABLE.file_id = SS.file_id and BULK_TABLE.recnum > = SS.recnum”? > > The full-scan join fails with a MaxServerCacheSizeExceededException - > server cache set to 1G. > > Custom hbase/phoenix settings are attached. > > Thanks, > Ralph

Re: Query performance question

2014-12-15 Thread Maryann Xue
lect * from BULK_TABLE join (select file_id, recnum from >> BULK_TABLE) as SS on BULK_TABLE.file_id = SS.file_id and BULK_TABLE.recnum >> = SS.recnum”? >> >> The full-scan join fails with a MaxServerCacheSizeExceededException - >> server cache set to 1G. >> >>

Re: Query performance question

2014-12-15 Thread Perko, Ralph J
rg<mailto:user@phoenix.apache.org>" mailto:user@phoenix.apache.org>> Subject: Re: Query performance question Hi Ralph, Thank you very much for the information! Very helpful for your questions. The numbers look reasonable as opposed to the query plan. But the only problem is both fi

Re: Query performance question

2014-12-15 Thread Perko, Ralph J
er@phoenix.apache.org>" mailto:user@phoenix.apache.org>> Subject: Re: Query performance question DDL is attached – thanks! Ralph From: Maryann Xue mailto:maryann@gmail.com>> Reply-To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" mailto:

Re: Query performance question

2014-12-15 Thread Maryann Xue
Perko > Reply-To: "user@phoenix.apache.org" > Date: Monday, December 15, 2014 at 12:37 PM > > To: "user@phoenix.apache.org" > Subject: Re: Query performance question > >DDL is attached – thanks! > > Ralph > > > From: Maryann Xue >

Re: Query performance question

2014-12-18 Thread Perko, Ralph J
5, 2014 at 3:14 PM To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" mailto:user@phoenix.apache.org>> Subject: Re: Query performance question Thanks again for the input, Ralph! Pinpointed the problem and filed a JIRA (https://issues.apache.org/jira/browse/PHOENIX-1533). W

Re: Query performance question

2014-12-18 Thread Maryann Xue
; Reply-To: "user@phoenix.apache.org" > Date: Monday, December 15, 2014 at 3:14 PM > > To: "user@phoenix.apache.org" > Subject: Re: Query performance question > > Thanks again for the input, Ralph! > > Pinpointed the problem and filed a JIRA ( > https:/