# tagsmanager

**Repository Path**: yahveyeye_admin/tagsmanager

## Basic Information

- **Project Name**: tagsmanager
- **Description**: 乱写的没啥用真的真的
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-08-15
- **Last Updated**: 2023-09-07

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

自定义标签：
  用户属性：等于，不等于，包含，不包含，有值，没有值，为空，不为空
  用户行为：做过，没做过
首末次特征：完成
行为分布结果：完成
基础指标值：完成
事件偏好属性：完成
- Swagger文档路径：http://localhost:8080/renren-fast/swagger/index.html
- Swagger注解路径：http://localhost:8080/renren-fast/swagger-ui.html


查询某个主体具有哪些标签
select tagname,tagvalue,datetime from labelinfo.label_tag_bitmap_all where bitmapContains(tagbitmap, toUInt64(id)) and subject = 'people'


划定特定人群
WITH (  SELECT tagbitmap from (select * from labelinfo.label_tag_bitmap_all where subject = 'ztk_ryztxxb') where tagvalue ='青年' ) AS tag1, 
( SELECT tagbitmap from (select * from labelinfo.label_tag_bitmap_all where subject = 'ztk_ryztxxb') where tagvalue ='境外旅游' ) AS tag2,
( SELECT tagbitmap from (select * from labelinfo.label_tag_bitmap_all where subject = 'ztk_ryztxxb') where tagvalue ='频繁出行' ) AS tag3, 
( SELECT tagbitmap from (select * from labelinfo.label_tag_bitmap_all where subject = 'ztk_ryztxxb') where tagvalue ='去往敏感地' ) AS tag4
select bitmapToArray(bitmapOr(bitmapAnd(tag1, tag2),bitmapAnd(tag3, tag4))) as customer