Implement "LIKE" in SparkSQL

[liam]

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.