hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ming LI (JIRA)" <j...@apache.org>
Subject [jira] [Created] (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)"
Date Tue, 06 Dec 2016 11:11:26 GMT
Ming LI created HAWQ-1195:
-----------------------------

             Summary: 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: Lei Chang


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)

Mime
View raw message