|NO.Z.00012|——————————|BigDataEnd|——|Hadoop&OLAP_Druid.V12|——|Druid.v12|实战|Druid实战案例.V1|

一、需求分析

### --- 场景分析

~~~     数据量大，需要在这些数据中根据业务需要灵活做查询
~~~     实时性要求高
~~~     数据实时的推过来，要在秒级对数据进行分析并查询出结果

二、数据分析

### --- 数据描述

~~~     # 数据json串
{"ts":1607499629841,"orderId":"1009388","userId":"807134","orderStatusId":1,
"orderStatus":"已支付","payModeId":0,"payMode":"微信","payment":"933.90","products":
[{"productId":"102163","productName":"贝合xxx+粉","price":18.7,"productNum":3,
"categoryid":"10360","catname1":"厨卫清洁、纸制用品","catname2":"生活日用","catname3":
"浴室用品"},{"productId":"100349","productName":"COxxx0C","price":877.8,"productNum":1,
"categoryid":"10302","catname1":"母婴、玩具乐器","catname2":"西洋弦乐器","catname3":
"吉他"}]}

~~~     # json串：实验环境数据(和上面数据一致)

{"ts":1607499629841,"orderId":"1009388","userId":"807134","orderStatusId":1,"orderStatus":"已支付","payModeId":0,"payMode":"微信","payment":"933.90","products":[{"productId":"102163","productName":"贝合xxx+粉","price":18.7,"productNum":3,"categoryid":"10360","catname1":"厨卫清洁、纸制用品","catname2":"生活日用","catname3":"浴室用品"},{"productId":"100349","productName":"COxxx0C","price":877.8,"productNum":1,"categoryid":"10302","catname1":"母婴、玩具乐器","catname2":"西洋弦乐器","catname3":"吉他"}]}

### --- 参数分析说明
~~~     ts：交易时间
~~~     orderId：订单编号
~~~     userId：用户id
~~~     orderStatusId：订单状态id
~~~     orderStatus：订单状态

~~~     # 0-11：未支付,已支付,发货中,已发货,发货失败,已退款,
~~~     # 已关单,订单过期,订单已失效,产品已失效,代付拒绝,支付中

~~~     payModeId：支付方式id
~~~     payMode：支付方式

~~~     # 0-6：微信,支付宝,信用卡,银联,货到付款,现金,其他

~~~     payment：支付金额
~~~     products：购买商品

~~~     # 备注：一个订单可能包含多个商品，这里是一个嵌套结构

~~~     productId：商品id
~~~     productName：商品名称
~~~     price：单价
~~~     productNum：购买数量
~~~     categoryid：商品分类id
~~~     catname1：商品一级分类名称
~~~     catname2：商品二级分类名称
~~~     catname3：商品三级分类名称

三、处理数据

### --- 以上的嵌套的json数据格式，Druid不好处理，需要对数据进行预处理，将数据拉平，处理后的数据格式：

{"ts":1607499629841,"orderId":"1009388","userId":"807134","orderStatusId":1,
"orderStatus":"已支付","payModeId":0,"payMode":"微信","payment":"933.90","product":
{"productId":"102163","productName":"贝合xxx+粉","price":18.7,"productNum":3,
"categoryid":"10360","catname1":"厨卫清洁、纸制用品","catname2":"生活日用",
"catname3":"浴室用品"}}

{"ts":1607499629841,"orderId":"1009388","userId":"807134","orderStatusId":1,
"orderStatus":"已支付","payModeId":0,"payMode":"微信","payment":"933.90","product":
{"productId":"100349","productName":"COxxx0C","price":877.8,"productNum":1,
"categoryid":"10302","catname1":"母婴、玩具乐器","catname2":"西洋弦乐器","catname3":
"吉他"}}

### --- 实验数据(和上面一致)

{"ts":1607499629841,"orderId":"1009388","userId":"807134","orderStatusId":1,"orderStatus":"已支付","payModeId":0,"payMode":"微信","payment":"933.90","product":{"productId":"102163","productName":"贝合xxx+粉","price":18.7,"productNum":3,"categoryid":"10360","catname1":"厨卫清洁、纸制用品","catname2":"生活日用","catname3":"浴室用品"}}

{"ts":1607499629841,"orderId":"1009388","userId":"807134","orderStatusId":1,"orderStatus":"已支付","payModeId":0,"payMode":"微信","payment":"933.90","product":{"productId":"100349","productName":"COxxx0C","price":877.8,"productNum":1,"categoryid":"10302","catname1":"母婴、玩具乐器","catname2":"西洋弦乐器","catname3":"吉他"}}

---

 

 

 

 

 

 

 

 

 

---

Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of life.It sinks, and I am ready to depart

                                                                                                                                                   ——W.S.Landor

---