Partition read from DB2 table
Posted: Mon May 20, 2013 11:23 am
I am using a DB2 connector for extraction data from a large DB2 table. If I use partition read and set generate sql(for partition read) to No then the query looks like the following:
SELECT COL1,COL2,COL3 FROM SCHEMA.TABLE WHERE NODENUMBER(COL2)=CURRENT NODE.
Considering COL1,COL2 composite primary key and COL2 is the distribution key.
Now if I set generate sql(for partition read) to Yes then what will be the column in the following sql in place of partion_col
SELECT COL1,COL2,COL3 FROM SCHEMA.TABLE WHERE NODENUMBER(partition_col)=CURRENT NODE.
SELECT COL1,COL2,COL3 FROM SCHEMA.TABLE WHERE NODENUMBER(COL2)=CURRENT NODE.
Considering COL1,COL2 composite primary key and COL2 is the distribution key.
Now if I set generate sql(for partition read) to Yes then what will be the column in the following sql in place of partion_col
SELECT COL1,COL2,COL3 FROM SCHEMA.TABLE WHERE NODENUMBER(partition_col)=CURRENT NODE.