mardi 12 juillet 2016

spark sql regular expression

I'm locking with SQL Spark . I have a column whose values ​​can be:

1) -BF1

2) B -F1

3) X

The sign " -" indicates that any character or string of characters can occupy that position.

My problem is that I need to check whether this rule is in another column , for example :

column1 = BCFDF1LDK

This would apply to the condition 1) record that contains " BF1 "

But do not know how to express this in a where condition :

.where((application_rules("apprul_cd_fare_basis").startsWith("-")===true) && ((locations("fardet_cd_fare_basis")XXXXXXXXXXXXXXXXXXXXXX))) 
        ) 

Any ideas?

Aucun commentaire:

Enregistrer un commentaire