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)
