Home > database >  No fixed number of k - v/json parse SQL problem
No fixed number of k - v/json parse SQL problem

Time:11-08

Is there a understand json structure of SQL great god?

Problem: using hive function, parse the json key and vlaue

Json example: {" aa0af288a ":" successed ", "72099 ea1169" : "error", "aaaffff234c" : "successed"}

Difficulties: the number and the name of the key of the json are unknown, but the vlaue of fixed value (successed, the error)
  • Related