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 [image002] Albasanz 12 / 4th Floor / 28037 Madrid T +34 917 542 966 E [email protected]<mailto:[email protected]> 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 visit the Mimecast website.
