Maximum sql string length

2019-08-09 Thread 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

Re: Phoenix Index Scrutiny Tool

2019-08-09 Thread 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

Phoenix Index Scrutiny Tool

2019-08-09 Thread 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