phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>
Subject Re: Re: how to use phoenix index to query data?
Date Fri, 24 Oct 2014 01:00:40 GMT
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