You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by ni...@accenture.com on 2016/04/29 08:00:16 UTC
Issue with IN Clause while reading data
Hi,
We are facing an issue using Apache Drill and need guidance on how to solve this. In the attached mail is the Parquet file & the query which we are trying to run.
Problem
When we have too many values in the "IN" clause, we do not get a result back. Once we reduce the number of values in the "IN" clause, the results are visible.
Help in this regard will be Appreciated.
Thanks,
Nitin Sareen, Technology Architect
[cid:078C4944-71CA-4756-8379-1667D9B81140]
1st Floor, Building No 8, DLF Cyber City,
DLF Phase 3, Sector 24, Gurgaon, Haryana 122002
+91-9999381384
________________________________
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
______________________________________________________________________________________
www.accenture.com
Re: Issue with IN Clause while reading data
Posted by Julian Hyde <jh...@apache.org>.
Attachments don’t come through the apache email system too well. Probably best that you log a JIRA case, and attach any files needed for a test case. Of course the more minimal the test case, the better.
Julian
> On Apr 28, 2016, at 11:00 PM, nitin.a.sareen@accenture.com wrote:
>
> Hi,
>
> We are facing an issue using Apache Drill and need guidance on how to solve this. In the attached mail is the Parquet file & the query which we are trying to run.
>
> Problem
> When we have too many values in the “IN” clause, we do not get a result back. Once we reduce the number of values in the “IN” clause, the results are visible.
>
> Help in this regard will be Appreciated.
>
> Thanks,
> Nitin Sareen, Technology Architect
> <8EC8D0B1-B4DC-41B1-BF5F-DA3785C2216E.png>
> 1st Floor, Building No 8, DLF Cyber City,
> DLF Phase 3, Sector 24, Gurgaon, Haryana 122002
> +91-9999381384
>
>
>
> This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
> ______________________________________________________________________________________
>
> www.accenture.com
> <Mail Attachment.eml>