Skip to content
This repository has been archived by the owner on Feb 21, 2024. It is now read-only.

Intersect incorrect? #114

Closed
tgruben opened this issue Sep 22, 2016 · 1 comment
Closed

Intersect incorrect? #114

tgruben opened this issue Sep 22, 2016 · 1 comment

Comments

@tgruben
Copy link
Member

tgruben commented Sep 22, 2016

Seems we broke something. The size of the intersect is larger than the smallest bitmap. This is from this dataset. You mind checking that out @benbjohnson

https://s3.amazonaws.com/pilosa.umbel.com/loader2/295/296-d.bits

$time curl -XPOST "http://localhost:15005/query?db=296" -d'Count(Bitmap(id=25803919,frame=d))' | python -m json.tool
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 53 100 19 100 34 3010 5386 --:--:-- --:--:-- --:--:-- 5666
{
"results": [
1982
]
}

real 0m0.034s
user 0m0.023s
sys 0m0.018s
[s]2016092214:29:35(Todds-Machine)(~/review/src/github.com/umbel/pilosa/cmd/pilosactl):master
$time curl -XPOST "http://localhost:15005/query?db=296" -d'Count(Bitmap(id=1345,frame=d))' | python -m json.tool
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 50 100 20 100 30 3216 4825 --:--:-- --:--:-- --:--:-- 6000
{
"results": [
24658
]
}

real 0m0.036s
user 0m0.024s
sys 0m0.019s
[s]2016092214:29:55(Todds-Machine)(~/review/src/github.com/umbel/pilosa/cmd/pilosactl):master
$time curl -XPOST "http://localhost:15005/query?db=296" -d'Count(Intersect(Bitmap(id=1345,frame=d),Bitmap(id=25803919,frame=d)))' | python -m json.tool
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 88 100 19 100 69 2976 10809 --:--:-- --:--:-- --:--:-- 11500
{
"results": [
3314
]
}

real 0m0.033s
user 0m0.023s
sys 0m0.018s

@benbjohnson
Copy link
Contributor

Hmm, that's not right. :) I'll take a look.

@tgruben tgruben closed this as completed Oct 17, 2016
tgruben pushed a commit to tgruben/pilosa that referenced this issue Sep 4, 2019
Sends PQL-Version to server; logs warnings from server; improved coverage
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants