compiler: potential issue with ScanOptimizer::getNumActivePartitions

[Ravisha Neelakanthappa]

The function ScanOptimizer::getNumActivePartitions() is supposed to return how many partitions are going to accessed at runtime.
This involves analyzing search key predicates and table partitions type (range or hash) so on. For example if the predicate is on key col like primary_key = <some existing col value>, this function should returns 1 active partition.

Fixing this function to return correct number of partitions is important for Trafodion because we deal with range partitions in HBase.

[Ravisha Neelakanthappa (ravisha-neelakanthappa)]

Two cases to consider in this bug:
A. Table is pre-partitioned using SALT by clause.
This has been fixed, compiler properly estimates active partitions and Rc (Repeat Count) for HashPartition Table.

B. Table gets split by Hbase after reaching configured filesize limit
I am currently working on this problem.