hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liao, Xiaoge (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-9466) dynamic partition return error result
Date Mon, 26 Jan 2015 11:58:35 GMT
Liao, Xiaoge created HIVE-9466:
----------------------------------

             Summary: dynamic partition return error result
                 Key: HIVE-9466
                 URL: https://issues.apache.org/jira/browse/HIVE-9466
             Project: Hive
          Issue Type: Bug
          Components: CLI
    Affects Versions: 0.13.1
            Reporter: Liao, Xiaoge


expect value is "987654	aaa	123", but result "987654	NULL	123"

1.
drop table schema_test_xgliao;
create table schema_test_xgliao( a string) PARTITIONED  by (p String);

drop table schema_test1_xgliao;
create table schema_test1_xgliao(a string,b string);

insert OVERWRITE table schema_test1_xgliao
select orderid  as p, num from tmp_ubtdb.orderfix limit 10;
select * from schema_test1_xgliao;


2.
set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
insert OVERWRITE table schema_test_xgliao
PARTITION (p)
select b,a from schema_test1_xgliao;

select * from schema_test_xgliao t where t.p='123';

alter table schema_test_xgliao add columns(b string) ;

3.
set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
insert OVERWRITE table schema_test_xgliao
PARTITION (p)
select b as x, 'aaa' as y, a as z from schema_test1_xgliao;

select * from schema_test_xgliao t where t.p='123';



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message