phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aleksandr Saraseka <asaras...@eztexting.com>
Subject Phoenix Index Scrutiny Tool
Date Fri, 09 Aug 2019 14:21:26 GMT
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
 *•*  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