Hello Daniel, Filters and joins are pushed down i.e. filters on column data. Limit is a special keyword not always supported by a database (different syntaxes for quite many databases) and as such I don’t think the push down rules works for that.
Regards, Magnus > 3 dec 2015 kl. 10:00 skrev Daniel Garcia <daniel.gar...@eurotaxglass.com>: > > Hi, > > I’m trying to obtain just one row from a table stored in MySQL by using the > following query: > > select * from my.schema.table limit 1; > > But I’m not getting just one row but all instead. I mean: apache drill only > shows one line, but it retrieves all of them from the source. > > Looking at the query being executed in MySQL server I can see that the “limit > 1” part is not sent. > Can apache drill filter data in the source rather than extract all rows in > memory and then filter them? > > I’m using: > jdk build 1.7.0_79-b15 > apache drill 1.3 > mysql-connector-java 5.1.37 > windows 10 > > Regards, > > Daniel García > Continuous Improvement Team > > > > Albasanz 12 / 4th Floor / 28037 Madrid > > T +34 917 542 966 > > E daniel.gar...@eurotaxglass.com <mailto:daniel.gar...@eurotaxglass.com> > W www.eurotaxglass.com <http://www.eurotaxglass.com/> > > > > Disclaimer > > The information contained in this communication from the sender is > confidential. It is intended solely for use by the recipient and others > authorized to receive it. If you are not the recipient, you are hereby > notified that any disclosure, copying, distribution or taking action in > relation of the contents of this information is strictly prohibited and may > be unlawful. > > This email has been scanned for viruses and malware, and may have been > automatically archived by Mimecast Ltd, an innovator in Software as a Service > (SaaS) for business. Providing a safer and more useful place for your human > generated data. Specializing in; Security, archiving and compliance. To find > out more Click Here <http://www.mimecast.com/products/>. >