[jira] [Commented] (SPARK-41191) Cache Table is not working while nested caches exist

["Apache Spark (Jira)" <ji...@apache.org>]

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

Apache Spark commented on SPARK-41191:
--------------------------------------

User 'mcdull-zhang' has created a pull request for this issue:
https://github.com/apache/spark/pull/38703

> Cache Table is not working while nested caches exist
> ----------------------------------------------------
>
>                 Key: SPARK-41191
>                 URL: https://issues.apache.org/jira/browse/SPARK-41191
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.3.1
>            Reporter: mcdull_zhang
>            Priority: Minor
>
> For example the following statement:
> {code:java}
> //代码占位符
> cache table t1 as select a from testData3 group by a;
> cache table t2 as select a,b from testData2 where a in (select a from t1);
> select key,value,b from testData t3 join t2 on t3.key=t2.a;{code}
> The cached t2 is not used in the third statement



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org