Cloud Pak for Data

 View Only
Expand all | Collapse all

Hash Partition Key issue in transform job

  • 1.  Hash Partition Key issue in transform job

    Posted Tue June 04, 2019 04:36 AM
    Hi All ,

    In transform job while using the Join or change capture stage , we are defining the hash partition on input links
    for joining key column . Also defining the key column for hash partition still we keep getting compiler error
    "There must be at least 1 keys selected for the current partition/collection method ".
    Have attached screen shot as well.
    can anybody guide us what we are missing here ?

    partitionkey column

    Thanks in advance for your help.

    ------------------------------
    Regards
    KETAN SHAH
    ------------------------------

    #CloudPakforDataGroup


  • 2.  RE: Hash Partition Key issue in transform job

    Posted Fri June 07, 2019 12:46 PM
    Hi Ketan, 

    I did some testing and of course, encountered the same issue. After poking around found a workaround. Here the step how I make it work.

    1) The following will fail just like yours when compile the job:

    2) Now turn off 'Perform Sort' but keep checked column and compile. will fail again.


    3) 
    you will see 'Perform Sort' automatically enabled. Then rechecked the KEY column and compile it again. 

    At this point, compile will be successful with HASH and Sort.

    I will open a defect for this behavior. 

    Thanks,


    ------------------------------
    Sanjit Chakraborty
    ------------------------------