[PHOENIX-6155] Prevent doing direct upserts into SYSTEM.TASK from the client

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0.0, 4.15.0
• Fix Version/s: 5.1.0, 4.16.0
• Release Note: A new coprocessor endpoint to avoid direct upserts into SYSTEM.TASK from the client.
• Assignee: Viraj Jasani
• Reporter: Chinmay Kulkarni
• Created: 22/Sep/20 17:45
• Updated: 13/Jan/21 17:06
• Resolved: 23/Nov/20 18:51

Description

In environments with namespace-mapping enabled, we will have to grant write access to clients in order to make direct upserts into SYSTEM.TASK. Currently we add a task from the client-side here. In order to implement other Jiras like PHOENIX-6154 we also may need to interact with the SYSTEM.TASK table from the client-side.

Instead of doing direct upserts into this table, we should add an endpoint on SYSTEM.TASK and clients should interact with that.

Issue Links

• is depended upon by: PHOENIX-6154 Move the check for existence of child views and task addition to drop those child views to the client side when dropping a table/view
• links to: GitHub Pull Request #960