phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Batyrshin <0x62...@gmail.com>
Subject Re: Phoenix Index Scrutiny Tool
Date Fri, 09 Aug 2019 21:18:31 GMT
I have familiar question - how to partially rebuild indexes by timestamps interval like many
MapReduce has —starttime/—endttime

> On 9 Aug 2019, at 17:21, Aleksandr Saraseka <asaraseka@eztexting.com> wrote:
> 
> Hello community!
> I'm testing scrutiny tool to check index consistency.
> I hard-deleted from HBase a couple of rows from global index, then ran Scrutiny tool,
it showed me some output like:
> 
> 
> SOURCE_TABLE
> TARGET_TABLE
> SCRUNITY_EXECUTE_TIME
> SOURCE_ROW_PK_HASH
> SOURCE_TS
> TARGET_TS
> HAS_TARGET_ROW
> INDEX_TABLE
> DATA_TABLE
> 1565358267566
> 8a74d1f8286a7ec7ce99b22ee0723ab1
> 1565358171998
> -1
> false
> INDEX_TABLE
> DATA_TABLE
> 1565358267566
> a2cfe11952f3701d340069f80e2a82b7
> 1565358135292
> -1
> false
> so, let's imagine that I want to repair my index and don't want to run full rebuild (huge
table).
> What's the best option ?
> Two things came to my mind:
> - Find a row in data table, and upset necessary data to index table.
> - Find a row in data table,  export it then drop it, and then insert it again.
> And the main question - how can I get a value from data or index table by Primary Key
hash ?
> 
> -- 
>  		Aleksandr Saraseka
> DBA
> 380997600401
>  <tel:380997600401> •  asaraseka@eztexting.com <mailto:asaraseka@eztexting.com>
 •  eztexting.com <http://eztexting.com/?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
 
>  <http://facebook.com/eztexting?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
 <http://linkedin.com/company/eztexting/?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
 <http://twitter.com/eztexting?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
 <https://www.youtube.com/eztexting?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
 <https://www.instagram.com/ez_texting/?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
 <https://www.facebook.com/alex.saraseka?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>
 <https://www.linkedin.com/in/alexander-saraseka-32616076/?utm_source=WiseStamp&utm_medium=email&utm_term=&utm_content=&utm_campaign=signature>


Mime
View raw message