[
https://issues.apache.org/jira/browse/HIVE-12874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
bin wang updated HIVE-12874:
----------------------------
Affects Version/s: (was: 0.14.1)
1.1.0
> dynamic partition insert project wrong column
> ---------------------------------------------
>
> Key: HIVE-12874
> URL: https://issues.apache.org/jira/browse/HIVE-12874
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.1.0
> Environment: hive 1.1.0-cdh5.4.8
> Reporter: bin wang
> Assignee: Alan Gates
>
> We have two table as below:
> create table test (
> id bigint comment ' id',
> )
> PARTITIONED BY(etl_dt string)
> STORED AS ORC;
> create table test1 (
> id bigint
> start_time int,
> )
> PARTITIONED BY(etl_dt string)
> STORED AS ORC;
> we use sql like below to import rows from test1 to test:
> insert overwrite table test PARTITION(etl_dt)
> select id
> ,from_unixtime(start_time,'yyyy-MM-dd') as etl_dt
>
>
> from test1
> where test1.etl_dt='2016-01-12';
> but it behave wrong, it use test1.etl_dt as the test's partition value, not
> the 'etl_dt' in select.
> We think it's a bug, anyone to fix it?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
