[ 
https://issues.apache.org/jira/browse/HIVE-17566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16194157#comment-16194157
 ] 

Harish Jaiprakash commented on HIVE-17566:
------------------------------------------

Thanks [~sershe]. I'll make parent_pool_id nullable, its nullable in the 
schema. Made a mistake in package.jdo.

Thanks [~prasanth_j].
* Yes path is to store hierarchical paths. This is because its easier to query 
with that. I can remove parent_pool_id, since we can query for all children 
using prefix match.
* MAPPINGS are rules too for a resource_plan. I thought the name trigger was 
more appropriated to describe what this table holds. I can call it trigger_rule 
if that is alright.
* All objects are under a resource plan, hence the rp_id in every table. The 
relationship b/w rules and pool are many-to-many. There is a different table, 
WM_POOL_TO_TRIGGER, to manage that.

> Create schema required for workload management.
> -----------------------------------------------
>
>                 Key: HIVE-17566
>                 URL: https://issues.apache.org/jira/browse/HIVE-17566
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Harish Jaiprakash
>            Assignee: Harish Jaiprakash
>         Attachments: HIVE-17566.01.patch, HIVE-17566.02.patch, 
> HIVE-17566.03.patch, HIVE-17566.04.patch, HIVE-17566.05.patch, 
> HIVE-17566.06.patch
>
>
> Schema + model changes required for workload management.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to