[jira] [Commented] (HIVE-20923) masking_12 qtest expects wrong inputs

["Karen Coppage (JIRA)" <ji...@apache.org>]

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

Karen Coppage commented on HIVE-20923:
--------------------------------------

[~daijy] since you exposed this problem, and [~jcamachorodriguez] since you created the test, and [~ychena]: Can you tell me if I am incorrect, and if not then any insights into what the issue might be? Thanks.

> masking_12 qtest expects wrong inputs
> -------------------------------------
>
>                 Key: HIVE-20923
>                 URL: https://issues.apache.org/jira/browse/HIVE-20923
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Planning, Test, Tests, Views
>            Reporter: Karen Coppage
>            Priority: Major
>
> It appears this qtest expects the wrong behavior, and should fail but doesn't.
> Below Queries 3 and 4 should not include default@src as Input 
> Query 1
> {noformat}
> PREHOOK: query: create table `masking_test_subq_n1` as select cast(key as int) as key, value from src
> PREHOOK: type: CREATETABLE_AS_SELECT
> PREHOOK: Input: default@src
> PREHOOK: Output: database:default
> PREHOOK: Output: default@masking_test_subq_n1
> POSTHOOK: query: create table `masking_test_subq_n1` as select cast(key as int) as key, value from src
> POSTHOOK: type: CREATETABLE_AS_SELECT
> POSTHOOK: Input: default@src
> POSTHOOK: Output: database:default
> POSTHOOK: Output: default@masking_test_subq_n1
> POSTHOOK: Lineage: masking_test_subq_n1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
> POSTHOOK: Lineage: masking_test_subq_n1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]{noformat}
> Query 2
> {noformat}
> PREHOOK: query: create view `v1_n9` as select * from `masking_test_subq_n1`
> PREHOOK: type: CREATEVIEW
> PREHOOK: Input: default@masking_test_subq_n1
> PREHOOK: Output: database:default
> PREHOOK: Output: default@v1_n9
> POSTHOOK: query: create view `v1_n9` as select * from `masking_test_subq_n1`
> POSTHOOK: type: CREATEVIEW
> POSTHOOK: Input: default@masking_test_subq_n1
> POSTHOOK: Output: database:default
> POSTHOOK: Output: default@v1_n9
> POSTHOOK: Lineage: v1_n9.key SIMPLE [(masking_test_subq_n1)masking_test_subq_n1.FieldSchema(name:key, type:int, comment:null), ]
> POSTHOOK: Lineage: v1_n9.value SIMPLE [(masking_test_subq_n1)masking_test_subq_n1.FieldSchema(name:value, type:string, comment:null), ]
> {noformat}
> Query 3 (the explain output here describes a TableScan on table src)
> {noformat}
> PREHOOK: query: explain
> select * from `v1_n9`
> limit 20
> PREHOOK: type: QUERY
> PREHOOK: Input: default@masking_test_subq_n1
> PREHOOK: Input: default@src
> PREHOOK: Input: default@v1_n9
> #### A masked pattern was here ####
> POSTHOOK: query: explain
> select * from `v1_n9`
> limit 20
> POSTHOOK: type: QUERY
> POSTHOOK: Input: default@masking_test_subq_n1
> POSTHOOK: Input: default@src
> POSTHOOK: Input: default@v1_n9
> {noformat}
> Query 4
> {noformat}
> PREHOOK: query: select * from `v1_n9`
> limit 20
> PREHOOK: type: QUERY
> PREHOOK: Input: default@masking_test_subq_n1
> PREHOOK: Input: default@src
> PREHOOK: Input: default@v1_n9
> #### A masked pattern was here ####
> POSTHOOK: query: select * from `v1_n9`
> limit 20
> POSTHOOK: type: QUERY
> POSTHOOK: Input: default@masking_test_subq_n1
> POSTHOOK: Input: default@src
> POSTHOOK: Input: default@v1_n9
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)