[
https://issues.apache.org/jira/browse/HIVE-19398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis updated HIVE-19398:
---------------------------------------
Fix Version/s: (was: 1.1.0)
I cleared the fixVersion field since this ticket is still open. Please review
this ticket and if the fix is already committed to a specific version please
set the version accordingly and mark the ticket as RESOLVED.
According to the [JIRA
guidelines|https://cwiki.apache.org/confluence/display/Hive/HowToContribute]
the fixVersion should be set only when the issue is resolved/closed.
> 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
>
> the script is as follows.
> their are 120 "select xx from xx union all.. ".
> But it sometimes fail to insert data into partition of table ,with none
> exception or failure information。
> what's the problem? how to avoid the problem？
> ||code||
> |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
> 。。。|
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
