kettle 中mongo 的时间类型如何使用?
0
问题描述:
{"$query":{"timestamp":{"$gt":new Date('2010/02/04 10:00:10')}}}
这样的查询语句在mongo中是可以查询的,但是在kettle中是不能查询的。
错误信息如下:
2014/09/23 11:26:26 - Version checker - OK
2014/09/23 11:26:30 - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test - 为了转换解除补丁开始 [E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test]
2014/09/23 11:26:31 - MongoDB Input.0 - Configuring connection with read preference: primary
2014/09/23 11:26:31 - MongoDB Input.0 - No read preference tag sets defined
2014/09/23 11:26:31 - MongoDB Input.0 - Configuring connection with default write concern - w = 1, wTimeout: 0, journaled = false
2014/09/23 11:26:31 - MongoDB Input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error
2014/09/23 11:26:31 - MongoDB Input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException:
2014/09/23 11:26:31 - MongoDB Input.0 - Unexpected error
2014/09/23 11:26:31 - MongoDB Input.0 -
{"$query":{"timestamp":{"$gt":new Date('2010/02/04 10:00:10')}}}
^
2014/09/23 11:26:31 - MongoDB Input.0 -
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:156)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2014/09/23 11:26:31 - MongoDB Input.0 - at java.lang.Thread.run(Thread.java:722)
2014/09/23 11:26:31 - MongoDB Input.0 - Caused by: com.mongodb.util.JSONParseException:
{"$query":{"timestamp":{"$gt":new Date('2010/02/04 10:00:10')}}}
^
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.read(JSON.java:272)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:161)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parseObject(JSON.java:231)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:195)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parseObject(JSON.java:231)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:195)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parseObject(JSON.java:231)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:195)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:145)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSON.parse(JSON.java:81)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSON.parse(JSON.java:66)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInputData.jsonPipelineToDBObjectList(MongoDbInputData.java:1339)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.initQuery(MongoDbInput.java:202)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:95)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:72)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.mongo.AuthContext.doAs(AuthContext.java:68)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:72)
2014/09/23 11:26:31 - MongoDB Input.0 - ... 2 more
2014/09/23 11:26:31 - MongoDB Input.0 - 完成处理 (I=0, O=0, R=0, W=0, U=0, E=1
2014/09/23 11:26:31 - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test
2014/09/23 11:26:31 - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test
{"$query":{"timestamp":{"$gt":new Date('2010/02/04 10:00:10')}}}
这样的查询语句在mongo中是可以查询的,但是在kettle中是不能查询的。
错误信息如下:
2014/09/23 11:26:26 - Version checker - OK
2014/09/23 11:26:30 - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test - 为了转换解除补丁开始 [E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test]
2014/09/23 11:26:31 - MongoDB Input.0 - Configuring connection with read preference: primary
2014/09/23 11:26:31 - MongoDB Input.0 - No read preference tag sets defined
2014/09/23 11:26:31 - MongoDB Input.0 - Configuring connection with default write concern - w = 1, wTimeout: 0, journaled = false
2014/09/23 11:26:31 - MongoDB Input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error
2014/09/23 11:26:31 - MongoDB Input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException:
2014/09/23 11:26:31 - MongoDB Input.0 - Unexpected error
2014/09/23 11:26:31 - MongoDB Input.0 -
{"$query":{"timestamp":{"$gt":new Date('2010/02/04 10:00:10')}}}
^
2014/09/23 11:26:31 - MongoDB Input.0 -
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:156)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2014/09/23 11:26:31 - MongoDB Input.0 - at java.lang.Thread.run(Thread.java:722)
2014/09/23 11:26:31 - MongoDB Input.0 - Caused by: com.mongodb.util.JSONParseException:
{"$query":{"timestamp":{"$gt":new Date('2010/02/04 10:00:10')}}}
^
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.read(JSON.java:272)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:161)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parseObject(JSON.java:231)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:195)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parseObject(JSON.java:231)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:195)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parseObject(JSON.java:231)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:195)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSONParser.parse(JSON.java:145)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSON.parse(JSON.java:81)
2014/09/23 11:26:31 - MongoDB Input.0 - at com.mongodb.util.JSON.parse(JSON.java:66)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInputData.jsonPipelineToDBObjectList(MongoDbInputData.java:1339)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.initQuery(MongoDbInput.java:202)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:95)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput$1.run(MongoDbInput.java:72)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.mongo.AuthContext.doAs(AuthContext.java:68)
2014/09/23 11:26:31 - MongoDB Input.0 - at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:72)
2014/09/23 11:26:31 - MongoDB Input.0 - ... 2 more
2014/09/23 11:26:31 - MongoDB Input.0 - 完成处理 (I=0, O=0, R=0, W=0, U=0, E=1
2014/09/23 11:26:31 - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test
2014/09/23 11:26:31 - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test - E:\kettle_ktr\KETTLE_MONGODB\test.ktr : test
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
0 个回复