Linux客户端:secureCRT on Mac
1、Hive数据直接查看
2、将数据导出成linux系统下的文件
3、将数据传到Mac查看
说明:以后遇到时字段中涉及到表情符的导出查看情况,可以直播导出成文件,然后在Mac或Win下查看及后续操作。
1、Hive数据直接查看
hive> select uid,nickname
> from oss_bi_all_user_profile
> where pt_day='2018-04-18' and uid in(1133572117,1224160922,1056349348,1259606656,516391700,1298569537);
Total MapReduce CPU Time Spent: 3 minutes 50 seconds 870 msec
OK
1298569537 月月nb1056349348 YAOYAO1259606656 Namelessness1224160922 讨厌516391700 帝王宫1133572117 帝王宫Time taken: 119.211 seconds, Fetched: 6 row(s)
可以看出,得到6行数据,实际上只在一行人显示,且因为表情符会吃掉一部分其他字段数据。2、将数据导出成linux系统下的文件
[hadoop@emr-worker-9 Zhouxq]$ hive -e "select uid,nickname
> from oss_bi_all_user_profile
> where pt_day='2018-04-18' and uid in(1133572117,1224160922,1056349348,1259606656,516391700,1298569537);">0423.txt
.................
OK
Time taken: 90.443 seconds, Fetched: 6 row(s)
Cat查看:[hadoop@emr-worker-9 Zhouxq]$ cat 0423.txt
1298569537 月月nb1056349348 YAOYAO1259606656 Namelessness1224160922 讨厌516391700 帝王宫1133572117 帝王宫[hadoop@emr-worker-9 Zhouxq]$
依然是那种情况。
3、将数据传到Mac查看
[hadoop@emr-worker-9 Zhouxq]$ sz 0423.txt
rz
Starting zmodem transfer. Press Ctrl+C to cancel.
Transferring 0423.txt...
100% 160 bytes 160 bytes/sec 00:00:01 0 Errors
[hadoop@emr-worker-9 Zhouxq]$
ue中打开:
说明:以后遇到时字段中涉及到表情符的导出查看情况,可以直播导出成文件,然后在Mac或Win下查看及后续操作。