[ https://issues.apache.org/jira/browse/HIVE-20923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16688553#comment-16688553 ]
Jesus Camacho Rodriguez commented on HIVE-20923: ------------------------------------------------ [~klcopp], this does not seem to be a bug, as behavior conforms with the masking policies defined for the test: https://github.com/apache/hive/blob/6340a81f487c407f63cf2a00e39b2f905328d74e/itests/util/src/main/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/SQLStdHiveAuthorizationValidatorForTest.java#L146 Explain plan should shed more light into what is going on underneath. > 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)