phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xuxc1120" <xuxc1...@vip.qq.com>
Subject 回复: Re: how to use phoenix index to query data?
Date Fri, 24 Oct 2014 02:49:16 GMT
Thanks in advance for any help.xuxc 
------------------ 原始邮件 ------------------
发件人: "James Taylor";<jamestaylor@apache.org>;
发送时间: 2014年10月24日(星期五) 上午10:01
收件人: "user"<user@phoenix.apache.org>; 

主题: Re: Re: how to use phoenix index to query data?



It's used automatically. Please read
http://phoenix.apache.org/secondary_indexing.html

On Thu, Oct 23, 2014 at 6:52 PM, xuxc1120 <xuxc1120@vip.qq.com> wrote:
> i use "create index "name_idx" on table("info".qulifier");
> it is a global index.‍
> so ,how to use "name_idx" to speed query?‍
>
> ------------------ 原始邮件 ------------------
> 发件人: "sunfl@certusnet.com.cn";<sunfl@certusnet.com.cn>;
> 发送时间: 2014年10月24日(星期五) 上午9:00
> 收件人: "user"<user@phoenix.apache.org>;
> 主题: Re: Re: how to use phoenix index to query data?
>
> You may need to confirm what kind of your index type. global index or local
> index, cause they differ a lot in usage.
> Explain command shall tell you whether index table works.
>
> ________________________________
> ________________________________
>
> CertusNet
>
>
>
> From: Eli Levine
> Date: 2014-10-23 23:04
> To: user
> Subject: Re: how to use phoenix index to query data?
> The EXPLAIN command should help.
> http://phoenix.apache.org/language/index.html#explain
> On Thu, Oct 23, 2014 at 5:40 AM xuxc1120 <xuxc1120@vip.qq.com> wrote:
>>
>> environment:
>> hadoop-2.3.0-cdh-5.1.0
>> hbase-0.98.1-cdh-5.1.0
>> phoenix-4.1.0‍
>>
>> i have create a table in phoenix client ,and then create index on some
>> columns, after that ,i insert data to table,
>> the data have inserted successful and the index table also have records,
>>
>> but when i use "select * from tb1 where condition=1 and condition2=2"
>> clause in the phoenix client , for 180W data, it takes almost 10sec, i want
>> to know if the index works?
>>
>
Mime
View raw message