You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/10/19 06:21:04 UTC
[GitHub] [incubator-doris] liu391447823 opened a new issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
liu391447823 opened a new issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Description
1. bitmapSubsetInRange
bitmapSubsetInRange(bitmap, range_start, range_end)
参数：
bitmap – 位图对象.
range_start – 范围起始点（含）.
range_end – 范围结束点（不含）
2. bitmapSubsetLimit
bitmapSubsetLimit(bitmap, range_start, limit)
参数：
bitmap – 位图对象.
range_start – 范围起始点（含）.
limit – 子位图基数上限
3. subBitmap
subBitmap(bitmap, offset, limit)
参数：
bitmap – 位图对象.
offset – 跳过多少个元素.
limit – 子位图基数上限
### Use case
需求：
我们有一个系统是基于用户画像的推送系统，根据用户画像的标签构建用户群组bitmap，然后根据构建的bitmap导出用户id，
基于用户id去做推送。
遇到的问题：
目前遇到的问题是，当构建的bitmap数据量比较大时（比如达到百万级别的基数），我们无法通过bitmap_to_string函数导出
所有的用户id，所以我们想的办法是通过分页的方式，每次构建子bitmap，然后将子bitmap进行导出
### Related issues
#bit
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 edited a comment on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 edited a comment on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-946741735
1.bitmapSubsetLimit
Creates a subset of bitmap with n elements taken between range_start and cardinality_limit.
Syntax
`bitmapSubsetLimit(bitmap, range_start, cardinality_limit)`
Arguments
- bitmap – Bitmap object.
- range_start – The subset starting point.
- cardinality_limit – The subset cardinality upper limit.
Returned value
The subset.
Example
Query:
`SELECT bitmapToArray(bitmapSubsetLimit(bitmapBuild([0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,100,200,500]), toUInt32(30), toUInt32(200))) AS res;`
Result:
`┌─res───────────────────────┐
│ [30,31,32,33,100,200,500] │
└──────────────────────── ─┘
`
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-946747946
The following is the bitmap function documentation for Clickhouse
[https://clickhouse.com/docs/en/sql-reference/functions/bitmap-functions/](url)
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] EmmyMiao87 edited a comment on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 edited a comment on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947271186
If the bitmap is too large, ```to_string``` does have a problem.
A temporary solution is to use ```select into file``` to export the query results to a file.
However, this method is not directly obtained by segmentation. So I very much support the addition of this similar function.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] EmmyMiao87 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947271186
If the bitmap is too large, ```to_string``` does have a problem.
A temporary solution is to use select into file to export the query results to a file.
However, this method is not directly obtained by segmentation. So I very much support the addition of this similar function.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947271384
> > > Coming soon
> >
> >
> > Will it be released in version 0.15？
>
> Yes, maybe in 0.15.x
When was 0.15 officially released? Yesterday's attempt to compile 0.15 failed
My compilation script is as follows:
docker run -it -v /Users/liujinliang/.m2:/root/.m2 -v /Users/liujinliang/doris-src/incubator-doris-branch-0.15/:/root/doris-0.15/ apache/incubator-doris:build-env-1.4.0
cd doris-0.15
sh build.sh
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] wentaotang0 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
wentaotang0 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947245352
I also hope to support more bitmap functions with the same functions as Clickhouse！
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947269217
There are also bitmapmax and bitmapandnot functions
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947260222
Coming soon
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] EmmyMiao87 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947272436
> There are also bitmapmax and bitmapandnot functions
I can implement bitmapmax and min functions. Please assign to me.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] EmmyMiao87 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947275204
> > > > > > Coming soon
> > > > >
> > > > >
> > > > > Will it be released in version 0.15？
> > > >
> > > >
> > > > Yes, maybe in 0.15.x
> > >
> > >
> > > When was 0.15 officially released? Yesterday's attempt to compile 0.15 failed
> > > 
> > > My compilation script is as follows: docker run -it -v /Users/liujinliang/.m2:/root/.m2 -v /Users/liujinliang/doris-src/incubator-doris-branch-0.15/:/root/doris-0.15/ apache/incubator-doris:build-env-1.4.0 cd doris-0.15 sh build.sh
> >
> >
> > You need to update your docker image
>
> The latest image version I found in docker hub is 1.4.0. I think the latest version in the official document is 1.4.1, but I can't get 1.4.1 from anywhere
@yangzhg
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-946741735
1.bitmapSubsetLimit
Creates a subset of bitmap with n elements taken between range_start and cardinality_limit.
Syntax
`bitmapSubsetLimit(bitmap, range_start, cardinality_limit)`
Arguments
- bitmap – Bitmap object.
- range_start – The subset starting point. Type: UInt32.
- cardinality_limit – The subset cardinality upper limit. Type: UInt32.
Returned value
The subset.
Example
Query:
`SELECT bitmapToArray(bitmapSubsetLimit(bitmapBuild([0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,100,200,500]), toUInt32(30), toUInt32(200))) AS res;`
Result:
`┌─res───────────────────────┐
│ [30,31,32,33,100,200,500] │
└───────────────────────────┘
`
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 edited a comment on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 edited a comment on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-946741735
1.bitmapSubsetLimit
Creates a subset of bitmap with n elements taken between range_start and cardinality_limit.
Syntax
`bitmapSubsetLimit(bitmap, range_start, cardinality_limit)`
Arguments
- bitmap – Bitmap object.
- range_start – The subset starting point.
- cardinality_limit – The subset cardinality upper limit.
Returned value
The subset.
Example
Query:
`SELECT bitmapToArray(bitmapSubsetLimit(bitmapBuild([0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,100,200,500]), toUInt32(30), toUInt32(200))) AS res;`
Result:
┌─res───────────────────────┐
│ [30,31,32,33,100,200,500] │
└─────────────────────────┘
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 edited a comment on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 edited a comment on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-946741735
1.bitmapSubsetLimit
Creates a subset of bitmap with n elements taken between range_start and cardinality_limit.
Syntax
`bitmapSubsetLimit(bitmap, range_start, cardinality_limit)`
Arguments
- bitmap – Bitmap object.
- range_start – The subset starting point.
- cardinality_limit – The subset cardinality upper limit.
Returned value
The subset.
Example
Query:
`SELECT bitmapToArray(bitmapSubsetLimit(bitmapBuild([0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,100,200,500]), toUInt32(30), toUInt32(200))) AS res;`
Result:
`┌─res───────────────────────┐
│ [30,31,32,33,100,200,500] │
└───────────────────────────┘
`
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] EmmyMiao87 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
EmmyMiao87 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947271734
> > > > Coming soon
> > >
> > >
> > > Will it be released in version 0.15？
> >
> >
> > Yes, maybe in 0.15.x
>
> When was 0.15 officially released? Yesterday's attempt to compile 0.15 failed
>
> 
>
> My compilation script is as follows: docker run -it -v /Users/liujinliang/.m2:/root/.m2 -v /Users/liujinliang/doris-src/incubator-doris-branch-0.15/:/root/doris-0.15/ apache/incubator-doris:build-env-1.4.0 cd doris-0.15 sh build.sh
You need to update your docker image
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947288903
> > The latest image version I found in docker hub is 1.4.0. I think the latest version in the official document is 1.4.1, but I can't get 1.4.1 from anywhere
>
> We are currently upgrading some dependencies of Doris. the 1.4.1 image is not ready yet. It will be pushed this week.
Great, look forward to it
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947268502
> > Coming soon
>
> Will it be released in version 0.15？
Yes, maybe in 0.15.x
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947272738
> > > > > Coming soon
> > > >
> > > >
> > > > Will it be released in version 0.15？
> > >
> > >
> > > Yes, maybe in 0.15.x
> >
> >
> > When was 0.15 officially released? Yesterday's attempt to compile 0.15 failed
> > 
> > My compilation script is as follows: docker run -it -v /Users/liujinliang/.m2:/root/.m2 -v /Users/liujinliang/doris-src/incubator-doris-branch-0.15/:/root/doris-0.15/ apache/incubator-doris:build-env-1.4.0 cd doris-0.15 sh build.sh
>
> You need to update your docker image
The latest image version I found in docker hub is 1.4.0. I think the latest version in the official document is 1.4.1, but I can't get 1.4.1 from anywhere
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-946443445
What is different of `bitmapSubsetLimit` and `subBitmap` ?
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman closed issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
morningman closed issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-946744991
2.subBitmap
Returns the bitmap elements, starting from the offset position. The number of returned elements is limited by the cardinality_limit parameter. Analog of the substring) string function, but for bitmap.
Syntax
`subBitmap(bitmap, offset, cardinality_limit)`
Arguments
- bitmap – The bitmap. Type: Bitmap object
- offset – The position of the first element of the subset.
- cardinality_limit – The maximum number of elements in the subset.
Example
Query:
`SELECT bitmapToArray(subBitmap(bitmapBuild([0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,100,200,500]), toUInt32(10), toUInt32(10))) AS res;`
Result:
┌─res─────────────────────────────┐
│ [10,11,12,13,14,15,16,17,18,19] │
└─────────────────────────────────┘
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947267837
> Coming soon
Will it be released in version 0.15？
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947274385
> > There are also bitmapmax and bitmapandnot functions
>
> I can implement bitmapmax and min functions. Please assign to me.
How should I assign it to you
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 edited a comment on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 edited a comment on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-946744991
2.subBitmap
Returns the bitmap elements, starting from the offset position. The number of returned elements is limited by the cardinality_limit parameter. Analog of the substring) string function, but for bitmap.
Syntax
`subBitmap(bitmap, offset, cardinality_limit)`
Arguments
- bitmap – The bitmap. Type: Bitmap object
- offset – The position of the first element of the subset.
- cardinality_limit – The maximum number of elements in the subset.
Example
Query:
`SELECT bitmapToArray(subBitmap(bitmapBuild([0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,100,200,500]), toUInt32(10), toUInt32(10))) AS res;`
Result:
┌─res──────────────────────────── ─┐
│ [10,11,12,13,14,15,16,17,18,19] │
└─────────────────────────────── ┘
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-950327843
Great, who can help me implement bitmap_ Max function
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947288125
> The latest image version I found in docker hub is 1.4.0. I think the latest version in the official document is 1.4.1, but I can't get 1.4.1 from anywhere
We are currently upgrading some dependencies of Doris. the 1.4.1 image is not ready yet. It will be pushed this week.
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] lipeng562837199 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
lipeng562837199 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947249308
I'm hoping so eagerly that there are more support for bitmap functions!
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] liu391447823 commented on issue #6875: [Feature] I hope to support more bitmap functions with the same functions as Clickhouse
Posted by GitBox <gi...@apache.org>.
liu391447823 commented on issue #6875:
URL: https://github.com/apache/incubator-doris/issues/6875#issuecomment-947275149
> > > There are also bitmapmax and bitmapandnot functions
> >
> >
> > I can implement bitmapmax and min functions. Please assign to me.
>
> How should I assign it to you
Thank you
--
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.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org