ok, but what if I have a long list do I need to hard code like this every element of my list of is there a function that translate a list into a tuple ?
On Fri, Aug 29, 2014 at 3:24 AM, Michael Armbrust <mich...@databricks.com> wrote: > You don't need the Seq, as in is a variadic function. > > personTable.where('name in ("foo", "bar")) > > > > On Thu, Aug 28, 2014 at 3:09 AM, Jaonary Rabarisoa <jaon...@gmail.com> > wrote: > >> Hi all, >> >> What is the expression that I should use with spark sql DSL if I need to >> retreive >> data with a field in a given set. >> For example : >> >> I have the following schema >> >> case class Person(name: String, age: Int) >> >> And I need to do something like : >> >> personTable.where('name in Seq("foo", "bar")) ? >> >> >> Cheers. >> >> >> Jaonary >> > >