With larger value for such option, a big IN-list may not be converted into a subquery. As such, the query performance might be suboptimal.
On Fri, Oct 7, 2016 at 6:54 PM, Gautam Parai <[email protected]> wrote: > Yes, this was fixed in Drill 1.8 - please let us know if this does not work > in 1.8. As Jinfeng mentioned earlier, the option can be set to a very large > value (LONG type). > > Gautam > > On Fri, Oct 7, 2016 at 2:29 AM, Tushar Pathare <[email protected]> wrote: > >> Hello, >> >> I think it is fixed in 1.8 .try it on >> >> Get Outlook for iOS<https://aka.ms/o0ukef> >> >> >> >> >> On Fri, Oct 7, 2016 at 12:18 PM +0300, "Nicolas Paris" < >> [email protected]<mailto:[email protected]>> wrote: >> >> Hi, >> >> I am in 1.6 Drill version with mapr distribution 5.1. >> I get this error : >> Error: VALIDATION ERROR: The option 'planner.in_subquery_threshold' does >> not exist >> >> >> Le lun. 3 oct. 2016 à 17:18, Jinfeng Ni <[email protected]> a écrit : >> >> > You can modify option `planner.in_subquery_threshold`. By default, >> > it's set to be 20. That's the threshold when planner decides to >> > convert IN-list to a subquery. >> > >> > select * from sys.options where name like '%in_subquery%'; >> > >> > +--------------------------------+-------+---------+-------- >> --+----------+-------------+-----------+------------+ >> > | name | kind | type | status | >> > num_val | string_val | bool_val | float_val | >> > >> > +--------------------------------+-------+---------+-------- >> --+----------+-------------+-----------+------------+ >> > | planner.in_subquery_threshold | LONG | SYSTEM | DEFAULT | 20 >> > | null | null | null | >> > >> > +--------------------------------+-------+---------+-------- >> --+----------+-------------+-----------+------------+ >> > >> > On Sun, Oct 2, 2016 at 12:56 AM, Tushar Pathare <[email protected]> >> > wrote: >> > > Hello Team, >> > > >> > > A select clause with IN operator creates a issue if the count of goes >> > beyond 19 for params.Is this a tunable or this is a drawback. >> > > If the number of params is made less that 19 the same select statement >> > works >> > > >> > > Select something…… >> > > >> > > IN ( '94479 ', '296979 ', '219579 ', '109179 ', '97179 ', '223179 ', >> > '96279 ', '224979 ', '282879 ', '33279 ', '277179 ', '177879 ', '272049 >> ', >> > '49179 ', '104049 ','177879 ', '272049 ', '49179 ', '104049 ', '104049 ') >> > > >> > > Error thrown >> > > org.apache.drill.common.exceptions.UserRemoteException: DATA_READ >> ERROR: >> > The JDBC storage plugin failed while trying setup the SQL query >> > > >> > > >> > > >> > > >> > > Tushar B Pathare >> > > High Performance Computing (HPC) Administrator >> > > General Parallel File System >> > > Scientific Computing >> > > Bioinformatics Division >> > > Research >> > > >> > > Sidra Medical and Research Centre >> > > Sidra OPC Building >> > > PO Box 26999 | Doha, Qatar >> > > Near QNCC,5th Floor >> > > Office 4003 3333 ext 37443 | M +974 74793547 <+974%207479%203547> >> > > [email protected] | www.sidra.org<http://www.sidra.org> < >> http://www.sidra.org/> >> > > >> > > >> > > >> > > >> > > >> > > >> > > Disclaimer: This email and its attachments may be confidential and are >> > intended solely for the use of the individual to whom it is addressed. If >> > you are not the intended recipient, any reading, printing, storage, >> > disclosure, copying or any other action taken in respect of this e-mail >> is >> > prohibited and may be unlawful. If you are not the intended recipient, >> > please notify the sender immediately by using the reply function and then >> > permanently delete what you have received. Any views or opinions >> expressed >> > are solely those of the author and do not necessarily represent those of >> > Sidra Medical and Research Center. >> > >> Disclaimer: This email and its attachments may be confidential and are >> intended solely for the use of the individual to whom it is addressed. If >> you are not the intended recipient, any reading, printing, storage, >> disclosure, copying or any other action taken in respect of this e-mail is >> prohibited and may be unlawful. If you are not the intended recipient, >> please notify the sender immediately by using the reply function and then >> permanently delete what you have received. Any views or opinions expressed >> are solely those of the author and do not necessarily represent those of >> Sidra Medical and Research Center. >>
