0636-6.1.1-Hue上SQL查询结果显示不全异常分析

最新推荐文章于 2023-04-17 15:57:07 发布

Hadoop_SC

最新推荐文章于 2023-04-17 15:57:07 发布

阅读量1k

点赞数

分类专栏： Hadoop实操

本文链接：https://blog.csdn.net/Hadoop_SC/article/details/101127859

版权

本文介绍了在Hue上遇到SQL查询结果出现异常，特别是字段值过长时显示不全的问题。通过收起右侧面板，可以在一定程度上解决这个问题。这可能是Hue Web UI的一个bug，建议在执行查询前保持右侧工具栏展开，以确保长字段的完整显示。

摘要由CSDN通过智能技术生成

Fayson的github： https://github.com/fayson/cdhproject

推荐关注微信公众号：“Hadoop实操”，ID：gh_c4c535955d0f

1 异常重现

1.在Hive中准备一张表，一共5个字段，采用文本存储。
在这里插入图片描述
2.准备数据并导入到该Hive表中，注意我们准备的数据第四个字段即s4的值特别长，约有5000多个字符。

2018-12-11 14:53:41|0401b8658016b33d9b4d1971e8cd22d2|CCD.MRRISK-COMMON_PAY.pay|"{""positionProperty"":{""altitude"":"""",""latitude"":"""",""province"":""上海"",""country"":""中国"",""longitude"":"""",""city"":""上海""},""deviceExtProperty"":{""appVersion"":""6.0.8"",""isRoot"":""false"",""appName"":""com.cmbchina.ccd.pluto.cmbActivity.debug"",""channel"":""unknown"",""isVirtual"":""false""},""deviceBasicProperty"":{""cpuSerial"":""0000000000000000"",""fingerprint"":""vivo/PD1603/PD1603:5.1.1/LMY47V/compiler10071102:user/release-keys"",""brand"":""vivo"",""widthPixels"":""1080"",""osVersion"":""5.1.1"",""heightPixels"":""1920"",""manufacturer"":""vivo"",""cpuABI"":""armeabi-v7a"",""density"":""3.0"",""os"":""android"",""model"":""vivo X7Plus""},""hotSpotProperty"":{""ssid"":""\""CMB-CCD\"""",""bssid"":""00:35:1a:2b:d1:de""},""message"":{""pushProvider"":""getui"",""deviceToken"":""7fe0b44a5b3fc8a31149b33700801f1a""},""networkProperty"":{""clientIP"":""99.48.192.10"",""networkType"":""4""},""deviceUniq