现有条日志形式为 :{"code":"A|B|C|D|","name":"a|b|c|d|"}
目标形式为:
A a
B b
C c
D d
请教各位用什么方法,谢谢了~
现有条日志形式为 :{"code":"A|B|C|D|","name":"a|b|c|d|"}
目标形式为:
A a
B b
C c
D d
请教各位用什么方法,谢谢了~
SELECT add FROM
(SELECT
CONCAT(
CONCAT(split('A|B|C|D|','\|')[0],'\t',split('a|b|c|d|','\|')[0]),',',
CONCAT(split('A|B|C|D|','\|')[1],'\t',split('a|b|c|d|','\|')[1]),',',
CONCAT(split('A|B|C|D|','\|')[2],'\t',split('a|b|c|d|','\|')[2]),',',
CONCAT(split('A|B|C|D|','\|')[3],'\t',split('a|b|c|d|','\|')[3])) AS A FROM DUAL)
AS O1
LATERAL VIEW EXPLODE(split(O1.A,',')) adtable as add