qq_44666176的博客

Hive行列转换函数数据准备-- 创建一个测试库CREATE DATABASE dw;-- 创建行转列测试数据表CREATE TABLE IF NOT EXISTS dw.person( name string, gender string, age int, hobby string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;-- 数