安装

wget https://static.imply.io/release/imply-2.5.15.tar.gz
tar zxvf imply-2.5..tar.gz -C /usr/local/
cd imply-2.5.
nohup bin/supervise -c conf/supervise/quickstart.conf > quickstart.log &

查看启动日志

[root@localhost imply-2.5.]# tail -f quickstart.log
[Sat Jun :: ] Running command[zk], logging to[/usr/local/imply-2.5./var/sv/zk.log]: bin/run-zk conf-quickstart
[Sat Jun :: ] Running command[coordinator], logging to[/usr/local/imply-2.5./var/sv/coordinator.log]: bin/run-druid coordinator conf-quickstart
[Sat Jun :: ] Running command[broker], logging to[/usr/local/imply-2.5./var/sv/broker.log]: bin/run-druid broker conf-quickstart
[Sat Jun :: ] Running command[historical], logging to[/usr/local/imply-2.5./var/sv/historical.log]: bin/run-druid historical conf-quickstart
[Sat Jun :: ] Running command[overlord], logging to[/usr/local/imply-2.5./var/sv/overlord.log]: bin/run-druid overlord conf-quickstart
[Sat Jun :: ] Running command[middleManager], logging to[/usr/local/imply-2.5./var/sv/middleManager.log]: bin/run-druid middleManager conf-quickstart
[Sat Jun :: ] Running command[imply-ui], logging to[/usr/local/imply-2.5./var/sv/imply-ui.log]: bin/run-imply-ui-quickstart conf-quickstart

可见启动了如下服务

服务 简介 访问地址
zookeeper 分布式协调服务 ——
coordinator 协调节点,管理集群状态 http://localhost:8081/#/
broker 查询节点,处理查询请求 http://localhost:8082/druid/v2
historical 历史节点,管理历史数据 http://localhost:8083/druid/v2
overlord 统治节点,管理数据写入任务 http://localhost:8090/console.html
middleManager 中间管理者,负责写数据处理 ——
imply-ui 数据查询Web UI http://localhost:9095/datasets/

数据导入与查询

导入离线数据与查询

数据导入与查询

导入离线数据与查询

  • quickstart/wikipedia-2016-06-27-sampled.json文件包含了维基百科的一些日志数据(每行是一个JSON字符串)

  • quickstart/wikipedia-index.json文件为离线写入任务的描述文件,其用JSON格式描述了任务的数据源、时间信息、维度信息、指标信息等

将这些数据导入到Druid中

bin/post-index-task --file quickstart/wikipedia-index.json

可能会报“ImportError: No module named argparse”的错误,执行pip install argparse安装即可解决

bin/post-index-task --file quickstart/wikipedia-index.json
Beginning indexing data for wikipedia
Task started: index_wikipedia_2018--09T04::.580Z
Task log: http://localhost:8090/druid/indexer/v1/task/index_wikipedia_2018-06-09T04:03:26.580Z/log
Task status: http://localhost:8090/druid/indexer/v1/task/index_wikipedia_2018-06-09T04:03:26.580Z/status
Task index_wikipedia_2018--09T04::.580Z still running...
Task index_wikipedia_2018--09T04::.580Z still running...
Task finished with status: SUCCESS
Completed indexing data for wikipedia. Now loading indexed data onto the cluster...
wikipedia is 0.0% finished loading...
wikipedia loading complete! You may now query your data

查询数据

访问http://localhost:9095,可以查看当前数据集的概况和字段信息等

查询编辑次数TOP5的页面

方式一切到SQL标签,输入以下SQL

SELECT page, COUNT(*) AS Edits
FROM wikipedia
WHERE "__time" BETWEEN TIMESTAMP '2016-06-27 00:00:00' AND TIMESTAMP '2016-06-28 00:00:00'
GROUP BY page
ORDER BY Edits
DESC LIMIT 5

方式二直接通过CURL查询

quickstart/wikipedia-top-pages.json中定了查询的JSON文件

curl -X 'POST' -H 'Content-Type:application/json' -d @quickstart/wikipedia-top-pages.json http://localhost:8082/druid/v2?pretty

返回

[ {
"timestamp" : "2016-06-27T00:00:11.080Z",
"result" : [ {
"count" : 29,
"page" : "Copa América Centenario"
}, {
"count" : 16,
"page" : "User:Cyde/List of candidates for speedy deletion/Subpage"
}, {
"count" : 16,
"page" : "Wikipedia:Administrators' noticeboard/Incidents"
}, {
"count" : 15,
"page" : "2016 Wimbledon Championships – Men's Singles"
}, {
"count" : 15,
"page" : "Wikipedia:Administrator intervention against vandalism"
} ]
} ]

实时导入与查询

发送数据

bin/generate-example-metrics可以产生一些随机的样例metric,运行下面的语句

[root@localhost imply]# bin/generate-example-metrics | curl -XPOST -H'Content-Type: application/json' --data-binary @-
http://localhost:8200/v1/post/tutorial-tranquility-server

返回结果如下

{"result":{"received":,"sent":}}

最新文章

  1. C++智能指针
  2. 将java的class文件放到一个指定文件夹下
  3. .NET设计模式(8):适配器模式(Adapter Pattern)(转)
  4. samsung-smart app 开发
  5. python 面向对象深入理解
  6. iOS中 UITableViewCell cell划线那些事 韩俊强的博客
  7. Can't create/write to file '/tmp/MLjnvU95' (Errcode: 13 - Permission denied)
  8. vue环境项目启动后因为eslint语法限制报错
  9. [基础篇] 01_MySQL的安装与配置
  10. thinkphp 实现分页
  11. linux中tomcat修改错误日志路径
  12. linux nfs服务配置挂载以及oracle使用nfs存储挂载注意事项
  13. js 异步加载
  14. rabbitmq系列五 之主题交换机
  15. docker学习笔记 参考
  16. 增加图例 Legend和删除图例
  17. JavaSE日常笔记汇总
  18. TP关联模型
  19. ebay商品基本属性组合成数据表格式,可用上传到系统递交数据
  20. 从后台读取项目文件在前端iframe中展示

热门文章

  1. GridView 控制默认分页页码间距 及字体大小
  2. 初识jQuery(1)
  3. flowable DmnEngine和DmnEngineConfiguration
  4. JDK1.7之 HashMap 源码分析
  5. postgresql与Oracle:空字符串与null
  6. HDU 1374
  7. webpack 实现自动刷新,复制文件,实现开发环境和发布环境
  8. Java [Leetcode 384]Shuffle an Array
  9. BZOJ2131 免费的馅饼【线段树优化DP】
  10. Atocder ARC082 F-Sandglass 【思维题】*