sql造数据
造一行常量数据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
)