[PHOENIX-1177] Cost-based query optimization

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Assignee: Unassigned
• Reporter: James Taylor
• Created: 18/Aug/14 02:27
• Updated: 18/Nov/15 20:40
• Resolved: 18/Nov/15 20:40

Sub-Tasks

• Gather and maintain stats for HBase tables in a designated HBase table: Resolved
• Use stats to guide query parallelization: Closed
• Perform partial scan for ANALYZE when table salted or local index: Closed
• Only cache guideposts on physical PTable: Closed
• Add StatisticsCollector to existing tables on first connection to cluster: Closed
• Scan entire region when tenant-specific table is analyzed: Closed
• Ensure Phoenix table is created for Local index and view index tables to store guideposts against them: Closed
• Update stats atomically: Closed
• Cleanup setting of timestamps when collecting and using stats: Closed
• Update ANALYZE syntax to collect stats on index tables and all tables: Closed
• Add documentation for UPDATE STATISTICS command: Closed
• Store statistics guideposts as VARBINARY: Closed
• Collect row counts per region in stats table: Closed
• Add unit test for stats not being maintained correctly through splits: Closed
• Estimate byte count more accurately when split occurs: Resolved
• Collect row counts per tenant view: Resolved