https://community.databricks.com/t5/get-started-discussions/spark-sql-query-won-t-allow-limiter/m-p/36262#M290 <P>When I try to run a simple limit number of rows in Spark using a pushdown query,&nbsp; I receive an error back from spark with a where clause of 1= 0.&nbsp; Meaning it won't return the results and the original sql query was appended by spark.</P><P>This seems very odd that spark won't allow a "SELECT TOP 100 * From Table" or "SELECT * FROM Table Limit 100"&nbsp; both of these queries return nothing.&nbsp; It appears spark wants me to bring in the 10 M records then limit them in the data frame.&nbsp; This is crazy and very taxing on the DB.&nbsp;</P><P>&nbsp;</P> Thu, 29 Jun 2023 18:54:49 GMT jcastelo 2023-06-29T18:54:49Z https://community.databricks.com/t5/get-started-discussions/spark-sql-query-won-t-allow-limiter/m-p/36262#M290 <P>When I try to run a simple limit number of rows in Spark using a pushdown query,&nbsp; I receive an error back from spark with a where clause of 1= 0.&nbsp; Meaning it won't return the results and the original sql query was appended by spark.</P><P>This seems very odd that spark won't allow a "SELECT TOP 100 * From Table" or "SELECT * FROM Table Limit 100"&nbsp; both of these queries return nothing.&nbsp; It appears spark wants me to bring in the 10 M records then limit them in the data frame.&nbsp; This is crazy and very taxing on the DB.&nbsp;</P><P>&nbsp;</P> Thu, 29 Jun 2023 18:54:49 GMT https://community.databricks.com/t5/get-started-discussions/spark-sql-query-won-t-allow-limiter/m-p/36262#M290 jcastelo 2023-06-29T18:54:49Z