[HIVE-3740] Insert into table with partition : overwriting the partition instead of appending records while running the hql script

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.8.1
• Component/s: CLI
• Assignee: Unassigned
• Reporter: Sujesh Chirackkal
• Created: 22/Nov/12 10:17
• Updated: 26/Nov/12 01:05
• Resolved: 26/Nov/12 01:05

Description

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.