phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xuxc1120" <xuxc1...@vip.qq.com>
Subject Re: RE: RE: how to use index for this query situation?
Date Thu, 30 Oct 2014 09:54:05 GMT
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 index on cols,
5 load another group data to Hbase by spoon;
6 i can't get the new data in step 5; 
whether only use phoenix client to insert data can be got ?




------------------ Original ------------------
From:  "rajeshbabu chintaguntla";<rajeshbabu.chintaguntla@huawei.com>;
Date:  Thu, Oct 30, 2014 05:05 PM
To:  "user@phoenix.apache.org"<user@phoenix.apache.org>; 

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



  Currently Phoenix doesn't have support of index merge or kind of that. 
 I think you have created separate index on each column and your query has where clause with
conditions on multiple columns.
 if we take any index which will not have all the columns in the where clause. That's why
no index is used and going through full table scan.
 
 
 In such cases it's better to create multi-column index with the columns in where condition
so that it will be used when you query.
 
 
 Thanks.
 Rajeshbabu.
 
   
 
 
This e-mail and its attachments contain confidential information from HUAWEI, which 
 is intended only for the person or entity whose address is listed above. Any use of the 
 information contained herein in any way (including, but not limited to, total or partial

 disclosure, reproduction, or dissemination) by persons other than the intended 
 recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender
by 
 phone or email immediately and delete it!
 
 
  
 From: xuxc1120 [xuxc1120@vip.qq.com]
 Sent: Thursday, October 30, 2014 1:52 PM
 To: user
 Subject: Re: RE: how to use index for this query situation?
 
 
 
  
 
  the where conditions are all have index,e.g (col2=1 and col3=1 .  col1 to coln all have
local indexes),
 when :
 select col2 from table where col2=1 and col3=1, it will full scan the table;‍
  only if one condition after "where" clause, it will scan the index_table;
 
 
 ------------------ Original ------------------
  From:  "rajeshbabu chintaguntla";<rajeshbabu.chintaguntla@huawei.com>;
 Date:  Thu, Oct 30, 2014 04:12 PM
 To:  "user@phoenix.apache.org"<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 you confirm this?
 
 
 Thanks.
 Rajeshbabu.
 
   
 
 
This e-mail and its attachments contain confidential information from HUAWEI, which 
 is intended only for the person or entity whose address is listed above. Any use of the 
 information contained herein in any way (including, but not limited to, total or partial

 disclosure, reproduction, or dissemination) by persons other than the intended 
 recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender
by 
 phone or email immediately and delete it!
 
 
  
 From: xuxc1120 [xuxc1120@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 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.
 xuxc
Mime
View raw message