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""},""deviceUniqueProperty"":{""imei"":""862820034468197"",""clientMAC"":""20:5d:47:fc:95:2b"",""iccid"":""89860117831003927273"",""imsi"":""460011630520203""},""pkey"":null,""type"":""a"",""version"":""73"",""deviceId"":""18e86e6f20404b9e91593e487816c8bf"",""checkId"":""18e86e6f20404b9e91593e487816c8bf8"",""userId"":""7afb940fa11d4f0ab16beebfc7584ea9"",""timestamp"":""2018-06-14 15:32:57"",""appId"":""94b55077f4174dd989d0e9505d2f4525"",""sessionId"":""1509f3c4194c44a9974d0d9c12d01fcf"",""serverIP"":""218.242.174.226.218.242.174.226, 192.168.4.1"",""model"":""vivo X7Plus"",""innerVersion"":""73"",""outerVersion"":""6.0.8"",""deviceToken"":""7fe0b44a5b3fc8a31149b33700801f1a"",""districtVersion"":{""country"":""中国"",""province"":""上海"",""city"":""上海"",""county"":""浦东新区"",""postCode"":""310115"",""radius"":""0.3""},""advancedVersion"":{""country"":""中国"",""province"":""上海"",""city"":""上海"",""organization"":"""",""carrier"":""东方有线/电信/联通/移动"",""latitude"":""31.231706"",""longitude"":""121.472644"",""timezone"":""Asia/Shanghai"",""timezone2"":""UTC+8"",""postcode"":""310000"",""phoneCode"":""86"",""countryCode"":""CN"",""continentCode"":""AP""},""bizParams"":""{\""trackId\"":\""c609e6771e4245a59b2651e40da3aa4b\"",\""bizOrderNo\"":\""20180614153257-tS7MBh\"",\""appId\"":\""94b55077f4174dd989d0e9505d2f4525\"",\""x_keyType\"":\""2\"",\""random\"":\""e4cbfa4f9ac459cc8393732ff3f98db3\"",\""payTips\"":\""\"",\""callBeforePayUrl\"":\""vWabILG4MKLDhYY4jrNAVDEJiEeI0Vx4ZvsOOfcidqLIWFafzaCO8yxrxR4EtuG/FK2LYMAn04qLco/8RRBAO/INXbTJbpeF\"",\""amount\"":\""3700\"",\""productDesc\"":\""（测试）大杯冰摇柚柚红茶\"",\""secElement\"":\""{\\\""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\\\""},\\\""deviceUniqueProperty\\\"":{\\\""imei\\\"":\\\""862820034468197\\\"",\\\""clientMAC\\\"":\\\""20:5d:47:fc:95:2b\\\"",\\\""iccid\\\"":\\\""89860117831003927273\\\"",\\\""imsi\\\"":\\\""460011630520203\\\""},\\\""pkey\\\"":null,\\\""type\\\"":\\\""a\\\"",\\\""version\\\"":\\\""73\\\"",\\\""deviceId\\\"":\\\""18e86e6f20404b9e91593e487816c8bf\\\"",\\\""checkId\\\"":\\\""18e86e6f20404b9e91593e487816c8bf8\\\"",\\\""userId\\\"":\\\""7afb940fa11d4f0ab16beebfc7584ea9\\\"",\\\""timestamp\\\"":\\\""2018-06-14 15:32:57\\\"",\\\""appId\\\"":\\\""94b55077f4174dd989d0e9505d2f4525\\\"",\\\""sessionId\\\"":\\\""1509f3c4194c44a9974d0d9c12d01fcf\\\"",\\\""serverIP\\\"":\\\""218.242.174.226.218.242.174.226, 192.168.4.1\\\"",\\\""model\\\"":\\\""vivo X7Plus\\\"",\\\""innerVersion\\\"":\\\""73\\\"",\\\""outerVersion\\\"":\\\""6.0.8\\\"",\\\""deviceToken\\\"":\\\""7fe0b44a5b3fc8a31149b33700801f1a\\\""}\"",\""x_version\"":\""73\"",\""sessionId\"":\""1509f3c4194c44a9974d0d9c12d01fcf\"",\""userId\"":\""7afb940fa11d4f0ab16beebfc7584ea9\"",\""payConfigId\"":\""\"",\""x_type\"":\""a\"",\""payType\"":\""1000\"",\""appChannel\"":\""cmblife\"",\""bonus\"":\""0\"",\""x_traceid\"":\""92f9a6f7f2d04f62bcd7c58b2ca2869a\"",\""merchantNo\"":\""MerchO2O\"",\""deviceId\"":\""18e86e6f20404b9e91593e487816c8bf8\""}"",""merchantNum"":null,""order_description"":null,""productNo"":""9918061400005"",""bizType"":null,""merchantNo"":""MerchO2O"",""storeNo"":null,""riskExtraParams"":null,""amount"":""3700"",""bonus"":""0"",""payType"":""1000"",""orderNo"":""20180614153257-tS7MBh"",""currencyCode"":null,""orderType"":null}"|2018-12-11

3.通过Hive的CLI查询结果如下，注意s4字段的值特别长。

4.使用Hue执行查看结果。

可以看到最后一个字段s5没办法查看完整，即使把横向滚动条拖到最右边。

2.问题解决

1.Hue提供了一个功能可以展开该行数据以查看完整数据。

展开后可以看到所有字段的数据

S4字段的值太长没有显示完整，可以单击那一行以全部显示。

点击后展开完整已经全部显示。

3.问题总结

1.在Hue上使用Hive和Impala执行SQL语句，如果返回的数据过长可能会导致部分数据无法显示完整，这应该是Hue的Web UI的bug，暂未找到相应的jira编号。Fayson在前面的文章中已经进行了说明，参考《0636-6.1.1-Hue上SQL查询结果显示不全异常分析》。

2.本文是通过Hue中不太为大家所熟知的功能展开单行数据来解决查询结果显示不完整的问题。