How to get the result of sqlPatchFilePath & sinkFilePath together

[Linuxdba]

Hi,

With MagicPlan, can I use the both rules in the same plan file?

  <property name="sqlPatchFilePath" value="./test18.sink_sql.diff" />

  <property name="sinkFilePath" value="./test18.sink.diff" />

When I run it, I got below error.

aused by: java.lang.RuntimeException: ambiguous rule set; found more than one rule to handle dependency->Dependency[DKPassthroughPlan(DKSink,sink_)]:[DKMagicPlanRule[fileSink], DKMagicPlanRule[sqlPatchSink]]
        at org.diffkit.diff.conf.DKMagicPlanBuilder.getRule(DKMagicPlanBuilder.java:167) [diffkit-app.jar:na]
        at org.diffkit.diff.conf.DKMagicPlanBuilder.resolve(DKMagicPlanBuilder.java:75) [diffkit-app.jar:na]
        at org.diffkit.diff.conf.DKMagicPlanBuilder.resolve(DKMagicPlanBuilder.java:99) [diffkit-app.jar:na]
        ... 11 common frames omitted

I was wondering if I can get the both result with just one run.

Thanks.

[Paulo Aurelio]

Hi Linuxdba,

Currentl, 

 this double configuration of the sinks kind in the same Plan, is not possible.

However, you will be able to use two differents execution plans, one for each kind of sink.

Cheers,

Paulo 

[Linuxdba]

Thanks for your update Paulo.

Yes, I think so. However, if the table size is huge, running 2 plan would take double time to get the result.
That's the thing.

Thanks again.