elasticsearch-jdbc icon indicating copy to clipboard operation
elasticsearch-jdbc copied to clipboard

There is no data in my river, please help me,THX!!!

Open StanXia-114 opened this issue 9 years ago • 0 comments

hi, Here is my river, the result is true, i have put port 1433 in firewall access permission, but there is no data in test2, i don't know why...i need your help,THX!! [root@localhost usr]# curl -XPUT 'localhost:9200/_river/xjt_jdbc_river/_meta' -d '{ "type":"jdbc", "jdbc":{ "driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver", "url":"jdbc:sqlserver://10.3.146.4:1433;databaseName=dckdb", "user":"GFMONSH\cmbadmin", "password":" ", "sql":"select * from dckdb.dbo.xpwke0310 where CONVERT(nvarchar(12),[a0time],112)>CONVERT(nvarchar(12),GETDATE()-0,112)", "index":"test2", "type":"test2", "bulk_size":100, "bulk_timeout":"10s", "max_bulk_requests":30, "flush_interval":"5s" } }' {"_index":"_river","_type":"xjt_jdbc_river","_id":"_meta","_version":1,"created":true}

StanXia-114 avatar Oct 15 '16 01:10 StanXia-114