The EXPLAIN command should help.
http://phoenix.apache.org/language/index.html#explain
On Thu, Oct 23, 2014 at 5:40 AM xuxc1120 xuxc1...@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
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
Now the problem is:
I select * from table where [condition col1, condition col2, condition
col3]], (maybe that table have 10 cols),
i create index on every col,such as create index col1_idx on table(col1);
create index col2_idx on table(col2); ... create index col10_idx on
table(col10);
It's used automatically. Please read
http://phoenix.apache.org/secondary_indexing.html
On Thu, Oct 23, 2014 at 6:52 PM, xuxc1120 xuxc1...@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?
--
Fine. If you conduct a select * query, maybe you need to create an index
including all your cols, cause
a global index will only be used if all columns referenced in the query are
contained by it. Maybe you can
try local index. Please read the instructions from the site carefully.
Thanks in advance for any help.xuxc
-- 原始邮件 --
发件人: James Taylor;jamestay...@apache.org;
发送时间: 2014年10月24日(星期五) 上午10:01
收件人: useruser@phoenix.apache.org;
主题: Re: Re: how to use phoenix index to query data?
It's used automatically. Please read
the hindex is excellent for local index ,if i bulid hindex(hased on
hbase-0.94.8),and hadoop-1.0.4,and use phoenix-2.2.1,does it works well?
for a SQL query in phoenix client ,can phoenix convert to Hbase scan and then
call hindex's coprocessor to query data?
if it is able to do so ,how to do
Yes, local indexes are supported. Please read
http://phoenix.apache.org/secondary_indexing.html
On Thursday, October 23, 2014, xuxc1120 xuxc1...@vip.qq.com wrote:
the hindex is excellent for local index ,if i bulid hindex(hased on
hbase-0.94.8),and hadoop-1.0.4,and use phoenix-2.2.1,does it
i have read the page, local indexes are only Available in 4.1 release,
but the 4.1 doesn't works with hbase-0.94.8,so i use 2.2.1 instead ,
can phoenix-2.2.1 convert SQL to Hbase scan and then call hindex's coprocessor
to query data?
thank u!
xuxc
-- 原始邮件
Local indexes are only supported for HBase 0.98.1 or above with
Phoenix 4.1 or above.
Thanks,
James
On Thu, Oct 23, 2014 at 8:12 PM, xuxc1120 xuxc1...@vip.qq.com wrote:
i have read the page, local indexes are only Available in 4.1 release,
but the 4.1 doesn't works with hbase-0.94.8,so i
10 matches
Mail list logo