Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use regular expressions in hive, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

Regular expressions in hive are still powerful. Data workers are usually inseparable from regular expressions. In this regard, I specially made a summary of hive regular expressions. All the code has been tested and runs normally.

2.regexp_extract

Syntax: regexp_extract (string subject, string pattern, int index)

Return value: string

Description: splits the string subject according to the rules of pattern regular expressions and returns the characters specified by index.

Hive > select regexp_extract ('IloveYou','I (. *?) (You)', 1) from test1 limit 1

Total jobs = 1

. . .

Total MapReduce CPU Time Spent: 7 seconds 340 msec

Ok

Love

Time taken: 28.067 seconds, Fetched: 1 row (s)

Hive > select regexp_extract ('IloveYou','I (. *?) (You)', 2) from test1 limit 1

You

Hive > select regexp_extract ('IloveYou',' (I) (. *?) (You)', 1) from test1 limit 1

I

Hive > select regexp_extract ('IloveYou',' (I) (. *?) (You)', 0) from test1 limit 1

IloveYou

Hive > select regexp_replace ("IloveYou", "You", "") from test1 limit 1

Ilove

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.