Spark SQL UDF returning a list?

[Jerry Raj]

Hi,
Can a UDF return a list of values that can be used in a WHERE clause? 
Something like:

    sqlCtx.registerFunction("myudf", {
      Array(1, 2, 3)
    })

    val sql = "select doc_id, doc_value from doc_table where doc_id in 
myudf()"

This does not work:

Exception in thread "main" java.lang.RuntimeException: [1.57] failure: 
``('' expected but identifier myudf found

I also tried returning a List of Ints, that did not work either. Is 
there a way to write a UDF that returns a list?

Thanks
-Jerry

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
For additional commands, e-mail: user-h...@spark.apache.org