[jira] [Updated] (HIVE-19398) hive overwrite table1 fail insert

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

     [ 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)