使用sql、pandas和快捷方式进行高效的无sql数据源探索
mgocli的Python项目详细描述
#数据cli
>;使用sql、panda和
>;快捷方式进行高效的无sql数据源探索
[构建状态](https://travis-ci.org/hackliff/mgocli.svg?branch=master)(https://travis-ci.org/hackliff/mgocli)
quay.io/hackliff/drill[![码头上的Docker Repository](https://quay.io/repository/hackliff/drill/status“码头上的Docker Repository”)(https://quay.io/repository/hackliff/drill)
入门
`make container.build`将启动并初始化[MongoDB]),[drill](
和“datacli”,安装了所有组件。
仍然可以注册外部数据源:
``bash
$cp./tools/drill/mongo-storage-plugin.json自定义存储。json
$$editor自定义存储。json
$./tools/drill/manage.sh存储。/自定义存储。json http://$(docker machine ip默认值:8047
{
“result”:“success”
>
````
````````
`` bash
$./datacli ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `>[datacli::192.168.99.100::appturbo]>;>;显示数据库
[2016-07-06 06:38:48,datacli::info-发送查询到drill的查询
[显示数据库]
schema\u-name
0信息架构
1-cp。默认
>2-dfs。默认
>3-dfs。根
>4-dfs。tmp
`` `
`
` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `_钻_1//apache-drill-1.7.0/bin/drill localhost
0:jdbc:drill:drill:drill:drillbit=localhost>;show databases;
+--
>>
+--
>
>信息架构;
>
nosqltest.local
nosqltest.test
sys
+————+——+
选择9行(0.244秒)
0:jdbc:drill:drillbit=localhost>;从nosqltest.test.zips
限制3;
+————+————————+——————————————————————————————————————————————————————|Pop Pop Pop Pop 72.108354,42.409698]4546 ma
+——————————————————————————————————————————————————————————————————————————————————————————————————————退出
```
>;使用sql、panda和
>;快捷方式进行高效的无sql数据源探索
[构建状态](https://travis-ci.org/hackliff/mgocli.svg?branch=master)(https://travis-ci.org/hackliff/mgocli)
quay.io/hackliff/drill[![码头上的Docker Repository](https://quay.io/repository/hackliff/drill/status“码头上的Docker Repository”)(https://quay.io/repository/hackliff/drill)
入门
`make container.build`将启动并初始化[MongoDB]),[drill](
和“datacli”,安装了所有组件。
仍然可以注册外部数据源:
``bash
$cp./tools/drill/mongo-storage-plugin.json自定义存储。json
$$editor自定义存储。json
$./tools/drill/manage.sh存储。/自定义存储。json http://$(docker machine ip默认值:8047
{
“result”:“success”
>
````
````````
`` bash
$./datacli ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `>[datacli::192.168.99.100::appturbo]>;>;显示数据库
[2016-07-06 06:38:48,datacli::info-发送查询到drill的查询
[显示数据库]
schema\u-name
0信息架构
1-cp。默认
>2-dfs。默认
>3-dfs。根
>4-dfs。tmp
`` `
`
` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `_钻_1//apache-drill-1.7.0/bin/drill localhost
0:jdbc:drill:drill:drill:drillbit=localhost>;show databases;
+--
>>
+--
>
>信息架构;
>
nosqltest.test
sys
+————+——+
选择9行(0.244秒)
0:jdbc:drill:drillbit=localhost>;从nosqltest.test.zips
限制3;
+————+————————+——————————————————————————————————————————————————————|Pop Pop Pop Pop 72.108354,42.409698]4546 ma
+——————————————————————————————————————————————————————————————————————————————————————————————————————退出
```