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 <asaras...@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> • asaras...@eztexting.com > <mailto: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>