You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datasketches.apache.org by GitBox <gi...@apache.org> on 2021/01/26 03:00:51 UTC
[GitHub] [datasketches-postgresql] chongdae opened a new issue #34: set intersection is not working for aggregation
chongdae opened a new issue #34:
URL: https://github.com/apache/datasketches-postgresql/issues/34
`theta_sketch_union` is working well.
```
with d1 as (
select id, theta_sketch_build(val) sketch
from (values (1, 1), (1, 2), (1, 3), (2, 2), (2, 3), (2, 4)) as t(id, val)
group by id
)
select
theta_sketch_get_estimate(theta_sketch_union(sketch)) agg
from d1
;
```
But `theta_sketch_intersection` is not working.
```
with d1 as (
select id, theta_sketch_build(val) sketch
from (values (1, 1), (1, 2), (1, 3), (2, 2), (2, 3), (2, 4)) as t(id, val)
group by id
)
select
theta_sketch_get_estimate(theta_sketch_intersection(sketch)) agg
from d1
;
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] chongdae closed issue #34: set intersection is not working for aggregation
Posted by GitBox <gi...@apache.org>.
chongdae closed issue #34:
URL: https://github.com/apache/datasketches-postgresql/issues/34
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] AlexanderSaydakov commented on issue #34: set intersection is not working for aggregation
Posted by GitBox <gi...@apache.org>.
AlexanderSaydakov commented on issue #34:
URL: https://github.com/apache/datasketches-postgresql/issues/34#issuecomment-768458793
Is it acceptable for you to build from the master?
Perhaps we could do 1.3.1 maintenance release, but we graduated, and I don't quite like the idea of releasing from this old branch which still has incubator tags. And the next big release is not quite ready. We are still working on a couple of things in the core library.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] chongdae commented on issue #34: set intersection is not working for aggregation
Posted by GitBox <gi...@apache.org>.
chongdae commented on issue #34:
URL: https://github.com/apache/datasketches-postgresql/issues/34#issuecomment-767979411
I'm using "PostgreSQL 11.7 (EnterpriseDB Advanced Server 11.7.14)"
and daasketches-postgresql 1.3.0 stable release from https://pgxn.org/dist/datasketches/ .
First query returns "4", but second query returns error message:
```
SQL Error [42883]: ERROR: function theta_sketch_intersection(theta_sketch) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 182
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] AlexanderSaydakov commented on issue #34: set intersection is not working for aggregation
Posted by GitBox <gi...@apache.org>.
AlexanderSaydakov commented on issue #34:
URL: https://github.com/apache/datasketches-postgresql/issues/34#issuecomment-767747675
What result are you getting? What version of PostgreSQL and datasketches-postgresql are you running?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org
[GitHub] [datasketches-postgresql] AlexanderSaydakov commented on issue #34: set intersection is not working for aggregation
Posted by GitBox <gi...@apache.org>.
AlexanderSaydakov commented on issue #34:
URL: https://github.com/apache/datasketches-postgresql/issues/34#issuecomment-768017751
I see, this was fixed by #26, and we did not have a release after that
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org