You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@griffin.apache.org by secfree teng <se...@gmail.com> on 2019/04/23 02:55:05 UTC

How to compare the count of two data sources?

Hi all,

I want to compare the count of two tables based on some conditions. But

   - “Accuracy” does not support calculating the count
   - “Profiling” does not support comparison

Any recommendations?

Thank you.

Re: How to compare the count of two data sources?

Posted by Nick Sokolov <ch...@gmail.com>.
One way to do this would be to run two profiling steps in single measure,
register results using out.dataframe.name, and then do custom spark-sql DSL
rule to compare results from previous steps. It's not possible to create
such a measure using UI wizards, but it's possible to express that in
measure JSON.

On Mon, Apr 22, 2019, 19:55 secfree teng <se...@gmail.com> wrote:

> Hi all,
>
> I want to compare the count of two tables based on some conditions. But
>
>    - “Accuracy” does not support calculating the count
>    - “Profiling” does not support comparison
>
> Any recommendations?
>
> Thank you.
>
>