You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "liaozhenjiang (JIRA)" <ji...@apache.org> on 2018/05/03 08:22:00 UTC
[jira] [Commented] (HIVE-19398) hive overwrite table1 fail insert
[ https://issues.apache.org/jira/browse/HIVE-19398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16462095#comment-16462095 ]
liaozhenjiang commented on HIVE-19398:
--------------------------------------
the script is as follows.
their 120 "select xx from xx union all.. ".
But it sometimes fail to insert data into partition of table ,
what's the problem? how to avoid the problem?
{panel}
set hive.exec.parallel=true;
set hive.exec.parallel.thread.number=50;
insert into mart.yy_indicate_mon PARTITION (pt_dt = '${hiveconf:tx_date}')
select 'BLL-YQQS','business_overtime_count',count(1),'yqqs' ,'xxx' from sda.loancore_asset_repay_plan t where t.REPAY_PLAN_STATUS in('4','5') and pt_dt = 'xxx'
union all
SELECT 'BLL-GJBLLQSB','business_overtime_count_per',OVERDUE_NUM/ALL_NUM ,'yqqsb' ,'xxx2' from (SELECT COUNT(1) OVERDUE_NUM FROM sda.loancore_asset_repay_plan t where t.REPAY_PLAN_STATUS in('4','5') and pt_dt = '${hiveconf:tx_date}') a,(SELECT COUNT(1) ALL_NUM FROM sda.loancore_asset_repay_plan WHERE REPAY_PLAN_STATUS in('1','4','5') and pt_dt = 'xxx') b
union all
。。。
{panel}
> hive overwrite table1 fail insert
> ----------------------------------
>
> Key: HIVE-19398
> URL: https://issues.apache.org/jira/browse/HIVE-19398
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.1.0
> Reporter: liaozhenjiang
> Priority: Major
> Fix For: 1.1.0
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)