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

Fayson

发布于 2019-05-29 00:26:37

1.2K0

发布于 2019-05-29 00:26:37

文章被收录于专栏：Hadoop实操Hadoop实操

温馨提示：如果使用电脑查看图片不清晰，可以使用手机打开文章单击文中的图片放大查看高清原图。
Fayson的github： https://github.com/fayson/cdhproject
提示：代码块部分可以左右滑动查看噢

异常重现

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
*/