Hello everyone, We are trying to use a DB to store the time series and with our partner Branislav we give a shot to InfluxDB but didn't worked so I tried now IoTDB and creating a pipeline with only the data generator and the IoTDB data sink like the following figure represent:
[cid:[email protected]] And I can see that the data are not stored into the DB. I am using the current version of IoTDB installed on the same machine where SP is running and I can normally connect using: sbin/start-cli.sh -h 10.114.0.4 -p 6667 -u root -pw xxxx and using SHOW TIMESERIES I can see there is nothing in the DB. In the SP log I found the following error: pipeline-elements-all-jvm_1 | org.apache.iotdb.jdbc.IoTDBSQLException: 401: Error occurred while parsing SQL to physical plan: line 1:17 mismatched input 'root' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, INTO, SET, WHERE, FROM, TO, BY, DEVICE, CONFIGURATION, DESCRIBE, SLIMIT, LIMIT, UNLINK, OFFSET, SOFFSET, FILL, LINEAR, PREVIOUS, PREVIOUSUNTILLAST, METADATA, TIMESERIES, TIMESTAMP, PROPERTY, WITH, DATATYPE, COMPRESSOR, STORAGE, GROUP, LABEL, INT32, INT64, FLOAT, DOUBLE, BOOLEAN, TEXT, PLAIN, PLAIN_DICTIONARY, RLE, DIFF, TS_2DIFF, GORILLA, REGULAR, ADD, UPSERT, VALUES, NOW, LINK, INDEX, USING, TRACING, ON, OFF, DROP, MERGE, LIST, USER, PRIVILEGES, ROLE, ALL, OF, ALTER, PASSWORD, REVOKE, LOAD, WATERMARK_EMBEDDING, UNSET, TTL, FLUSH, TASK, INFO, VERSION, REMOVE, MOVE, CHILD, PATHS, DEVICES, COUNT, NODES, LEVEL, MIN_TIME, MAX_TIME, MIN_VALUE, MAX_VALUE, AVG, FIRST_VALUE, SUM, LAST_VALUE, LAST, DISABLE, ALIGN, COMPRESSION, TIME, ATTRIBUTES, TAGS, RENAME, GLOBAL, FULL, CLEAR, CACHE, TRUE, FALSE, UNCOMPRESSED, SNAPPY, GZIP, LZ4, PARTITION, SNAPSHOT, FOR, SCHEMA, DESC, ASC, '*', OPERATOR_IN, '-', '[', INT, EXPONENT, DURATION, DATETIME, ID, DOUBLE_QUOTE_STRING_LITERAL} pipeline-elements-all-jvm_1 | at org.apache.iotdb.jdbc.IoTDBStatement.executeSQL(IoTDBStatement.java:258) pipeline-elements-all-jvm_1 | at org.apache.iotdb.jdbc.IoTDBStatement.execute(IoTDBStatement.java:216) pipeline-elements-all-jvm_1 | at org.apache.streampipes.sinks.databases.jvm.iotdb.IotDb.save(IotDb.java:109) pipeline-elements-all-jvm_1 | at org.apache.streampipes.sinks.databases.jvm.iotdb.IotDb.onEvent(IotDb.java:73) pipeline-elements-all-jvm_1 | at org.apache.streampipes.wrapper.standalone.runtime.StandaloneEventSinkRuntime.process(StandaloneEventSinkRuntime.java:50) pipeline-elements-all-jvm_1 | at org.apache.streampipes.wrapper.standalone.routing.StandaloneSpInputCollector.send(StandaloneSpInputCollector.java:54) pipeline-elements-all-jvm_1 | at org.apache.streampipes.wrapper.standalone.routing.StandaloneSpInputCollector.lambda$onEvent$0(StandaloneSpInputCollector.java:48) pipeline-elements-all-jvm_1 | at org.apache.streampipes.wrapper.standalone.routing.StandaloneSpInputCollector$$Lambda$881/0x000000003c07ddd0.accept(Unknown Source) pipeline-elements-all-jvm_1 | at java.util.concurrent.ConcurrentHashMap.forEach(ConcurrentHashMap.java:1597) pipeline-elements-all-jvm_1 | at org.apache.streampipes.wrapper.standalone.routing.StandaloneSpInputCollector.onEvent(StandaloneSpInputCollector.java:48) pipeline-elements-all-jvm_1 | at org.apache.streampipes.wrapper.standalone.routing.StandaloneSpInputCollector.onEvent(StandaloneSpInputCollector.java:29) pipeline-elements-all-jvm_1 | at org.apache.streampipes.messaging.kafka.SpKafkaConsumer.run(SpKafkaConsumer.java:120) pipeline-elements-all-jvm_1 | at java.lang.Thread.run(Thread.java:823) I have verified that with a statement I can store into the DB some data so I can say that the problem is the IoTDB data sink. Let us know if you need anything else. Kindest regards, Michele Michele Canteri _________________________________________________________________ GFT Italia S.r.l. VIA SILE 18 / floor 4 20139 Milano, Italy T +39 02 58158503 F +39 02 58158621 [email protected] <http://www.gft.com>www.gft.com/it<https://www.gft.com/it> https://blog.gft.com https://www.linkedin.com/company/gft-group/ www.twitter.com/gft_it <https://www.twitter.com/gft_it> Registered office: GFT Italia S.r.l., Via Sile 18, 20139 Milan (Italy) VAT Code and number of registration with the Companies' Register of Milan: 00819200478 Corporate capital: Euro 1,000,000 fully paid-in Company subject to the direction and coordination activity of GFT Technologies SE Ai sensi del Regolamento UE 2016/679 (GDPR) e delle Linee Guida per posta elettronica ed Internet del Garante Privacy si rende noto che le informazioni contenute nella presente comunicazione e i relativi allegati possono essere riservate e sono, comunque, destinate esclusivamente alle persone o alla Societ? sopraindicati. Le stesse non sono da considerarsi comunicazioni personali, quindi eventuali risposte potranno essere conosciute da persone appartenenti all'azienda. In accordance with Regulation EU 2016/679 (General Data Protection Regulation) and Guidelines Applying to the Use of E-Mails and the Internet in the Employment Context of Italian Data Protection Authority it is announced that the information in this communication (which includes any documents with it) is confidential and meant only for above-mentioned persons and/or Companies; the information is not personal therefore, It is intended for the addressee only and any replies will be known by people belonging to the company. _________________________________________________________________
