hive - Determine if substring corresponds to specific code (character types) in SQL -


i have collection of strings , want filter out last 4 characters are: (alpha)(alpha)(number)(number).

i know can make substring of each of these , separately, method determine types of characters in sequence?

this sql in hive.

you can use regular expressions. like:

where col regexp '[a-za-z]{2}[0-9]{2}$' 

Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -