Fang-Yu Rao has posted comments on this change. ( http://gerrit.cloudera.org:8080/14894 )
Change subject: IMPALA-9009: Core support for Ranger column masking ...................................................................... Patch Set 12: (1 comment) http://gerrit.cloudera.org:8080/#/c/14894/12/testdata/workloads/functional-query/queries/QueryTest/ranger_column_masking.test File testdata/workloads/functional-query/queries/QueryTest/ranger_column_masking.test: http://gerrit.cloudera.org:8080/#/c/14894/12/testdata/workloads/functional-query/queries/QueryTest/ranger_column_masking.test@240 PS12, Line 240: 0aaaaaa > Moreover, after executing the SQL statements above in an Impala cluster wit After some thoughts, I have another related question. According to the tests provided in this file, it seems that the predicates involved in a join are evaluated on the masked/transformed column values if there exist some corresponding column masking policies. If this is the case, I was wondering whether or not the order of tables in the from clause would affect the results of the join. To be more specific, is it guaranteed that the following two SQL statements produce the same set of result given "any" set of column masking policies and "any" set of source tables? Thanks! Query 1: select a.id, s.bool_col, t.bool_col, s.string_col, t.string_col from functional.alltypes a, functional.alltypestiny t, functional.alltypessmall s where a.id = t.id and t.id = s.id; Query 2: select a.id, s.bool_col, t.bool_col, s.string_col, t.string_col from functional.alltypes a, functional.alltypessmall s, functional.alltypestiny t where a.id = t.id and t.id = s.id; -- To view, visit http://gerrit.cloudera.org:8080/14894 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I4cad60e0e69ea573b7ecfc011b142c46ef52ed61 Gerrit-Change-Number: 14894 Gerrit-PatchSet: 12 Gerrit-Owner: Quanlong Huang <[email protected]> Gerrit-Reviewer: Csaba Ringhofer <[email protected]> Gerrit-Reviewer: Fang-Yu Rao <[email protected]> Gerrit-Reviewer: Impala Public Jenkins <[email protected]> Gerrit-Reviewer: Kurt Deschler <[email protected]> Gerrit-Reviewer: Quanlong Huang <[email protected]> Gerrit-Reviewer: Vihang Karajgaonkar <[email protected]> Gerrit-Comment-Date: Mon, 06 Jan 2020 23:40:24 +0000 Gerrit-HasComments: Yes
