spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liam <liaml...@gmail.com>
Subject Implement "LIKE" in SparkSQL
Date Sat, 12 Sep 2015 02:26:18 GMT
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.

Mime
View raw message