How to get the result of sqlPatchFilePath & sinkFilePath together

33 views
Skip to first unread message

Linuxdba

unread,
Nov 12, 2015, 7:47:47 AM11/12/15
to diffkit-user
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

unread,
Nov 16, 2015, 7:10:55 AM11/16/15
to diffkit-user
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

unread,
Nov 16, 2015, 10:21:05 PM11/16/15
to diffkit-user
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.
Reply all
Reply to author
Forward
0 new messages