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 *•* asaras...@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>