Can you give more details
- the query you are running
- schema of the table
- serialization format of the table, sample records if possible.
On Wed, Apr 1, 2015 at 6:32 PM, r7raul1...@163.com wrote:
>
> I use hive 1.1.0 cli on computer A (linux) the result is
>
> 87FQEZT1UEDXJHJQPFFX7G7ET8S
ACABHS95DRQEE8DVFEB8JSE1',
'UBDTK8D9XUZ9GRZU8NZNXDEG73D4PCZG',
'87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM')
I attach my sample data.
r7raul1...@163.com
From: Thejas Nair
Date: 2015-04-02 15:28
To: dev
Subject: Re: hive 0.14 on some pla
Time'='1427870517',
> 'numRows'='0',
> 'totalSize'='8268127466928',
> 'rawDataSize'='0')
>
> My query is :
>
> SELECT a1.sessn_id,
>
>a1.ordr_code,
>
>a1.cart_tracker_id,
>
> a1.end_user_id,
&
In my test enviroment . I use hive 0.14 ,hive 1.1.0 ,the result is ok.
But in production enviroment ,the result is not correct.
r7raul1...@163.com
From: Thejas Nair
Date: 2015-04-02 16:41
To: r7raul1...@163.com
CC: dev
Subject: Re: Re: hive 0.14 on some platform return some not NULL value
t;a1.cart_tracker_id,
>
>a1.end_user_id,
>
> a1.cart_track_time
>
> FROM dw.fct_traffic_navpage_path_detl a1
>
> WHERE a1.ds = '2015-01-19'
>
> ANDa1.cart_tracker_id > 0
>
> AND(a1.cart_button_position IS NULL OR l
Sorry ,I check my production jdk is java version "1.7.0_45" not java
version "1.6.0_35"
r7raul1...@163.com
From: r7raul1...@163.com
Date: 2015-04-02 17:01
To: dev
Subject: Re: Re: hive 0.14 on some platform return some not NULL value as NULL
I download full data f
0.14 lost some column info. Why? BTW, My meta database schema is
hive 0.10 not update to hive 0.14.
r7raul1...@163.com
From: r7raul1...@163.com
Date: 2015-04-02 15:36
To: dev
CC: thejas.nair
Subject: Re: Re: hive 0.14 on some platform return some not NULL value as NULL
DDL is
CREATE TABLE
I use hive 0.14 to use hive 0.10 metastroe server .The problem fixed. Now hive
0.14 return correct result.
r7raul1...@163.com
From: r7raul1...@163.com
Date: 2015-04-07 10:34
To: dev
CC: thejas.nair
Subject: Re: Re: hive 0.14 on some platform return some not NULL value as NULL
I found