Non-aggregate component in select

bikan · Post by **bikan** » Fri Oct 27, 2006 12:32 am

hi,

I'm using a Join stage with 4 sequential files as inputs. Using Inner Join on a dummy key(integer(1)). However, the job fails at runtime throwing the following error:

Non-aggregate component in select:dummy.col1

Col1 is an integer(1) nullable field from one of the files.

Kindly help...
Thanks.

Nageshsunkoji · Post by **Nageshsunkoji** » Fri Oct 27, 2006 2:29 am

Hi,

Are you sure about, dummy column is present in all four input sequential files and check the nullability of Dummy Col in all four input files. Nullability should be same in all 4 input columns.

bikan · Post by **bikan** » Fri Oct 27, 2006 6:02 am

The issue is resolved. The problem was with the Metadata...
Metadata was imported from a CFD and it had levels. On removing the levels it worked fine.
Thanks

Nageshsunkoji wrote:Hi,

Are you sure about, dummy column is present in all four input sequential files and check the nullability of Dummy Col in all four input files. Nullability should be same in all 4 input columns.