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
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
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
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
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.
>>
>>
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
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:
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
>
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
; 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:/
10 matches
Mail list logo