kudu-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Darren Hoo <darren....@gmail.com>
Subject Re: impala got duplicate fields after compute stats on kudu table
Date Mon, 18 Apr 2016 15:27:50 GMT
Hi, Jean-Daniel Cryans,

it is kudu 0.8.0

The issue also occurs with kudu 0.7.1, and I am sure. Only today did I
realized that there are duplicate fields.

I noticed earlier but did not go through with it,  `selece a,b,c from
my_table` is ok, but `select * from my_table` not OK, many duplicate fields.

On Mon, Apr 18, 2016 at 11:07 PM, Jean-Daniel Cryans <jdcryans@apache.org>
wrote:

> Hi Darren,
>
> Is this with Impala Kudu 0.8.0 or a previous version?
>
> Thx,
>
> J-D
>
> On Mon, Apr 18, 2016 at 7:29 AM, Darren Hoo <darren.hoo@gmail.com> wrote:
>
>> 1. create a kudu table  to test
>>
>>
>> create table t2 (
>>
>>     id  INT,
>>
>>     cid INT
>>
>> )
>>
>> TBLPROPERTIES(
>>
>>   'storage_handler' = 'com.cloudera.kudu.hive.KuduStorageHandler',
>>
>>   'kudu.table_name' = 't2',
>>
>>   'kudu.key_columns' = 'id',
>>
>>   'kudu.master_addresses' = 'master:7051'
>>
>> );
>>
>>
>>
>> 2. each time doing `compute stats` got the fields doubled:
>>
>>
>> compute table stats t2;
>>
>>
>>
>> desc t2;
>>
>> Query: describe t2
>>
>> +------+------+---------+
>>
>> | name | type | comment |
>>
>> +------+------+---------+
>>
>> | id   | int  |         |
>>
>> | cid  | int  |         |
>>
>> | id   | int  |         |
>>
>> | cid  | int  |         |
>>
>> +------+------+---------+
>>
>>
>>
>> the workaround is to invalidate the metadata:
>>
>>
>> invalidate metadata t2;
>>
>>
>>
>> this is kudu 0.8.0 on cdh5.7
>>
>
>

Mime
View raw message