regexp_extract_all(string,pattern,group)


Advertisements

Query

presto:default> SELECT regexp_extract_all('1a 2b 3c 6f', '(\d+)([a-z]+)', 2) 
as regexp_group; 

Result

regexp_group 
-------------- 
 [a, b, c, f] 

Here,

  • First arg - string
  • Second arg - pattern
  • Third arg - 2 indicates two groups are used (d+ and a-z)

Hence, the query returns the string matched by the regular expression pattern (a-z) characters with the group.

apache_presto_sql_functions.htm

Useful Video Courses


Video

Apache Spark Online Training

46 Lectures 3.5 hours

Arnab Chakraborty

Video

Apache Spark with Scala - Hands On with Big Data

23 Lectures 1.5 hours

Mukund Kumar Mishra

Video

Learn Apache Cordova using Visual Studio 2015 & Command line

16 Lectures 1 hours

Nilay Mehta

Video

Delta Lake with Apache Spark using Scala

52 Lectures 1.5 hours

Bigdata Engineer

Video

Apache Zeppelin - Big Data Visualization Tool

14 Lectures 1 hours

Bigdata Engineer

Video

Olympic Games Analytics Project in Apache Spark for Beginner

23 Lectures 1 hours

Bigdata Engineer

Advertisements