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

Editor to share with you how to parse the json string 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 go to know it!

Background:

Parsing json data

Method 1:

Select log.*,b.*

From (

Select t1.user_id

, t1.signup_info

From ods_new_activity_db_t_com_signup_record t1

Where t1.user_id = '015813127e3144a9aa1d1f763b33df1b'

) log

Lateral view json_tuple (log.signup_info, 'name', 'gender') b as F1, f2

Method 2:

Select get_json_object (data,'$. Name')

The above is all the contents of the article "how to parse json strings in hive". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.