https://community.databricks.com/t5/data-engineering/does-databricks-get-cached-result-for-a-subquery/m-p/35890#M25985 <P><SPAN>If I run a query as "</SPAN><EM>SELECT fare_amount FROM nyctaxi.trips where fare_amount &gt; 1.5"</EM><SPAN>.&nbsp; The query results will be cached for 24 hours.</SPAN></P><P><SPAN>I then c</SPAN><SPAN>ompose a second query using the previous query as a subquery <EM>"</EM></SPAN><EM>SELECT * FROM nyctaxi.trips WHERE fare_amount IN (SELECT fare_amount FROM nyctaxi.trips where fare_amount &gt; 1.5)"</EM></P><P>Will Databricks get the cached result for the subquery to speed up the second query execution?</P><P>Note that the ask is not to cache subquery result. Rather, to get the cached result for the subquery when the subquery was run independently before</P> Wed, 28 Jun 2023 21:27:46 GMT whleeman 2023-06-28T21:27:46Z https://community.databricks.com/t5/data-engineering/does-databricks-get-cached-result-for-a-subquery/m-p/35890#M25985 <P><SPAN>If I run a query as "</SPAN><EM>SELECT fare_amount FROM nyctaxi.trips where fare_amount &gt; 1.5"</EM><SPAN>.&nbsp; The query results will be cached for 24 hours.</SPAN></P><P><SPAN>I then c</SPAN><SPAN>ompose a second query using the previous query as a subquery <EM>"</EM></SPAN><EM>SELECT * FROM nyctaxi.trips WHERE fare_amount IN (SELECT fare_amount FROM nyctaxi.trips where fare_amount &gt; 1.5)"</EM></P><P>Will Databricks get the cached result for the subquery to speed up the second query execution?</P><P>Note that the ask is not to cache subquery result. Rather, to get the cached result for the subquery when the subquery was run independently before</P> Wed, 28 Jun 2023 21:27:46 GMT https://community.databricks.com/t5/data-engineering/does-databricks-get-cached-result-for-a-subquery/m-p/35890#M25985 whleeman 2023-06-28T21:27:46Z