You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Ming LI (JIRA)" <ji...@apache.org> on 2016/12/06 11:11:26 UTC
[jira] [Assigned] (HAWQ-1195) Synchrony:Union not working on
external tables ERROR:"Two or more external tables use the same error table
""xxxxxxx"" in a statement (execMain.c:274)"
[ https://issues.apache.org/jira/browse/HAWQ-1195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ming LI reassigned HAWQ-1195:
-----------------------------
Assignee: Ming LI (was: Lei Chang)
> Synchrony:Union not working on external tables ERROR:"Two or more external tables use the same error table ""xxxxxxx"" in a statement (execMain.c:274)"
> -------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: HAWQ-1195
> URL: https://issues.apache.org/jira/browse/HAWQ-1195
> Project: Apache HAWQ
> Issue Type: Bug
> Components: External Tables
> Reporter: Ming LI
> Assignee: Ming LI
>
> Hello,
> User create an external table and define the error table. Then he do the union on the same external table with different where condition. Then return the error:ERROR: Two or more external tables use the same error table "err_ext_pdr_cdci_pivotal_request_43448" in a statement (execMain.c:274)
> Below is the master log when I reproduce: (the whole log file attached in attachement)
> {code}
> 2016-11-29 22:49:51.976864 PST,"gpadmin","postgres",p769199,th-2123704032,"[local]",,2016-11-29 22:46:14 PST,1260,con72,cmd10,seg-1,,,x1260,sx1,"ERROR","XX000","Two or more external tables use the same error table ""err_ext_pdr_cdci_pivotal_request_43448"" in a statement (execMain.c:274)",,,,,,"select current_account_nbr,yearmonthint, bank_name, first_date_open, max_cr_limit, care_credit_flag, cc1_flag, partition_value, 'US' as loc from pdr_cdci_pivotal_request_43448 where care_credit_flag<1
> union
> select current_account_nbr,yearmonthint, bank_name, first_date_open, max_cr_limit, care_credit_flag, cc1_flag, partition_value, 'Non-US' as loc from pdr_cdci_pivotal_request_43448 where care_credit_flag=1;",0,,"execMain.c",274,"Stack trace:
> 1 0x8c5858 postgres errstart (??:0)
> 2 0x8c75db postgres elog_finish (??:0)
> 3 0x65f669 postgres <symbol not found> (??:0)
> 4 0x77d06a postgres walk_plan_node_fields (??:0)
> 5 0x77e3ee postgres plan_tree_walker (??:0)
> 6 0x77c70a postgres expression_tree_walker (??:0)
> 7 0x77e35d postgres plan_tree_walker (??:0)
> 8 0x77d06a postgres walk_plan_node_fields (??:0)
> 9 0x77dfe6 postgres plan_tree_walker (??:0)
> 10 0x77d06a postgres walk_plan_node_fields (??:0)
> 11 0x77e1e5 postgres plan_tree_walker (??:0)
> 12 0x77d06a postgres walk_plan_node_fields (??:0)
> 13 0x77dfe6 postgres plan_tree_walker (??:0)
> 14 0x77d06a postgres walk_plan_node_fields (??:0)
> 15 0x77e1e5 postgres plan_tree_walker (??:0)
> 16 0x66079b postgres ExecutorStart (??:0)
> 17 0x7ebf1d postgres PortalStart (??:0)
> 18 0x7e4288 postgres <symbol not found> (??:0)
> 19 0x7e54c2 postgres PostgresMain (??:0)
> 20 0x797d50 postgres <symbol not found> (??:0)
> 21 0x79ab19 postgres PostmasterMain (??:0)
> 22 0x4a4069 postgres main (??:0)
> 23 0x7fd97d486d5d libc.so.6 __libc_start_main (??:0)
> 24 0x4a40e9 postgres <symbol not found> (??:0)
> "
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)