Maximum sql string length

[Jon Strayer]

We’ve been querying one table and then creating a query against another table 
using a prepared statement with a very large number of parameters in a IN 
clause.  A code review brought up a very good question, is there a limit to the 
size of the IN clause?  Or, is there a limit to the size of the SQL use to 
create a prepared statement.

I assume there is some limit, but is it “well, how much memory do you have?” 
Or, “we have a 64k buffer”?

Re: Phoenix Index Scrutiny Tool

[Alexander Batyrshin]

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

Phoenix Index Scrutiny Tool

[Aleksandr Saraseka]

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