phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eli Levine <elilev...@gmail.com>
Subject Re: how to use phoenix index to query data?
Date Thu, 23 Oct 2014 15:04:09 GMT
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