Join stage error
Posted: Tue Jan 27, 2009 11:26 am
Hi All,
I am performing a left outer join with 3 links.
Link 1 --- left link
Link 2 --- intermediate link
Link 3 -- right link
The left link has the following combination
Col A Col B
a b
c d
Intermediate link
Col A Col B Value1
a b 1
Rigt Link
Col A Col B Value2
c d 2
a b 2
Output Required is
Col A Col B Value1 Value2
a b 1 2
c d 0 2
The Value 1 and Value 2 columns are outputs of aggregator stage.
I get the following fatal error and following output.
Col A Col B Value1 Value2
a b Null Null
c d 0 Null
Error is
APT_CombinedOperatorController(1),3: Un-handled conversion error on field "Value1 " from source type "dfloat" to destination type "int32":
source value="73"; the result is non-nullable and there is no handle_null to specify a default value. [api/interface_rep.C:1972]
Please advice.
Thanks
I am performing a left outer join with 3 links.
Link 1 --- left link
Link 2 --- intermediate link
Link 3 -- right link
The left link has the following combination
Col A Col B
a b
c d
Intermediate link
Col A Col B Value1
a b 1
Rigt Link
Col A Col B Value2
c d 2
a b 2
Output Required is
Col A Col B Value1 Value2
a b 1 2
c d 0 2
The Value 1 and Value 2 columns are outputs of aggregator stage.
I get the following fatal error and following output.
Col A Col B Value1 Value2
a b Null Null
c d 0 Null
Error is
APT_CombinedOperatorController(1),3: Un-handled conversion error on field "Value1 " from source type "dfloat" to destination type "int32":
source value="73"; the result is non-nullable and there is no handle_null to specify a default value. [api/interface_rep.C:1972]
Please advice.
Thanks