concat and locate are available as of version 1.5.0, according to the Scaladocs. For earlier versions of Spark, and for the operations that are still not supported, it's pretty straightforward to define your own UserDefinedFunctions in either Scala or Java (I don't know about other languages). On Sep 11, 2015 10:26 PM, "liam" <liaml...@gmail.com> wrote:
> Hi, > > Imaging this: the value of one column is the substring of another > column, when using Oracle,I got many ways to do the query like the > following statement,but how to do in SparkSQL since this no "concat(), > instr(), locate()..." > > > select * from table t where t.a like '%'||t.b||'%'; > > > Thanks. > >