首页 > 代码库 > hive 行转列显示
hive 行转列显示
首先查看一个sql
1、首先存在一个数据表tmp
CREATE TABLE tmp( platform string, channel string, chan_value string, uid string, host int, logtime string, bd_source string, action string, refer string, back_url string, browser string, mobile string, server_ip string, ip string, url string, post string, handle_time string, logday string)
2、查看这个表的数据
hive> select * from tmp limit 2;OKadr partner touch.qunar.com - 4 00:00:05 - SgTrainStation http://touch.qunar.com/baiduTrain.jsp?bd_source=alading_webapp android mozilla/5.0 (linux; android 4.4.2; hw-huawei p7-l09 build/huaweip7-l09) applewebkit/537.36 (khtml, like gecko) version/4.0 mobile safari/537.36 192.168.24.222 119.0.34.213 /SgTrainStation?keyword=上&_=1416153604205 - 1 20141117adr partner touch.qunar.com - 0 00:00:05 - SgTrainStation http://touch.qunar.com/baiduTrain.jsp?bd_source=alading_webapp android mozilla/5.0 (linux; android 4.4.2; hw-huawei p7-l09 build/huaweip7-l09) applewebkit/537.36 (khtml, like gecko) version/4.0 mobile safari/537.36 192.168.24.222 119.0.34.213 /SgTrainStation?keyword=上&_=1416153604205 - 1 20141117Time taken: 2.549 seconds, Fetched: 2 row(s)
这个数据十分不可读，那么就希望能格式化这些数据
3、set hive.cli.print.header=true; // 打印列名
hive> select * from tmp limit 2; OKplatform channel chan_value uid host logtime bd_source action refer back_url browser mobile server_ip ip url post handle_time logdayadr partner touch.qunar.com - 4 00:00:05 - SgTrainStation http://touch.qunar.com/baiduTrain.jsp?bd_source=alading_webapp android mozilla/5.0 (linux; android 4.4.2; hw-huawei p7-l09 build/huaweip7-l09) applewebkit/537.36 (khtml, like gecko) version/4.0 mobile safari/537.36 192.168.24.222 119.0.34.213 /SgTrainStation?keyword=上&_=1416153604205 - 1 20141117adr partner touch.qunar.com - 0 00:00:05 - SgTrainStation http://touch.qunar.com/baiduTrain.jsp?bd_source=alading_webapp android mozilla/5.0 (linux; android 4.4.2; hw-huawei p7-l09 build/huaweip7-l09) applewebkit/537.36 (khtml, like gecko) version/4.0 mobile safari/537.36 192.168.24.222 119.0.34.213 /SgTrainStation?keyword=上&_=1416153604205 - 1 20141117Time taken: 0.218 seconds, Fetched: 2 row(s)
上面增加了列名
4、set hive.cli.print.row.to.vertical=true; // 开启行转列功能, 前提必须开启打印列名功能
5、set hive.cli.print.row.to.vertical.num=1; // 设置每行显示的列数
------------------这两步暂时没有生效，是xml文件设置的问题---------
hive 行转列显示
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。