今天测了一下 mongodb BI connector 2.1官网下载的
mongodb 3.2.2
生成drdl文件没问题,第二部运行代理服务时就有警告了
用mysql 客户端工具 连接成功, 然后连接查询表时就错误,坑爹呀!
Microsoft Windows [版本 10.0.14393]
(c) 2016 Microsoft Corporation。保留所有权利。
C:\Windows\system32>mongodrdl –host 10.xxx.xxx.100 -d ab9fd8f1-33d3-11e7-8297-00163e020112 -c E_hoister -o mydrdl.drdl -u 6d6dd9520aa5788970
‘mongodrdl’ 不是内部或外部命令,也不是可运行的程序
或批处理文件。
C:\Windows\system32>cd/d D:\_software\mongodb-bi-win32-x86_64-v2.1.0\bin
D:\_software\mongodb-bi-win32-x86_64-v2.1.0\bin>mongodrdl –host 10.xxx.xxx.100 -d ab9fd8f1-33d3-11e7-8297-00163e020112 -c E_hoister -o mydrdl.drdl -u 6d6dd9520aa5788970fa8587ea571edb -p b6e7cd527b6ff1187285b4a82a1a3019
D:\_software\mongodb-bi-win32-x86_64-v2.1.0\bin>mongosqld –mongo-uri=mongodb://10.xxx.xxx.100:27017 –schema mydrdl.drdl
2017-05-22T18:32:02.473+0800 I CONTROL [initandlisten] mongosqld version: v2.1.0
2017-05-22T18:32:02.482+0800 I CONTROL [initandlisten] git version: 518180ba2c547d2cc6071f955d98ec6de730c0c9
2017-05-22T18:32:02.482+0800 I CONTROL [initandlisten] arguments: –mongo-uri mongodb://10.xxx.xxx.100:27017 –schema mydrdl.drdl
2017-05-22T18:32:02.482+0800 I CONTROL [initandlisten] ** WARNING: Access control is not enabled for mongosqld.
2017-05-22T18:32:02.483+0800 I CONTROL [initandlisten]
2017-05-22T18:32:02.492+0800 I NETWORK [initandlisten] connecting to mongodb at mongodb://10.xxx.xxx.100:27017
2017-05-22T18:32:02.492+0800 I NETWORK [initandlisten] waiting for connections at 127.0.0.1:3307
2017-05-22T18:32:23.044+0800 I NETWORK [conn1] connection accepted from 127.0.0.1:3890 #1 (1 connection now open)
2017-05-22T18:32:26.298+0800 I NETWORK [conn2] connection accepted from 127.0.0.1:3895 #2 (2 connections now open)
2017-05-22T18:32:26.322+0800 F NETWORK [conn2] dispatch error: ERROR 1054 (42S22): Unknown column ‘Table_type’ in ”