Re: RE: RE: RE: how to use index for this query situation?

2014-10-30 Thread xuxc1120
situation . -- Original -- From: "rajeshbabu chintaguntla";; Date: Thu, Oct 30, 2014 06:06 PM To: "user@phoenix.apache.org"; Subject: RE: RE: RE: how to use index for this query situation? Phoenix client set some special attribute

RE: RE: RE: how to use index for this query situation?

2014-10-30 Thread rajeshbabu chintaguntla
From: xuxc1120 [xuxc1...@vip.qq.com] Sent: Thursday, October 30, 2014 3:24 PM To: user Subject: Re: RE: RE: how to use index for this query situation? another problem is : 1.i create table use phoenix client, 2.load data to Hbase by spoon kettle , 3,i can get data from phoenix client, 4 then i create ind

Re: RE: RE: how to use index for this query situation?

2014-10-30 Thread xuxc1120
data can be got ? -- Original -- From: "rajeshbabu chintaguntla";; Date: Thu, Oct 30, 2014 05:05 PM To: "user@phoenix.apache.org"; Subject: RE: RE: how to use index for this query situation? Currently Phoenix doesn't have sup

RE: RE: how to use index for this query situation?

2014-10-30 Thread rajeshbabu chintaguntla
) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! From: xuxc1120 [xuxc1...@vip.qq.com] Sent: Thursday, October 30, 2014 1:52 PM To: user Subject: Re: RE: how to use index for this query situati

Re: RE: how to use index for this query situation?

2014-10-30 Thread xuxc1120
- Original -- From: "rajeshbabu chintaguntla";; Date: Thu, Oct 30, 2014 04:12 PM To: "user@phoenix.apache.org"; Subject: RE: how to use index for this query situation? If you have where condition on non indexed column then we go for full table scan. Can

RE: how to use index for this query situation?

2014-10-30 Thread rajeshbabu chintaguntla
phone or email immediately and delete it! From: xuxc1120 [xuxc1...@vip.qq.com] Sent: Thursday, October 30, 2014 1:20 PM To: user Subject: how to use index for this query situation? table: each col with local index(col1..coln), when i select data such as : select

how to use index for this query situation?

2014-10-30 Thread xuxc1120
table: each col with local index(col1..coln), when i select data such as : select col1,col2 from table where col1="test", the index works, but if there are 2 or more conditions after "where" clause,the query will full scan the table; is there any way to use index for such query? thanks. xux