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.
Non-aggregate component in select
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
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.
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.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
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
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.