[PHOENIX-2051] Link record is in the format CHILD-PARENT for phoenix views and it has to scan the entire table to find the parent suffix.

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.3.1
• Fix Version/s: 4.11.0
• Assignee: Thomas D'Silva
• Reporter: Arun Kumaran Sabtharishi
• Created: 18/Jun/15 03:22
• Updated: 25/Sep/17 17:20
• Resolved: 15/Mar/17 02:17

Description

When a phoenix view is dropped, it runs a scan on the SYSTEM.CATALOG table looking for the link record. Since the link record is in the format CHILD-PARENT, it has to scan the entire table to find the parent suffix. For the long term solution, we can write two link records, the existing CHILD-PARENT and a new PARENT-CHILD so that the findChildViews() method can use a key range scan.

Issue Links

• breaks: PHOENIX-3870 Backward compatibility fails between v4.9.0 and head of 4.x (4.11-SNAPSHOT)
• breaks: PHOENIX-4229 Parent-Child linking rows in System.Catalog break tenant view replication