[
https://issues.apache.org/jira/browse/HIVE-3740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Navis resolved HIVE-3740.
-------------------------
Resolution: Duplicate
Sorry, this is caused by HIVE-3676.
> Insert into table with partition : overwriting the partition instead of
> appending records while running the hql script
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-3740
> URL: https://issues.apache.org/jira/browse/HIVE-3740
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.8.1
> Reporter: Sujesh Chirackkal
>
> insert into table with partition works well with CLI. But overwriting the
> partition when executed through hql script.
> Table Schema
> (Table Name: jobs_status, partitioned on column job_name)
> completed_time string
> job_name string
> hive script (status.hql) contains the below commands
> use sample_db;
> insert into table job_status
> partition(job_name='testJob')
> select t.completionTime as completed_time from (select count(1) as cnt,
> from_unixtime(unix_timestamp()) as completionTime)t;
> The above commands when executed through CLI works well and append new
> records into the partition. But when executing the script as hive -f
> status.hql, it overwrites the existing records from the partition and insert
> only the new record.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
