You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Fucun Chu (Jira)" <ji...@apache.org> on 2021/03/02 12:38:00 UTC

[jira] [Updated] (IMPALA-10558) Implement ds_theta_exclude() function.

     [ https://issues.apache.org/jira/browse/IMPALA-10558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fucun Chu updated IMPALA-10558:
-------------------------------
    Description: 
This function receives two strings that are serialized Apache DataSketches Theta sketches. Computes the a-not-b set operation given two sketches of same or different column.

Example:
{code:sql}
select ds_theta_estimate(ds_theta_exclude(sketch1, sketch2)) from sketch_tbl;
+-------------------------------------------------------+
| ds_theta_estimate(ds_theta_exclude(sketch1, sketch2)) |
+-------------------------------------------------------+
| 5                                                     |
+-------------------------------------------------------+
{code}



  was:
This function receives two strings that are serialized Apache DataSketches Theta sketches. Computes the a-not-b set operation given two sketches of same or different column.

Example:
```
select ds_theta_estimate(ds_theta_exclude(sketch1, sketch2)) from sketch_tbl;
+-------------------------------------------------------+
| ds_theta_estimate(ds_theta_exclude(sketch1, sketch2)) |
+-------------------------------------------------------+
| 5                                                     |
+-------------------------------------------------------+
```



> Implement ds_theta_exclude() function.
> --------------------------------------
>
>                 Key: IMPALA-10558
>                 URL: https://issues.apache.org/jira/browse/IMPALA-10558
>             Project: IMPALA
>          Issue Type: New Feature
>          Components: Backend, Frontend
>            Reporter: Fucun Chu
>            Assignee: Fucun Chu
>            Priority: Major
>             Fix For: Impala 4.0
>
>
> This function receives two strings that are serialized Apache DataSketches Theta sketches. Computes the a-not-b set operation given two sketches of same or different column.
> Example:
> {code:sql}
> select ds_theta_estimate(ds_theta_exclude(sketch1, sketch2)) from sketch_tbl;
> +-------------------------------------------------------+
> | ds_theta_estimate(ds_theta_exclude(sketch1, sketch2)) |
> +-------------------------------------------------------+
> | 5                                                     |
> +-------------------------------------------------------+
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org