I'm using clickhouse 20.12.3.3 version. 
The execution of sumIf() function is failing on the distributed table
Query:
`SELECT sumIf(pos_sales,isNotNull (pos_sales)) , fin_seg_desc AS SBU　from stores_cost_position_dist　where ((week between 201945 AND 202043)) group by fin_seg_desc;
`

Fails with:
`Code: 42. DB::Exception: Received from localhost:9000. DB::Exception: Aggregate function sum requires single argument: while receiving packet from node-2:9000: While executing Remote. 
`

Data types:
`pos_sales: Nullable(Float64),
week: Int32,
fin_seg_desc: String
`
The same query is working on the local table.

}
        else
        {
            if (serialize_flag)
                return std::make_shared<AggregateFunctionIfNullUnary<false, true>>(nested_func, arguments, params);
            else
                return std::make_shared<AggregateFunctionIfNullUnary<false, false>>(nested_func, arguments, params);
        }
    }
    else
    {
        if (return_type_is_nullable)
        {
            return std::make_shared<AggregateFunctionIfNullVariadic<true, true, true>>(nested_function, arguments, params);
        }
        else
        {
            if (serialize_flag)
                return std::make_shared<AggregateFunctionIfNullVariadic<false, true, true>>(nested_function, arguments, params);
            else
                return std::make_shared<AggregateFunctionIfNullVariadic<false, false, true>>(nested_function, arguments, params);
        }
    }
}
void registerAggregateFunctionCombinatorIf(AggregateFunctionCombinatorFactory & factory)
{
    factory.registerCombinator(std::make_shared<AggregateFunctionCombinatorIf>());
}
}