[jira] [Commented] (HIVE-12865) Exchange partition does not show inputs field for post/pre execute hooks

["Aihua Xu (JIRA)" <ji...@apache.org>]

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

Aihua Xu commented on HIVE-12865:
---------------------------------

Attached the initial patch: added the source table and the partitions to be exchanged as the inputs.

[~ctang.ma] and [~xuefuz] Can you help review the code? 

[~pauly] Could you also take a look if this is what you are expecting?

> Exchange partition does not show inputs field for post/pre execute hooks
> ------------------------------------------------------------------------
>
>                 Key: HIVE-12865
>                 URL: https://issues.apache.org/jira/browse/HIVE-12865
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.12.0
>            Reporter: Paul Yang
>            Assignee: Aihua Xu
>         Attachments: HIVE-12865.patch
>
>
> The pre/post execute hook interface has fields that indicate which Hive objects were read / written to as a result of running the query. For the exchange partition operation, the read entity field is empty.
> This is an important issue as the hook interface may be configured to perform critical warehouse operations.
> See
> ql/src/test/results/clientpositive/exchange_partition3.q.out
> {code}
> --- a/ql/src/test/results/clientpositive/exchange_partition3.q.out
> +++ b/ql/src/test/results/clientpositive/exchange_partition3.q.out
> @@ -65,9 +65,17 @@ ds=2013-04-05/hr=2
>  PREHOOK: query: -- This will exchange both partitions hr=1 and hr=2
>  ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2
>  PREHOOK: type: ALTERTABLE_EXCHANGEPARTITION
> +PREHOOK: Output: default@exchange_part_test1
> +PREHOOK: Output: default@exchange_part_test2
>  POSTHOOK: query: -- This will exchange both partitions hr=1 and hr=2
>  ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2
>  POSTHOOK: type: ALTERTABLE_EXCHANGEPARTITION
> +POSTHOOK: Output: default@exchange_part_test1
> +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=1
> +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=2
> +POSTHOOK: Output: default@exchange_part_test2
> +POSTHOOK: Output: default@exchange_part_test2@ds=2013-04-05/hr=1
> +POSTHOOK: Output: default@exchange_part_test2@ds=2013-04-05/hr=2
>  PREHOOK: query: SHOW PARTITIONS exchange_part_test1
>  PREHOOK: type: SHOWPARTITIONS
>  PREHOOK: Input: default@exchange_part_test1
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)