You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:18:15 UTC
[jira] [Created] (TRAFODION-805) LP Bug: 1398981 - unload with
union query fails with ERROR[4066]
Alice Chen created TRAFODION-805:
------------------------------------
Summary: LP Bug: 1398981 - unload with union query fails with ERROR[4066]
Key: TRAFODION-805
URL: https://issues.apache.org/jira/browse/TRAFODION-805
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Julie Thai
Assignee: Apache Trafodion
On cluster with build 20141126_0830:
SQL>unload with purgedata from target
into '/bulkload/QA_unload_tests/loc_queries'
select ps_partkey, ps_suppkey, ps_availqty, ps_supplycost, ps_comment
from g_tpch2x.partsupp where ps_partkey < 90000
UNION
select ps_partkey, ps_suppkey, ps_availqty, ps_supplycost, ps_comment
from g_tpch2x.partsupp where ps_partkey between 180000 and 200000;
*** ERROR[4066] The operands of a UNION must be of equal degree. [2014-12-03 12:26:00]
Assigned to LaunchPad User khaled Bouaziz
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)