造一行常量数据SQL
select “col1”,“col2”,“col3”
造多行多列
select concat('AAA', ':', "BBB", '_PP', ':', "XXXXX") as key1,
concat(
'{"Id":"',
"12323213",
'","url":"',
"http://helloworld.com/hello.html",
'","code":"',
"hello",
'"}'
) as key2
union
select concat('AAA', ':', "BBB", '_PP', ':', "YYYYY") as key1,
concat(
'{"Id":"',
"12323213",
'","url":"',
"http://helloworld.com/hello.html",
'","code":"',
"hello",
'"}'
) as key2
{“Id”:“12323213”,“url”:“http://helloworld.com/hello.html”,“code”:“hello”}
行列数据转为结构体数组
select array(named_struct('name',name,'age',age) ) from (
select concat('AAA', ':', "BBB", '_PP', ':', "XXXXX") as name,
concat(
'{"Id":"',
"12323213",
'","url":"',
"http://helloworld.com/hello.html",
'","code":"',
"hello",
'"}'
) as age
union
select concat('AAA', ':', "BBB", '_PP', ':', "YYYYY") as name,
concat(
'{"Id":"',
"12323213",
'","url":"',
"http://helloworld.com/hello.html",
'","code":"',
"hello",
'"}'
) as age
)
