'How to parse multi-KV concated string in hiveql to get the value of key

For example, I get a string extro_score column whose values are:

     extro_score 
1    shCVR:0.00879116658,cScore:0.0537asd319593194,xScores:0.00526
2    shCVR:0.0085123,cScore:0.0587245814
3    recReasonRecallTopNId:23049

I want to select the value of shCVR but there are not all samples have the key shCVR.
Thanks in advance.

sqlstringhiveql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions