Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 861CF17D23 for ; Thu, 2 Apr 2015 07:37:52 +0000 (UTC) Received: (qmail 3981 invoked by uid 500); 2 Apr 2015 07:37:52 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 3905 invoked by uid 500); 2 Apr 2015 07:37:52 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 3893 invoked by uid 99); 2 Apr 2015 07:37:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Apr 2015 07:37:51 +0000 X-ASF-Spam-Status: No, hits=3.4 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of r7raul1984@163.com designates 220.181.12.13 as permitted sender) Received: from [220.181.12.13] (HELO m12-13.163.com) (220.181.12.13) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Apr 2015 07:37:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:Subject:Mime-Version:Message-ID; bh=9cAiw KWGAkCcHgUfpaABx/jO/WL+LCxSG1zXF2vzGCU=; b=exqZizAFsPjlubPK/DfRY b3+xhMbieJlTGNLAbcmunc61bz/f2DTVqc7+juJVr7Krbp14fm57+NFKmxkDAlIH p8r68S/ydqQ6MwIOJ3V5GTqzhvRouL9L+UXBH+W8lW6vvJhbN8Q9Mhm9TO1x8YBu ZdLNAwLm2vmvgDisp/uO6A= Received: from NHSH1MNB72514 (unknown [203.110.175.179]) by smtp9 (Coremail) with SMTP id DcCowABnlMyh8RxVoZ7zAA--.564S2; Thu, 02 Apr 2015 15:37:16 +0800 (CST) Date: Thu, 2 Apr 2015 15:36:22 +0800 From: "r7raul1984@163.com" To: dev Cc: thejas.nair Subject: Re: Re: hive 0.14 on some platform return some not NULL value as NULL References: <201504020932465912416@163.com>, X-Priority: 3 X-Has-Attach: yes X-Mailer: Foxmail 7, 2, 5, 136[cn] Mime-Version: 1.0 Message-ID: <2015040215361179966510@163.com> Content-Type: multipart/mixed; boundary="----=_001_NextPart476518138308_=----" X-CM-TRANSID: DcCowABnlMyh8RxVoZ7zAA--.564S2 X-Coremail-Antispam: 1Uf129KBjvJXoW7ZrWrJr1DAr18ZF15CF17ZFb_yoW8uF45pr 1I9F43Kw1Yqry3Kw4FkF4UXw4Ikry5W3yjqrWft3WrKas8uFyYqw1jkr9Y9rZxCan0grsr Gw4jgw109F4a9a7anT9S1TB71UUUUUUqnTZGkaVYY2UrUUUUjbIjqfuFe4nvWSU5nxnvy2 9KBjDUYxBIdaVFxhVjvjDU0xZFpf9x07UfhLUUUUUU= X-Originating-IP: [203.110.175.179] X-CM-SenderInfo: 3uxut3borzmki6rwjhhfrp/xtbBzxnPzlD+l4TnQAAAsN X-Virus-Checked: Checked by ClamAV on apache.org ------=_001_NextPart476518138308_=---- Content-Type: multipart/alternative; boundary="----=_002_NextPart713500644487_=----" ------=_002_NextPart713500644487_=---- Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 DQpEREwgaXMNCkNSRUFURSBUQUJMRSBkdy5mY3RfdHJhZmZpY19uYXZwYWdlX3BhdGhfZGV0bCgg DQpkYXRlX2lkIHN0cmluZywgDQpjaGFubF9pZCBiaWdpbnQsIA0Kc2Vzc25faWQgc3RyaW5nLCAN Cmd1X2lkIHN0cmluZywgDQpwcm92X2lkIHN0cmluZywgDQpjaXR5X2lkIHN0cmluZywgDQpsYW5k aW5nX3BhZ2VfdHlwZV9pZCBzdHJpbmcsIA0KbGFuZGluZ190cmFja190aW1lIHN0cmluZywgDQps YW5kaW5nX3VybCBzdHJpbmcsIA0KbmF2X3JlZmVyX3RyYWNrZXJfaWQgc3RyaW5nLCANCm5hdl9y ZWZlcl9wYWdlX3R5cGVfaWQgc3RyaW5nLCANCm5hdl9yZWZlcl9wYWdlX3ZhbHVlIHN0cmluZywg DQpuYXZfcmVmZXJfbGlua19wb3NpdGlvbiBzdHJpbmcsIA0KbmF2X3RyYWNrZXJfaWQgc3RyaW5n LCANCm5hdl9wYWdlX2NhdGVnX2lkIHN0cmluZywgDQpuYXZfcGFnZV90eXBlX2lkIHN0cmluZywg DQpuYXZfcGFnZV92YWx1ZSBzdHJpbmcsIA0KbmF2X3NyY2VfdHlwZSBzdHJpbmcsIA0KaW50ZXJu YWxfa2V5d29yZCBzdHJpbmcsIA0KaW50ZXJuYWxfcmVzdWx0X3N1bSBzdHJpbmcsIA0KcGx0Zm1f aWQgaW50LCANCmFwcF92ZXJzIHN0cmluZywgDQpuYXZfbGlua19wb3NpdGlvbiBzdHJpbmcsIA0K bmF2X2J1dHRvbl9wb3NpdGlvbiBzdHJpbmcsIA0KbmF2X3RyYWNrX3RpbWUgc3RyaW5nLCANCm5h dl9uZXh0X3RyYWNrZXJfaWQgc3RyaW5nLCANCnNlc3NuX2xhc3RfdGltZSBzdHJpbmcsIA0Kc2Vz c25fcHYgaW50LCANCmRldGxfdHJhY2tlcl9pZCBzdHJpbmcsIA0KZGV0bF9wYWdlX3R5cGVfaWQg c3RyaW5nLCANCmRldGxfcGFnZV92YWx1ZSBzdHJpbmcsIA0KZGV0bF9wbV9pZCBiaWdpbnQsIA0K ZGV0bF9saW5rX3Bvc2l0aW9uIHN0cmluZywgDQpkZXRsX3Bvc2l0aW9uX3RyYWNrX2lkIHN0cmlu ZywgDQpjYXJ0X3RyYWNrZXJfaWQgc3RyaW5nLCANCmNhcnRfcGFnZV90eXBlX2lkIHN0cmluZywg DQpjYXJ0X3BhZ2VfdmFsdWUgc3RyaW5nLCANCmNhcnRfbGlua19wb3N0aW9uIHN0cmluZywgDQpj YXJ0X2J1dHRvbl9wb3NpdGlvbiBzdHJpbmcsIA0KY2FydF9wb3NpdGlvbl90cmFja19pZCBzdHJp bmcsIA0KY2FydF9wcm9kX2lkIGJpZ2ludCwgDQpvcmRyX3RyYWNrZXJfaWQgc3RyaW5nLCANCm9y ZHJfcGFnZV90eXBlX2lkIHN0cmluZywgDQpvcmRyX2NvZGUgc3RyaW5nLCANCnVwZHRfdGltZSBz dHJpbmcsIA0KY2FydF9wbV9pZCBiaWdpbnQsIA0KYnJhbmRfY29kZSBzdHJpbmcsIA0KY2F0ZWdf dHlwZSBpbnQsIA0Kb3Mgc3RyaW5nLCANCmVuZF91c2VyX2lkIHN0cmluZywgDQphZGRfY2FydF9m bGFnIHN0cmluZywgDQpuYXZnYXRpb25fcGFnZV9mbGFnIGludCwgDQpuYXZfcGFnZV91cmwgc3Ry aW5nLCANCmRldGxfYnV0dG9uX3Bvc2l0aW9uIHN0cmluZywgDQptYW51bF9mbGFnIGludCwgDQpt YW51bF90cmFja19kYXRlIHN0cmluZywgDQpuYXZfcmVmZXJfdHBhIHN0cmluZywgDQpuYXZfcmVm ZXJfdHBhX2lkIHN0cmluZywgDQpuYXZfcmVmZXJfdHBjIHN0cmluZywgDQpuYXZfcmVmZXJfdHBp IHN0cmluZywgDQpuYXZfcmVmZXJfdGNzIHN0cmluZywgDQpuYXZfcmVmZXJfdGNzYSBzdHJpbmcs IA0KbmF2X3JlZmVyX3RjZHQgc3RyaW5nLCANCm5hdl9yZWZlcl90Y2Qgc3RyaW5nLCANCm5hdl9y ZWZlcl90Y2kgc3RyaW5nLCANCm5hdl9yZWZlcl9wb3N0bl90eXBlIHN0cmluZywgDQpuYXZfdHBh X2lkIHN0cmluZywgDQpuYXZfdHBhIHN0cmluZywgDQpuYXZfdHBjIHN0cmluZywgDQpuYXZfdHBp IHN0cmluZywgDQpuYXZfdGNzIHN0cmluZywgDQpuYXZfdGNzYSBzdHJpbmcsIA0KbmF2X3RjZHQg c3RyaW5nLCANCm5hdl90Y2Qgc3RyaW5nLCANCm5hdl90Y2kgc3RyaW5nLCANCm5hdl9wb3N0bl90 eXBlIHN0cmluZywgDQpkZXRsX3RwYV9pZCBzdHJpbmcsIA0KZGV0bF90cGEgc3RyaW5nLCANCmRl dGxfdHBjIHN0cmluZywgDQpkZXRsX3RwaSBzdHJpbmcsIA0KZGV0bF90Y3Mgc3RyaW5nLCANCmRl dGxfdGNzYSBzdHJpbmcsIA0KZGV0bF90Y2R0IHN0cmluZywgDQpkZXRsX3RjZCBzdHJpbmcsIA0K ZGV0bF90Y2kgc3RyaW5nLCANCmRldGxfcG9zdG5fdHlwZSBzdHJpbmcsIA0KY2FydF90cGFfaWQg c3RyaW5nLCANCmNhcnRfdHBhIHN0cmluZywgDQpjYXJ0X3RwYyBzdHJpbmcsIA0KY2FydF90cGkg c3RyaW5nLCANCmNhcnRfdGNzIHN0cmluZywgDQpjYXJ0X3Rjc2Egc3RyaW5nLCANCmNhcnRfdGNk dCBzdHJpbmcsIA0KY2FydF90Y2Qgc3RyaW5nLCANCmNhcnRfdGNpIHN0cmluZywgDQpjYXJ0X3Bv c3RuX3R5cGUgc3RyaW5nLCANCnNlc3NuX2NoYW5sX2lkIGJpZ2ludCwgDQpndV9zZWNfZmxnIGJp Z2ludCwgDQpkZXRsX3JlZmVyX3BhZ2VfdHlwZV9pZCBzdHJpbmcsIA0KZGV0bF9yZWZlcl9wYWdl X3ZhbHVlIHN0cmluZywgDQpkZXRsX2V2ZW50X2lkIHN0cmluZywgDQpuYXZfcmVmZXJfaW50cm5f cmVzbHRfc3VtIHN0cmluZywgDQpuYXZfaW50cm5fcmVzbHRfc3VtIHN0cmluZywgDQpuYXZfcmVm ZXJfaW50cm5fa3cgc3RyaW5nLCANCm5hdl9pbnRybl9rdyBzdHJpbmcsIA0KZGV0bF90cmFja190 aW1lIHN0cmluZywgDQpjYXJ0X3RyYWNrX3RpbWUgc3RyaW5nKSANClBBUlRJVElPTkVEIEJZICgg DQpkcyBzdHJpbmcpIA0KUk9XIEZPUk1BVCBTRVJERSANCidvcmcuYXBhY2hlLmhhZG9vcC5oaXZl LnNlcmRlMi5sYXp5LkxhenlTaW1wbGVTZXJEZScgDQpTVE9SRUQgQVMgSU5QVVRGT1JNQVQgDQon b3JnLmFwYWNoZS5oYWRvb3AubWFwcmVkLlRleHRJbnB1dEZvcm1hdCcgDQpPVVRQVVRGT1JNQVQg DQonb3JnLmFwYWNoZS5oYWRvb3AuaGl2ZS5xbC5pby5IaXZlSWdub3JlS2V5VGV4dE91dHB1dEZv cm1hdCcgDQpMT0NBVElPTiANCicvdXNlci9oaXZlL2R3L2ZjdF90cmFmZmljX25hdnBhZ2VfcGF0 aF9kZXRsJyANClRCTFBST1BFUlRJRVMgKCANCidudW1QYXJ0aXRpb25zJz0nMjY1JywgDQonbnVt RmlsZXMnPScyNjY3NycsIA0KJ2xhc3RfbW9kaWZpZWRfYnknPSdiaV9ldGwnLCANCidsYXN0X21v ZGlmaWVkX3RpbWUnPScxNDIzNjMzMDI4JywgDQondHJhbnNpZW50X2xhc3REZGxUaW1lJz0nMTQy Nzg3MDUxNycsIA0KJ251bVJvd3MnPScwJywgDQondG90YWxTaXplJz0nODI2ODEyNzQ2NjkyOCcs IA0KJ3Jhd0RhdGFTaXplJz0nMCcpIA0KDQpNeSBxdWVyeSBpcyA6DQpTRUxFQ1QgYTEuc2Vzc25f aWQsDQogICAgICAgYTEub3Jkcl9jb2RlLA0KICAgICAgIGExLmNhcnRfdHJhY2tlcl9pZCwNCiAg ICAgICBhMS5lbmRfdXNlcl9pZCwNCiAgICAgICBhMS5jYXJ0X3RyYWNrX3RpbWUNCkZST00gICBk dy5mY3RfdHJhZmZpY19uYXZwYWdlX3BhdGhfZGV0bCBhMQ0KV0hFUkUgIGExLmRzID0gJzIwMTUt MDEtMTknDQpBTkQgICAgYTEuY2FydF90cmFja2VyX2lkID4gMA0KQU5EICAgIChhMS5jYXJ0X2J1 dHRvbl9wb3NpdGlvbiBJUyBOVUxMIE9SIGxlbmd0aChhMS5jYXJ0X2J1dHRvbl9wb3NpdGlvbikg PSAwKQ0KQU5EICAgIGExLnNlc3NuX2lkIElOICgnWTQ5RVk4OTVBQ0FCSFM5NURSUUVFOERWRkVC OEpTRTEnLA0KICAgICAgICAgICAgICAgICAgICAgICAnVUJEVEs4RDlYVVo5R1JaVThOWk5YREVH NzNENFBDWkcnLA0KICAgICAgICAgICAgICAgICAgICAgICAnODdGUUVaVDFVRURYSkhKUVBGRlg3 RzdFVDhTMkRWUE0nKQ0KDQoNCkkgYXR0YWNoIG15IHNhbXBsZSBkYXRhLg0KDQoNCg0KcjdyYXVs MTk4NEAxNjMuY29tDQogDQpGcm9tOiBUaGVqYXMgTmFpcg0KRGF0ZTogMjAxNS0wNC0wMiAxNToy OA0KVG86IGRldg0KU3ViamVjdDogUmU6IGhpdmUgMC4xNCBvbiBzb21lIHBsYXRmb3JtIHJldHVy biBzb21lIG5vdCBOVUxMIHZhbHVlIGFzIE5VTEwNCkNhbiB5b3UgZ2l2ZSBtb3JlIGRldGFpbHMN Ci0gdGhlIHF1ZXJ5IHlvdSBhcmUgcnVubmluZw0KLSBzY2hlbWEgb2YgdGhlIHRhYmxlDQotIHNl cmlhbGl6YXRpb24gZm9ybWF0IG9mIHRoZSB0YWJsZSwgc2FtcGxlIHJlY29yZHMgaWYgcG9zc2li bGUuDQogDQogDQpPbiBXZWQsIEFwciAxLCAyMDE1IGF0IDY6MzIgUE0sIHI3cmF1bDE5ODRAMTYz LmNvbSA8cjdyYXVsMTk4NEAxNjMuY29tPiB3cm90ZToNCj4NCj4gSSB1c2UgICBoaXZlIDEuMS4w IGNsaSAgb24gY29tcHV0ZXIgQSAobGludXgpICAgdGhlIHJlc3VsdCBpcw0KPg0KPiA4N0ZRRVpU MVVFRFhKSEpRUEZGWDdHN0VUOFMyRFZQTSAgICAgICAgMjM1NzM3ODI4MzM1NiAgIDkxNTAxMTkx MDQ0NDQwMDQ4DQo+IDczMjYzNTYgICAgICAgICBOVUxMDQo+DQo+IDg3RlFFWlQxVUVEWEpISlFQ RkZYN0c3RVQ4UzJEVlBNICAgICAgICAyMzU3Mzc4MjgzMzU2ICAgMTIxNTAxMTkxMDM1NTgwMDI4 DQo+IDczMjYzNTYgICAgICAgICBOVUxMDQo+DQo+IFVCRFRLOEQ5WFVaOUdSWlU4TlpOWERFRzcz RDRQQ1pHICAgICAgICAyMzYyMjIzNzExMjg5ICAgMTYxNTAxMTkxNTQ5MDUwMDYxDQo+IDE0ODM3 Mjg5ICAgICAgTlVMTA0KPg0KPiBZNDlFWTg5NUFDQUJIUzk1RFJRRUU4RFZGRUI4SlNFMSAgICAg ICAgMjM2MDg1MzA1MjIyNCAgIDExMTUwMTE5MTQyNjI4MDAyMw0KPiAxMTU4ODMyMjQgICAgICAg TlVMTA0KPg0KPiBCdXQgSSB1c2UgaGl2ZTAuMTQgY2xpIGluIG15IHRlc3QgZW52aXJvbWVudCB0 aGUgcmVzdWx0IGlzIGNvcnJlY3QuDQo+DQo+DQo+IEkgdXNlICBoaXZlIDAuMTAgb24gY29tcHV0 ZXIgQiAobGludXgpIHRoZSByZXN1bHQgaXMNCj4NCj4gODdGUUVaVDFVRURYSkhKUVBGRlg3RzdF VDhTMkRWUE0gICAgICAgIDIzNTczNzgyODMzNTYgICA5MTUwMTE5MTA0NDQ0MDA0OA0KPiA3MzI2 MzU2ICAgICAgICAyMDE1LTAxLTE5IDEwOjQ0OjQ0DQo+DQo+IDg3RlFFWlQxVUVEWEpISlFQRkZY N0c3RVQ4UzJEVlBNICAgICAgICAyMzU3Mzc4MjgzMzU2ICAgMTIxNTAxMTkxMDM1NTgwMDI4DQo+ IDczMjYzNTYgICAgICAgIDIwMTUtMDEtMTkgMTA6MzU6NTgNCj4NCj4gVUJEVEs4RDlYVVo5R1Ja VThOWk5YREVHNzNENFBDWkcgICAgICAgIDIzNjIyMjM3MTEyODkgICAxNjE1MDExOTE1NDkwNTAw NjENCj4gMTQ4MzcyODkgICAgIDIwMTUtMDEtMTkgMTU6NDk6MDUNCj4NCj4gWTQ5RVk4OTVBQ0FC SFM5NURSUUVFOERWRkVCOEpTRTEgICAgICAgIDIzNjA4NTMwNTIyMjQgICAxMTE1MDExOTE0MjYy ODAwMjMNCj4gMTE1ODgzMjI0ICAgICAgIDIwMTUtMDEtMTkgMTQ6MjY6MjgNCj4NCj4NCj4gV2h5 ID8NCj4NCj4gSSBhdHRhY2ggbXkgbG9nLiBBbHNvIGluIG15IGxvZyBJIGZvdW5kIDIwMTUtMDQt MDEgMDk6NTU6MzgsNDA5IFdBUk4gW21haW5dDQo+IG9yZy5hcGFjaGUuaGFkb29wLmhpdmUuc2Vy ZGUyLmxhenkuTGF6eVN0cnVjdDogRXh0cmEgYnl0ZXMgZGV0ZWN0ZWQgYXQgdGhlDQo+IGVuZCBv ZiB0aGUgcm93ISBJZ25vcmluZyBzaW1pbGFyIHByb2JsZW1zLg0KPg0KPg0KPiBfX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fXw0KPiByN3JhdWwxOTg0QDE2My5jb20NCg== ------=_002_NextPart713500644487_=---- Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable =0A

DDL is
= CREATE TABLE dw.fct_traffic_navpage_path_detl( 
date_id string,&nb= sp;
chanl_id bigint, 
sessn_id string, 
gu_id string,&n= bsp;
prov_id string, 
city_id string, 
landing_page_typ= e_id string, 
landing_track_time string, 
landing_url stri= ng, 
nav_refer_tracker_id string, 
nav_refer_page_type_id = string, 
nav_refer_page_value string, 
nav_refer_link_posi= tion string, 
nav_tracker_id string, 
nav_page_categ_id st= ring, 
nav_page_type_id string, 
nav_page_value string,&nb= sp;
nav_srce_type string, 
internal_keyword string, 
in= ternal_result_sum string, 
pltfm_id int, 
app_vers string,=  
nav_link_position string, 
nav_button_position string,&n= bsp;
nav_track_time string, 
nav_next_tracker_id string, <= br>sessn_last_time string, 
sessn_pv int, 
detl_tracker_id= string, 
detl_page_type_id string, 
detl_page_value strin= g, 
detl_pm_id bigint, 
detl_link_position string, detl_position_track_id string, 
cart_tracker_id string, cart_page_type_id string, 
cart_page_value string, 
cart_= link_postion string, 
cart_button_position string, 
cart_p= osition_track_id string, 
cart_prod_id bigint, 
ordr_track= er_id string, 
ordr_page_type_id string, 
ordr_code string= , 
updt_time string, 
cart_pm_id bigint, 
brand_co= de string, 
categ_type int, 
os string, 
end_user_= id string, 
add_cart_flag string, 
navgation_page_flag int= , 
nav_page_url string, 
detl_button_position string, = ;
manul_flag int, 
manul_track_date string, 
nav_refer_= tpa string, 
nav_refer_tpa_id string, 
nav_refer_tpc strin= g, 
nav_refer_tpi string, 
nav_refer_tcs string, 
= nav_refer_tcsa string, 
nav_refer_tcdt string, 
nav_refer_= tcd string, 
nav_refer_tci string, 
nav_refer_postn_type s= tring, 
nav_tpa_id string, 
nav_tpa string, 
nav_t= pc string, 
nav_tpi string, 
nav_tcs string, 
nav_= tcsa string, 
nav_tcdt string, 
nav_tcd string, 
n= av_tci string, 
nav_postn_type string, 
detl_tpa_id string= , 
detl_tpa string, 
detl_tpc string, 
detl_tpi st= ring, 
detl_tcs string, 
detl_tcsa string, 
detl_t= cdt string, 
detl_tcd string, 
detl_tci string, 
d= etl_postn_type string, 
cart_tpa_id string, 
cart_tpa stri= ng, 
cart_tpc string, 
cart_tpi string, 
cart_tcs = string, 
cart_tcsa string, 
cart_tcdt string, 
car= t_tcd string, 
cart_tci string, 
cart_postn_type string,&n= bsp;
sessn_chanl_id bigint, 
gu_sec_flg bigint, 
detl_r= efer_page_type_id string, 
detl_refer_page_value string, 
= detl_event_id string, 
nav_refer_intrn_reslt_sum string, 
= nav_intrn_reslt_sum string, 
nav_refer_intrn_kw string, 
n= av_intrn_kw string, 
detl_track_time string, 
cart_track_t= ime string) 
PARTITIONED BY ( 
ds string) 
ROW FOR= MAT SERDE 
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'&nb= sp;
STORED AS INPUTFORMAT 
'org.apache.hadoop.mapred.TextInputF= ormat' 
OUTPUTFORMAT 
'org.apache.hadoop.hive.ql.io.HiveIg= noreKeyTextOutputFormat' 
LOCATION 
'/user/hive/dw/fct_tra= ffic_navpage_path_detl' 
TBLPROPERTIES ( 
'numPartitions'= =3D'265', 
'numFiles'=3D'26677', 
'last_modified_by'=3D'bi= _etl', 
'last_modified_time'=3D'1423633028', 
'transient_l= astDdlTime'=3D'1427870517', 
'numRows'=3D'0', 
'totalSize'= =3D'8268127466928', 
'rawDataSize'=3D'0') 

=0A
My query is :
=0A=0A=0A=0A

SELECT a1.sessn_id,

=0A

=       =0Aa1.ordr_code,

= =0A

      =0Aa1.cart_tracker_= id,

=0A

     =  =0Aa1.end_user_id,

=0A

 &nb= sp;    =0Aa1.cart_track_time

=0A<= p class=3D"MsoNormal" align=3D"left" style=3D"text-align: justify; margin:= 0cm 0cm 0.0001pt; font-size: 10.5pt; font-family: Calibri, sans-serif;"><= span lang=3D"X-NONE" style=3D"font-size: 10pt; font-family: 'Courier New';= color: teal; background-position: initial initial; background-repeat: ini= tial initial;">FROM   dw.fct_traffic_navp= age_path_detl a1

=0A

WHERE  a1.ds =3D '2015-01-19'=

=0A

AND   = a1.cart_tracker_id > 0

=0A=

= AND    (a1.cart_butt= on_position IS NULL OR=0Alength(a1.c= art_button_position) =3D 0)<= o:p>

=0A

AND &n= bsp;  a1.sessn_id IN (<= /span>'Y49EY895ACABHS95DRQEE8DVFEB8JSE1',

=0A

    &n= bsp;           &nbs= p; =0A    'UBDTK8D9XUZ9GRZ= U8NZNXDEG73D4PCZG',

=0A

           = ;           =0A'87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM'

I attach my sample data.


=0A
=0A
=
<= div>r7raul1984@163.com
=0A
 
=0A
> 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM   = ;     2357378283356   121501191035580028=0A
> 7326356         NUL= L
=0A
>
=0A
> UBDTK8D9XUZ9GRZU8NZNXDEG73D4PCZG&nbs= p;       2362223711289   161501191= 549050061
=0A
> 14837289      NULL=0A
>
=0A
> Y49EY895ACABHS95DRQEE8DVFEB8JSE1 &n= bsp;      2360853052224   1115011914262= 80023
=0A
> 115883224       NULL=
=0A
>
=0A
> But I use hive0.14 cli in my test env= iroment the result is correct.
=0A
>
=0A
>
= =0A
> I use  hive 0.10 on computer B (linux) the result is=0A
>
=0A
> 87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM &nb= sp;      2357378283356   91501191044440= 048
=0A
> 7326356        20= 15-01-19 10:44:44
=0A
>
=0A
> 87FQEZT1UEDXJHJQPFFX= 7G7ET8S2DVPM        2357378283356 =   121501191035580028
=0A
> 7326356    = ;    2015-01-19 10:35:58
=0A
>
=0A
>= ; UBDTK8D9XUZ9GRZU8NZNXDEG73D4PCZG      &nbs= p; 2362223711289   161501191549050061
=0A
> 14837289=      2015-01-19 15:49:05
=0A
>
=0A> Y49EY895ACABHS95DRQEE8DVFEB8JSE1      = ;  2360853052224   111501191426280023
=0A
> 115= 883224       2015-01-19 14:26:28
=0A>
=0A
>
=0A
> Why ?
=0A
>
= =0A
> I attach my log. Also in my log I found 2015-04-01 09:55:38,4= 09 WARN [main]
=0A
> org.apache.hadoop.hive.serde2.lazy.LazySt= ruct: Extra bytes detected at the
=0A
> end of the row! Ignori= ng similar problems.
=0A
>
=0A
>
=0A
>= ________________________________
=0A
> r7raul1984@163.com=0A
=0A ------=_002_NextPart713500644487_=------ ------=_001_NextPart476518138308_=------