Community
Training
Partners
Support
Cloudera Community
Cloudera Community
Announcements
Community Announcements
What's New @ Cloudera
Support
Support Questions
Community Articles
Groups
Using the Community
Getting Started
Intros and Suggestions
Community Tips
Blogs
Developer Blogs
Engineering Blogs
Cloudera Developers
Sign In
jason_zondor
New Member
View All
Cloudera Community
About jason_zondor
Member since
06-23-2017
8
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title
Views
Posted
Re: Hive xpath: XML in a column where data contain...
Support Questions
4349
01-03-2019
03:04 PM
Show All
Topics jason_zondor has Participated In
Topics jason_zondor has Participated In
Latest Contributions by jason_zondor
Re: Hive xpath: XML in a column where data contain...
by
jason_zondor
in
Support Questions
01-03-2019
03:04 PM
01-03-2019
03:04 PM
I figured out that if I use regex_replace, I can work around the data issue. select xpath_string(regex_replace(xml_column, '\\?\<', ''), '//Root [@name="OfferId"]/@value') from table;
... View more
Contact Me
Online
Offline
Last Visited
11-11-2024
10:43 AM
Community Statistics
Member Since
06-23-2017
03:48 PM
Last Visited
11-11-2024
10:43 AM
Posts
8
