1.0.2
On Friday, August 29, 2014, Michael Armbrust <mich...@databricks.com> wrote: > What version are you using? > > > > On Fri, Aug 29, 2014 at 2:22 AM, Jaonary Rabarisoa <jaon...@gmail.com > <javascript:_e(%7B%7D,'cvml','jaon...@gmail.com');>> wrote: > >> Still not working for me. I got a compilation error : *value in is not a >> member of Symbol.* Any ideas ? >> >> >> On Fri, Aug 29, 2014 at 9:46 AM, Michael Armbrust <mich...@databricks.com >> <javascript:_e(%7B%7D,'cvml','mich...@databricks.com');>> wrote: >> >>> To pass a list to a variadic function you can use the type ascription >>> :_* >>> >>> For example: >>> >>> val longList = Seq[Expression]("a", "b", ...) >>> table("src").where('key in (longList: _*)) >>> >>> Also, note that I had to explicitly specify Expression as the type >>> parameter of Seq to ensure that the compiler converts "a" and "b" into >>> Spark SQL expressions. >>> >>> >>> >>> >>> On Thu, Aug 28, 2014 at 11:52 PM, Jaonary Rabarisoa <jaon...@gmail.com >>> <javascript:_e(%7B%7D,'cvml','jaon...@gmail.com');>> wrote: >>> >>>> 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 >>>> <javascript:_e(%7B%7D,'cvml','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 >>>>> <javascript:_e(%7B%7D,'cvml','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 >>>>>> >>>>> >>>>> >>>> >>> >> >