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. >
