Thanks in advance for any help.xuxc ------------------ 原始邮件 ------------------ 发件人: "James Taylor";<[email protected]>; 发送时间: 2014年10月24日(星期五) 上午10:01 收件人: "user"<[email protected]>;
主题: 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 <[email protected]> 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? > > ------------------ 原始邮件 ------------------ > 发件人: "[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? >> >
