well. Global index shall need you to include all your query condition columns
to facilitate index usage.
e.g. If you create an index on table (col1), then you may only conduct such
queries as select col1 from table where [condition col1]
If you want to include more query results columns, you can create index on
table (col1) include (col2,col3) as instructions here.
CertusNet
发件人： xuxc1120
发送时间： 2014-10-24 09:52
收件人： user
主题： 回复： Re: how to use phoenix index to query data?
i use "create index "name_idx" on table("info".qulifier");
it is a global index.
so ,how to use "name_idx" to speed query?
------------------ 原始邮件 ------------------
发件人: "[email protected]";<[email protected]>;
发送时间: 2014年10月24日(星期五) 上午9:00
收件人: "user"<[email protected]>;
主题: 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 <[email protected]> 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?
