[
https://issues.apache.org/jira/browse/HIVE-20923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez resolved HIVE-20923.
--------------------------------------------
Resolution: Not A Problem
Closing as not a problem, please reopen if you still believe this is an issue.
> 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)
