[TASK][EASY] Authz will still check source table when persist view contains a subquery

[AngersZhuuuu]

Code of Conduct

• I agree to follow this project's Code of Conduct

Search before asking

• I have searched in the issues and found no similar issues.

Describe the bug

          sql(s"CREATE TABLE $db.$v1 AS SELECT * FROM $view")
          sql(s"CREATE TABLE $db.$v2 AS SELECT * FROM $view")
          sql(
            s"""
               |CREATE VIEW $db.$my_view
               |AS
               |WITH temp AS (
               |    SELECT max(grade) max_grade
               |    FROM $db.$v2)
               |SELECT id as new_id FROM $db.$v1
               |WHERE grade = (SELECT max_grade FROM temp)
               |""".stripMargin)
          sql(
            s"SELECT * FROM $db.$my_view".stripMargin).explain(true)

For such a case, if the view have a subquery, spark will first execute subquery then it may still check the internal table of persist view.

== Analyzed Logical Plan ==
new_id: int
Project [new_id#54]
+- SubqueryAlias spark_catalog.test_default.my_view
   +- PermanentViewMarker `test_default`.`my_view`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
      +- View (`test_default`.`my_view`, [new_id#54])
         +- Project [cast(new_id#51 as int) AS new_id#54]
            +- WithCTE
               :- CTERelationDef 1
               :  +- SubqueryAlias temp
               :     +- Aggregate [max(grade#57) AS max_grade#53]
               :        +- SubqueryAlias spark_catalog.test_default.v2
               :           +- HiveTableRelation [`test_default`.`v2`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [id#55, name#56, grade#57, sex#58], Partition Cols: []]
               +- Project [id#59 AS new_id#51]
                  +- Filter (grade#61 = scalar-subquery#52 [])
                     :  +- Project [max_grade#53]
                     :     +- SubqueryAlias temp
                     :        +- CTERelationRef 1, true, [max_grade#53]
                     +- SubqueryAlias spark_catalog.test_default.v1
                        +- HiveTableRelation [`test_default`.`v1`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [id#59, name#60, grade#61, sex#62], Partition Cols: []]

Affects Version(s)

master, 1.8.0

Kyuubi Server Log Output

No response

Kyuubi Engine Log Output

No response

Kyuubi Server Configurations

No response

Kyuubi Engine Configurations

No response

Additional context

No response

Are you willing to submit PR?

• Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix.
• No. I cannot submit a PR at this time.