search

hashmapinc / nifi-opcua-bundle

Apache License 2.0
31 stars 11 forks source link

JSON timestamp string should be of a different format #22

Closed cherrera2001 closed 6 years ago

cherrera2001 commented 7 years ago

The JSON timestamp should be yyyy-MM-dd hh:mm:ss

ed3766 commented 7 years ago

Current format is "10/10/17 07:21:34.8756719 GMT". Reformat timestamp to yyyy-MM-dd hh:mm:ss to make HBase happy.

ed3766 commented 6 years ago

Support phoenix timestamp format yyyy-MM-dd HH:mm:ss in both CSV and JSON timestamps

Verify the GetOPCData processor returns the timestamp format yyyy-MM-dd HH:mm:ss for all DataFormat options (CSV, JSON) and Return Timestamp options (Server, Source) when Use Long Timestamp = false.

{ "values" : [ { "q" : 0, "id" : "SimulationExamples.Functions.Ramp1", "vs" : "35", "ts" : "2017-10-13 17:11:53" }, { "q" : 0, "id" : "SimulationExamples.Functions.Ramp2", "vs" : "150.75", "ts" : "2017-10-13 17:11:53" }...

ns=2;s=SimulationExamples.Functions.Ramp1,2017-10-13 17:11:53,35,0 ns=2;s=SimulationExamples.Functions.Ramp2,2017-10-13 17:11:53,150.75,0 ...