PI58443: AMBIGUOUS COLUMN ERROR IN BIGSQL LOAD HADOOP STATEMENT.

APAR status

• Closed as program error.

Error description

• Create tables that have same column names. Load the data from
  table to other using BigSQL Load statement. In the load, use
  SPLIT COLUMN clause that refer to the column.
  
  Reproduction Steps:
  
  1) Create three Hadoop tables
  
     create hadoop table htab1(id integer, name varchar(20));
     create hadoop table htab2(id integer, name varchar(20));
     create hadoop table htab3(id integer, name varchar(20));
  
  2) Load data into two tables
  
     insert into htab1 values(1,'Antony');
     insert into htab1 values(1,'Tom');
     insert into htab2 values(1,'Paul');
  
  3) Now load data into third table
  
  LOAD HADOOP USING JDBC CONNECTION URL
  'jdbc:db2://99.99.99.99:32051/bigsql' WITH PARAMETERS
  ('user'='bigsql','password'='bigsql99') FROM SQL QUERY 'select
  t1.id,t1.name from bigsql.htab1 t1, bigsql.htab2 t2 where
  t1.id=t2.id and $CONDITIONS' split column t1.id into table
  bigsql.htab3 APPEND WITH LOAD
  PROPERTIES('num.map.tasks'=2,'max.rejected.records'=10,'rejected
  .records.dir'='/tmp/reject_record/stg_app_cln');
  
  Error Details:
  
  Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: A
  reference to column "ID" is ambiguous.. SQLCODE=-203,
  SQLSTATE=42702, DRIVER=4.20.4 at
  com.ibm.db2.jcc.am.kd.a(Unknown Source) at
  com.ibm.db2.jcc.am.kd.a(Unknown Source) at
  com.ibm.db2.jcc.am.kd.a(Unknown Source)
  

Local fix

• N/a
  

Problem summary

• See error description.
  

Problem conclusion

• The problem is fixed in Version 4.1.0.2 and later fix packs.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• Unknown
  

Fix information

• Fixed component name

  INFO BIGINSIGHT

• Fixed component ID

  5725C0900

Applicable component levels

• R410 PSY

     UP