Caideyipi commented on code in PR #15275: URL: https://github.com/apache/iotdb/pull/15275#discussion_r2044006619
########## iotdb-core/datanode/src/main/java/org/apache/iotdb/db/pipe/extractor/mqtt/MQTTExtractor.java: ########## @@ -0,0 +1,179 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +package org.apache.iotdb.db.pipe.extractor.mqtt; + +import org.apache.iotdb.commons.pipe.agent.task.connection.UnboundedBlockingPendingQueue; +import org.apache.iotdb.commons.pipe.agent.task.meta.PipeTaskMeta; +import org.apache.iotdb.commons.pipe.config.constant.PipeExtractorConstant; +import org.apache.iotdb.commons.pipe.config.plugin.env.PipeTaskExtractorRuntimeEnvironment; +import org.apache.iotdb.commons.pipe.event.EnrichedEvent; +import org.apache.iotdb.db.pipe.metric.source.PipeDataRegionEventCounter; +import org.apache.iotdb.db.protocol.mqtt.BrokerAuthenticator; +import org.apache.iotdb.pipe.api.PipeExtractor; +import org.apache.iotdb.pipe.api.annotation.TableModel; +import org.apache.iotdb.pipe.api.annotation.TreeModel; +import org.apache.iotdb.pipe.api.customizer.configuration.PipeExtractorRuntimeConfiguration; +import org.apache.iotdb.pipe.api.customizer.parameter.PipeParameterValidator; +import org.apache.iotdb.pipe.api.customizer.parameter.PipeParameters; +import org.apache.iotdb.pipe.api.event.Event; +import org.apache.iotdb.pipe.api.exception.PipeParameterNotValidException; + +import io.moquette.BrokerConstants; +import io.moquette.broker.Server; +import io.moquette.broker.config.IConfig; +import io.moquette.broker.config.MemoryConfig; +import io.moquette.broker.security.IAuthenticator; +import io.moquette.interception.InterceptHandler; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; + +import java.io.IOException; +import java.util.ArrayList; +import java.util.Arrays; +import java.util.List; +import java.util.Properties; +import java.util.concurrent.atomic.AtomicBoolean; + +@TreeModel +@TableModel +public class MQTTExtractor implements PipeExtractor { + + private static final Logger LOGGER = LoggerFactory.getLogger(MQTTExtractor.class); + + protected String pipeName; + protected long creationTime; + protected PipeTaskMeta pipeTaskMeta; + protected final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue = + new UnboundedBlockingPendingQueue<>(new PipeDataRegionEventCounter()); + + protected IConfig config; + protected List<InterceptHandler> handlers; + protected IAuthenticator authenticator; + private final Server server = new Server(); + + protected final AtomicBoolean isClosed = new AtomicBoolean(false); + + @Override + public void validate(final PipeParameterValidator validator) throws Exception { + if (!validator + .getParameters() + .getBooleanOrDefault( + Arrays.asList( + PipeExtractorConstant.EXTERNAL_EXTRACTOR_SINGLE_INSTANCE_PER_NODE_KEY, + PipeExtractorConstant.EXTERNAL_SOURCE_SINGLE_INSTANCE_PER_NODE_KEY), + PipeExtractorConstant.EXTERNAL_EXTRACTOR_SINGLE_INSTANCE_PER_NODE_DEFAULT_VALUE)) { + throw new PipeParameterNotValidException("single mode should be true in MQTT extractor"); + } + } + + @Override + public void customize( + final PipeParameters parameters, final PipeExtractorRuntimeConfiguration configuration) + throws Exception { + final PipeTaskExtractorRuntimeEnvironment environment = + (PipeTaskExtractorRuntimeEnvironment) configuration.getRuntimeEnvironment(); + pipeName = environment.getPipeName(); + creationTime = environment.getCreationTime(); + pipeTaskMeta = environment.getPipeTaskMeta(); + config = createBrokerConfig(parameters); + handlers = new ArrayList<>(1); + handlers.add(new MQTTPublishHandler(parameters, environment, pendingQueue)); + authenticator = new BrokerAuthenticator(); + } + + @Override + public void start() throws Exception { + try { + server.startServer(config, handlers, null, authenticator, null); + } catch (IOException e) { + throw new RuntimeException("Exception while starting server", e); + } + + LOGGER.info( + "Start MQTT Extractor successfully,listening on ip {} port {}", + config.getProperty(BrokerConstants.HOST_PROPERTY_NAME), + config.getProperty(BrokerConstants.PORT_PROPERTY_NAME)); + + Runtime.getRuntime() + .addShutdownHook( + new Thread( + () -> { + LOGGER.info("Stopping IoTDB MQTT Extractor..."); + shutdown(); + LOGGER.info("MQTT Extractor stopped."); + })); + } + + @Override + public Event supply() throws Exception { + if (isClosed.get()) { + return null; + } + EnrichedEvent event = pendingQueue.directPoll(); + return event; + } + + @Override + public void close() throws Exception { + if (!isClosed.get()) { + shutdown(); + isClosed.set(true); + } + } + + private IConfig createBrokerConfig(final PipeParameters pipeParameters) { + final Properties properties = new Properties(); + properties.setProperty( + BrokerConstants.HOST_PROPERTY_NAME, + pipeParameters.getStringOrDefault( + PipeExtractorConstant.MQTT_BROKER_HOST_KEY, + PipeExtractorConstant.MQTT_BROKER_HOST_DEFAULT_VALUE)); + properties.setProperty( + BrokerConstants.PORT_PROPERTY_NAME, + pipeParameters.getStringOrDefault( + PipeExtractorConstant.MQTT_BROKER_PORT_KEY, + PipeExtractorConstant.MQTT_BROKER_PORT_DEFAULT_VALUE)); + properties.setProperty( + BrokerConstants.BROKER_INTERCEPTOR_THREAD_POOL_SIZE, + pipeParameters.getStringOrDefault( + PipeExtractorConstant.MQTT_BROKER_INTERCEPTOR_THREAD_POOL_SIZE_KEY, + PipeExtractorConstant.MQTT_BROKER_INTERCEPTOR_THREAD_POOL_SIZE_DEFAULT_VALUE)); + properties.setProperty( + BrokerConstants.DATA_PATH_PROPERTY_NAME, + pipeParameters.getStringOrDefault( + PipeExtractorConstant.MQTT_DATA_PATH_PROPERTY_NAME_KEY, + PipeExtractorConstant.MQTT_DATA_PATH_PROPERTY_NAME_DEFAULT_VALUE)); + properties.setProperty(BrokerConstants.IMMEDIATE_BUFFER_FLUSH_PROPERTY_NAME, "true"); + properties.setProperty(BrokerConstants.ALLOW_ANONYMOUS_PROPERTY_NAME, "true"); + properties.setProperty(BrokerConstants.ALLOW_ZERO_BYTE_CLIENT_ID_PROPERTY_NAME, "true"); Review Comment: Why do we hard-code those 3 parameters as true? Especially "allow_anonymous_property"... The "MQTTService" in IoTDB just uses "false" here.. ########## iotdb-core/datanode/src/main/java/org/apache/iotdb/db/pipe/extractor/mqtt/MQTTPublishHandler.java: ########## @@ -0,0 +1,372 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +package org.apache.iotdb.db.pipe.extractor.mqtt; + +import org.apache.iotdb.common.rpc.thrift.TSStatus; +import org.apache.iotdb.commons.conf.IoTDBConstant.ClientVersion; +import org.apache.iotdb.commons.pipe.agent.task.connection.UnboundedBlockingPendingQueue; +import org.apache.iotdb.commons.pipe.agent.task.meta.PipeTaskMeta; +import org.apache.iotdb.commons.pipe.config.constant.PipeExtractorConstant; +import org.apache.iotdb.commons.pipe.config.plugin.env.PipeTaskExtractorRuntimeEnvironment; +import org.apache.iotdb.commons.pipe.event.EnrichedEvent; +import org.apache.iotdb.commons.service.metric.PerformanceOverviewMetrics; +import org.apache.iotdb.db.auth.AuthorityChecker; +import org.apache.iotdb.db.exception.query.QueryProcessException; +import org.apache.iotdb.db.pipe.event.common.tablet.PipeRawTabletInsertionEvent; +import org.apache.iotdb.db.protocol.mqtt.Message; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatManager; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatter; +import org.apache.iotdb.db.protocol.mqtt.TableMessage; +import org.apache.iotdb.db.protocol.mqtt.TreeMessage; +import org.apache.iotdb.db.protocol.session.IClientSession; +import org.apache.iotdb.db.protocol.session.MqttClientSession; +import org.apache.iotdb.db.protocol.session.SessionManager; +import org.apache.iotdb.db.queryengine.plan.Coordinator; +import org.apache.iotdb.db.utils.CommonUtils; +import org.apache.iotdb.db.utils.TimestampPrecisionUtils; +import org.apache.iotdb.db.utils.TypeInferenceUtils; +import org.apache.iotdb.pipe.api.customizer.parameter.PipeParameters; +import org.apache.iotdb.rpc.TSStatusCode; +import org.apache.iotdb.service.rpc.thrift.TSProtocolVersion; + +import io.moquette.interception.AbstractInterceptHandler; +import io.moquette.interception.messages.InterceptConnectMessage; +import io.moquette.interception.messages.InterceptDisconnectMessage; +import io.moquette.interception.messages.InterceptPublishMessage; +import io.netty.buffer.ByteBuf; +import io.netty.handler.codec.mqtt.MqttQoS; +import org.apache.tsfile.enums.TSDataType; +import org.apache.tsfile.utils.Binary; +import org.apache.tsfile.utils.BitMap; +import org.apache.tsfile.write.record.Tablet; +import org.apache.tsfile.write.schema.MeasurementSchema; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; + +import java.time.ZoneId; +import java.util.Arrays; +import java.util.List; +import java.util.concurrent.ConcurrentHashMap; +import java.util.stream.Collectors; +import java.util.stream.Stream; + +/** PublishHandler handle the messages from MQTT clients. */ +public class MQTTPublishHandler extends AbstractInterceptHandler { + + private static final Logger LOGGER = LoggerFactory.getLogger(MQTTPublishHandler.class); + + private final SessionManager sessionManager = SessionManager.getInstance(); + + private final ConcurrentHashMap<String, MqttClientSession> clientIdToSessionMap = + new ConcurrentHashMap<>(); + private final PayloadFormatter payloadFormat; + private final boolean useTableInsert; + private final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue; + private final String pipeName; + private final long creationTime; + private final PipeTaskMeta pipeTaskMeta; + + public MQTTPublishHandler( + final PipeParameters pipeParameters, + final PipeTaskExtractorRuntimeEnvironment environment, + final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue) { + this.payloadFormat = + PayloadFormatManager.getPayloadFormat( + pipeParameters.getStringOrDefault( + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_KEY, + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_DEFAULT_VALUE)); + useTableInsert = PayloadFormatter.TABLE_TYPE.equals(this.payloadFormat.getType()); + pipeName = environment.getPipeName(); + creationTime = environment.getCreationTime(); + pipeTaskMeta = environment.getPipeTaskMeta(); + this.pendingQueue = pendingQueue; + } + + @Override + public String getID() { + return "mqtt-source-broker-listener"; + } + + @Override + public void onConnect(InterceptConnectMessage msg) { + if (!clientIdToSessionMap.containsKey(msg.getClientID())) { + final MqttClientSession session = new MqttClientSession(msg.getClientID()); + sessionManager.login( + session, + msg.getUsername(), + new String(msg.getPassword()), + ZoneId.systemDefault().toString(), + TSProtocolVersion.IOTDB_SERVICE_PROTOCOL_V3, + ClientVersion.V_1_0, + useTableInsert ? IClientSession.SqlDialect.TABLE : IClientSession.SqlDialect.TREE); + sessionManager.registerSession(session); + clientIdToSessionMap.put(msg.getClientID(), session); + } + } + + @Override + public void onDisconnect(InterceptDisconnectMessage msg) { + final MqttClientSession session = clientIdToSessionMap.remove(msg.getClientID()); + if (null != session) { + sessionManager.removeCurrSession(); + sessionManager.closeSession(session, Coordinator.getInstance()::cleanupQueryExecution); + } + } + + @Override + public void onPublish(InterceptPublishMessage msg) { + try { + final String clientId = msg.getClientID(); + if (!clientIdToSessionMap.containsKey(clientId)) { + return; + } + final MqttClientSession session = clientIdToSessionMap.get(msg.getClientID()); + final ByteBuf payload = msg.getPayload(); + final String topic = msg.getTopicName(); + final String username = msg.getUsername(); + final MqttQoS qos = msg.getQos(); + + LOGGER.debug( + "Receive publish message. clientId: {}, username: {}, qos: {}, topic: {}, payload: {}", + clientId, + username, + qos, + topic, + payload); + + final List<Message> messages = payloadFormat.format(payload); + if (messages == null) { + return; + } + + for (Message message : messages) { + if (message == null) { + continue; + } + if (useTableInsert) { + final TableMessage tableMessage = (TableMessage) message; + // '/' previously defined as a database name + final String database = + !msg.getTopicName().contains("/") + ? msg.getTopicName() + : msg.getTopicName().substring(0, msg.getTopicName().indexOf("/")); + tableMessage.setDatabase(database.toLowerCase()); + extractTable(tableMessage, session); + } else { + extractTree((TreeMessage) message, session); + } + } + } catch (Throwable t) { + LOGGER.warn("onPublish execution exception, msg is [{}], error is ", msg, t); + } finally { + // release the payload of the message + super.onPublish(msg); + } + } + + /** Inserting table using tablet */ + private void extractTable(final TableMessage message, final MqttClientSession session) { + try { + TimestampPrecisionUtils.checkTimestampPrecision(message.getTimestamp()); + session.setDatabaseName(message.getDatabase().toLowerCase()); + session.setSqlDialect(IClientSession.SqlDialect.TABLE); + final EnrichedEvent event = generateEvent(message); + if (!event.increaseReferenceCount(MQTTPublishHandler.class.getName())) { + LOGGER.warn("The reference count of the event {} cannot be increased, skipping it.", event); + } + pendingQueue.waitedOffer(event); + } catch (Exception e) { + LOGGER.warn( + "meet error when polling mqtt source message database {}, table {}, tags {}, attributes {}, fields {}, at time {}, because ", + message.getDatabase(), + message.getTable(), + message.getTagKeys(), + message.getAttributeKeys(), + message.getFields(), + message.getTimestamp(), + e); + } + } + + private PipeRawTabletInsertionEvent generateEvent(final TableMessage message) { + final List<String> measurements = + Stream.of(message.getFields(), message.getTagKeys(), message.getAttributeKeys()) + .flatMap(List::stream) + .collect(Collectors.toList()); + final long[] timestamps = new long[] {message.getTimestamp()}; + final BitMap[] bitMaps = new BitMap[measurements.size()]; + final Object[] columns = + Stream.of(message.getValues(), message.getTagValues(), message.getAttributeValues()) + .flatMap(List::stream) + .toArray(Object[]::new); + final TSDataType[] dataTypes = new TSDataType[measurements.size()]; + final Tablet.ColumnCategory[] columnCategories = new Tablet.ColumnCategory[measurements.size()]; + final MeasurementSchema[] schemas = new MeasurementSchema[measurements.size()]; + for (int i = 0; i < message.getFields().size(); i++) { + dataTypes[i] = message.getDataTypes().get(i); + columnCategories[i] = Tablet.ColumnCategory.FIELD; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + for (int i = message.getFields().size(); + i < message.getFields().size() + message.getTagKeys().size(); + i++) { + dataTypes[i] = TSDataType.STRING; + columnCategories[i] = Tablet.ColumnCategory.TAG; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + for (int i = message.getFields().size() + message.getTagKeys().size(); + i + < message.getFields().size() + + message.getTagKeys().size() + + message.getAttributeKeys().size(); + i++) { + dataTypes[i] = TSDataType.STRING; + columnCategories[i] = Tablet.ColumnCategory.ATTRIBUTE; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + + final Tablet eventTablet = + new Tablet( + message.getTable(), + Arrays.asList(schemas), + Arrays.asList(columnCategories), + timestamps, + columns, + bitMaps, + 1); + + return new PipeRawTabletInsertionEvent( + true, + message.getDatabase(), + null, + null, + eventTablet, + false, + pipeName, + creationTime, + pipeTaskMeta, + null, + false); + } + + private void extractTree(final TreeMessage message, final MqttClientSession session) { + TSStatus tsStatus = null; + try { + TimestampPrecisionUtils.checkTimestampPrecision(message.getTimestamp()); + tsStatus = checkAuthority(session); + if (tsStatus.getCode() != TSStatusCode.SUCCESS_STATUS.getStatusCode()) { + LOGGER.warn(tsStatus.message); + } else { + final EnrichedEvent event = generateEvent(message); + if (!event.increaseReferenceCount(MQTTPublishHandler.class.getName())) { + LOGGER.warn( + "The reference count of the event {} cannot be increased, skipping it.", event); Review Comment: ```suggestion "The reference count of the event {} cannot be increased, skipping it.", event); return; ``` ########## iotdb-core/datanode/src/main/java/org/apache/iotdb/db/pipe/extractor/mqtt/MQTTPublishHandler.java: ########## @@ -0,0 +1,372 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +package org.apache.iotdb.db.pipe.extractor.mqtt; + +import org.apache.iotdb.common.rpc.thrift.TSStatus; +import org.apache.iotdb.commons.conf.IoTDBConstant.ClientVersion; +import org.apache.iotdb.commons.pipe.agent.task.connection.UnboundedBlockingPendingQueue; +import org.apache.iotdb.commons.pipe.agent.task.meta.PipeTaskMeta; +import org.apache.iotdb.commons.pipe.config.constant.PipeExtractorConstant; +import org.apache.iotdb.commons.pipe.config.plugin.env.PipeTaskExtractorRuntimeEnvironment; +import org.apache.iotdb.commons.pipe.event.EnrichedEvent; +import org.apache.iotdb.commons.service.metric.PerformanceOverviewMetrics; +import org.apache.iotdb.db.auth.AuthorityChecker; +import org.apache.iotdb.db.exception.query.QueryProcessException; +import org.apache.iotdb.db.pipe.event.common.tablet.PipeRawTabletInsertionEvent; +import org.apache.iotdb.db.protocol.mqtt.Message; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatManager; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatter; +import org.apache.iotdb.db.protocol.mqtt.TableMessage; +import org.apache.iotdb.db.protocol.mqtt.TreeMessage; +import org.apache.iotdb.db.protocol.session.IClientSession; +import org.apache.iotdb.db.protocol.session.MqttClientSession; +import org.apache.iotdb.db.protocol.session.SessionManager; +import org.apache.iotdb.db.queryengine.plan.Coordinator; +import org.apache.iotdb.db.utils.CommonUtils; +import org.apache.iotdb.db.utils.TimestampPrecisionUtils; +import org.apache.iotdb.db.utils.TypeInferenceUtils; +import org.apache.iotdb.pipe.api.customizer.parameter.PipeParameters; +import org.apache.iotdb.rpc.TSStatusCode; +import org.apache.iotdb.service.rpc.thrift.TSProtocolVersion; + +import io.moquette.interception.AbstractInterceptHandler; +import io.moquette.interception.messages.InterceptConnectMessage; +import io.moquette.interception.messages.InterceptDisconnectMessage; +import io.moquette.interception.messages.InterceptPublishMessage; +import io.netty.buffer.ByteBuf; +import io.netty.handler.codec.mqtt.MqttQoS; +import org.apache.tsfile.enums.TSDataType; +import org.apache.tsfile.utils.Binary; +import org.apache.tsfile.utils.BitMap; +import org.apache.tsfile.write.record.Tablet; +import org.apache.tsfile.write.schema.MeasurementSchema; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; + +import java.time.ZoneId; +import java.util.Arrays; +import java.util.List; +import java.util.concurrent.ConcurrentHashMap; +import java.util.stream.Collectors; +import java.util.stream.Stream; + +/** PublishHandler handle the messages from MQTT clients. */ +public class MQTTPublishHandler extends AbstractInterceptHandler { + + private static final Logger LOGGER = LoggerFactory.getLogger(MQTTPublishHandler.class); + + private final SessionManager sessionManager = SessionManager.getInstance(); + + private final ConcurrentHashMap<String, MqttClientSession> clientIdToSessionMap = + new ConcurrentHashMap<>(); + private final PayloadFormatter payloadFormat; + private final boolean useTableInsert; + private final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue; + private final String pipeName; + private final long creationTime; + private final PipeTaskMeta pipeTaskMeta; + + public MQTTPublishHandler( + final PipeParameters pipeParameters, + final PipeTaskExtractorRuntimeEnvironment environment, + final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue) { + this.payloadFormat = + PayloadFormatManager.getPayloadFormat( + pipeParameters.getStringOrDefault( + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_KEY, + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_DEFAULT_VALUE)); + useTableInsert = PayloadFormatter.TABLE_TYPE.equals(this.payloadFormat.getType()); + pipeName = environment.getPipeName(); + creationTime = environment.getCreationTime(); + pipeTaskMeta = environment.getPipeTaskMeta(); + this.pendingQueue = pendingQueue; + } + + @Override + public String getID() { + return "mqtt-source-broker-listener"; + } + + @Override + public void onConnect(InterceptConnectMessage msg) { + if (!clientIdToSessionMap.containsKey(msg.getClientID())) { + final MqttClientSession session = new MqttClientSession(msg.getClientID()); + sessionManager.login( + session, + msg.getUsername(), + new String(msg.getPassword()), + ZoneId.systemDefault().toString(), + TSProtocolVersion.IOTDB_SERVICE_PROTOCOL_V3, + ClientVersion.V_1_0, + useTableInsert ? IClientSession.SqlDialect.TABLE : IClientSession.SqlDialect.TREE); + sessionManager.registerSession(session); + clientIdToSessionMap.put(msg.getClientID(), session); + } + } + + @Override + public void onDisconnect(InterceptDisconnectMessage msg) { + final MqttClientSession session = clientIdToSessionMap.remove(msg.getClientID()); + if (null != session) { + sessionManager.removeCurrSession(); + sessionManager.closeSession(session, Coordinator.getInstance()::cleanupQueryExecution); + } + } + + @Override + public void onPublish(InterceptPublishMessage msg) { + try { + final String clientId = msg.getClientID(); + if (!clientIdToSessionMap.containsKey(clientId)) { + return; + } + final MqttClientSession session = clientIdToSessionMap.get(msg.getClientID()); + final ByteBuf payload = msg.getPayload(); + final String topic = msg.getTopicName(); + final String username = msg.getUsername(); + final MqttQoS qos = msg.getQos(); + + LOGGER.debug( + "Receive publish message. clientId: {}, username: {}, qos: {}, topic: {}, payload: {}", + clientId, + username, + qos, + topic, + payload); + + final List<Message> messages = payloadFormat.format(payload); + if (messages == null) { + return; + } + + for (Message message : messages) { + if (message == null) { + continue; + } + if (useTableInsert) { + final TableMessage tableMessage = (TableMessage) message; + // '/' previously defined as a database name + final String database = + !msg.getTopicName().contains("/") + ? msg.getTopicName() + : msg.getTopicName().substring(0, msg.getTopicName().indexOf("/")); + tableMessage.setDatabase(database.toLowerCase()); + extractTable(tableMessage, session); + } else { + extractTree((TreeMessage) message, session); + } + } + } catch (Throwable t) { + LOGGER.warn("onPublish execution exception, msg is [{}], error is ", msg, t); + } finally { + // release the payload of the message + super.onPublish(msg); + } + } + + /** Inserting table using tablet */ + private void extractTable(final TableMessage message, final MqttClientSession session) { + try { + TimestampPrecisionUtils.checkTimestampPrecision(message.getTimestamp()); + session.setDatabaseName(message.getDatabase().toLowerCase()); + session.setSqlDialect(IClientSession.SqlDialect.TABLE); + final EnrichedEvent event = generateEvent(message); + if (!event.increaseReferenceCount(MQTTPublishHandler.class.getName())) { + LOGGER.warn("The reference count of the event {} cannot be increased, skipping it.", event); + } + pendingQueue.waitedOffer(event); + } catch (Exception e) { + LOGGER.warn( + "meet error when polling mqtt source message database {}, table {}, tags {}, attributes {}, fields {}, at time {}, because ", + message.getDatabase(), + message.getTable(), + message.getTagKeys(), + message.getAttributeKeys(), + message.getFields(), + message.getTimestamp(), + e); + } + } + + private PipeRawTabletInsertionEvent generateEvent(final TableMessage message) { + final List<String> measurements = + Stream.of(message.getFields(), message.getTagKeys(), message.getAttributeKeys()) + .flatMap(List::stream) + .collect(Collectors.toList()); + final long[] timestamps = new long[] {message.getTimestamp()}; + final BitMap[] bitMaps = new BitMap[measurements.size()]; + final Object[] columns = + Stream.of(message.getValues(), message.getTagValues(), message.getAttributeValues()) + .flatMap(List::stream) + .toArray(Object[]::new); + final TSDataType[] dataTypes = new TSDataType[measurements.size()]; + final Tablet.ColumnCategory[] columnCategories = new Tablet.ColumnCategory[measurements.size()]; + final MeasurementSchema[] schemas = new MeasurementSchema[measurements.size()]; + for (int i = 0; i < message.getFields().size(); i++) { + dataTypes[i] = message.getDataTypes().get(i); + columnCategories[i] = Tablet.ColumnCategory.FIELD; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + for (int i = message.getFields().size(); + i < message.getFields().size() + message.getTagKeys().size(); + i++) { + dataTypes[i] = TSDataType.STRING; + columnCategories[i] = Tablet.ColumnCategory.TAG; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + for (int i = message.getFields().size() + message.getTagKeys().size(); + i + < message.getFields().size() + + message.getTagKeys().size() + + message.getAttributeKeys().size(); + i++) { + dataTypes[i] = TSDataType.STRING; + columnCategories[i] = Tablet.ColumnCategory.ATTRIBUTE; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + + final Tablet eventTablet = + new Tablet( + message.getTable(), + Arrays.asList(schemas), + Arrays.asList(columnCategories), + timestamps, + columns, + bitMaps, + 1); + + return new PipeRawTabletInsertionEvent( + true, + message.getDatabase(), + null, + null, + eventTablet, + false, + pipeName, + creationTime, + pipeTaskMeta, + null, + false); + } + + private void extractTree(final TreeMessage message, final MqttClientSession session) { + TSStatus tsStatus = null; + try { + TimestampPrecisionUtils.checkTimestampPrecision(message.getTimestamp()); + tsStatus = checkAuthority(session); + if (tsStatus.getCode() != TSStatusCode.SUCCESS_STATUS.getStatusCode()) { + LOGGER.warn(tsStatus.message); + } else { + final EnrichedEvent event = generateEvent(message); + if (!event.increaseReferenceCount(MQTTPublishHandler.class.getName())) { + LOGGER.warn( + "The reference count of the event {} cannot be increased, skipping it.", event); + } + pendingQueue.waitedOffer(event); + } + } catch (Exception e) { + LOGGER.warn( + "meet error when polling mqtt source device {}, measurements {}, at time {}, because ", + message.getDevice(), + message.getMeasurements(), + message.getTimestamp(), + e); + } + } + + private EnrichedEvent generateEvent(final TreeMessage message) throws QueryProcessException { + final String deviceId = message.getDevice(); + final List<String> measurements = message.getMeasurements(); + final long[] timestamps = new long[] {message.getTimestamp()}; + final MeasurementSchema[] schemas = new MeasurementSchema[measurements.size()]; + final TSDataType[] dataTypes = + message.getDataTypes() == null + ? new TSDataType[message.getMeasurements().size()] + : message.getDataTypes().toArray(new TSDataType[0]); + final List<String> values = message.getValues(); + final BitMap[] bitMaps = new BitMap[schemas.length]; + if (message.getDataTypes() == null) { + for (int index = 0; index < values.size(); ++index) { + dataTypes[index] = TypeInferenceUtils.getPredictedDataType(values.get(index), true); + } + } + + for (int i = 0; i < schemas.length; i++) { + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + final Object[] inferredValues = new Object[values.size()]; + + // For each measurement value, parse it and then wrap it in a one-dimensional array. + for (int i = 0; i < values.size(); ++i) { + Object parsedValue = CommonUtils.parseValue(dataTypes[i], values.get(i)); + // Wrap the parsed value into a one-dimensional array based on its type. + if (parsedValue instanceof Integer) { + inferredValues[i] = new int[] {(Integer) parsedValue}; + } else if (parsedValue instanceof Long) { + inferredValues[i] = new long[] {(Long) parsedValue}; + } else if (parsedValue instanceof Float) { + inferredValues[i] = new float[] {(Float) parsedValue}; + } else if (parsedValue instanceof Double) { + inferredValues[i] = new double[] {(Double) parsedValue}; + } else if (parsedValue instanceof Boolean) { + inferredValues[i] = new boolean[] {(Boolean) parsedValue}; + } else if (parsedValue instanceof String) { + inferredValues[i] = new String[] {(String) parsedValue}; + } else if (parsedValue instanceof Binary) { + inferredValues[i] = new Binary[] {(Binary) parsedValue}; + } else { + // For any other type, wrap it as an Object array. + inferredValues[i] = new Object[] {parsedValue}; + } + } + + final Tablet eventTablet = + new Tablet(deviceId, Arrays.asList(schemas), timestamps, inferredValues, bitMaps, 1); + + return new PipeRawTabletInsertionEvent( + false, + deviceId, + null, + null, + eventTablet, + false, + pipeName, + creationTime, + pipeTaskMeta, + null, + false); + } + + private static TSStatus checkAuthority(final MqttClientSession session) { Review Comment: No need to check the authority here.... Instead, the username shall be bounded to the event, and the "write-back-sink" may require a little bit adjustment, to use the username in the event instead of its own. ########## iotdb-core/datanode/src/main/java/org/apache/iotdb/db/pipe/extractor/mqtt/MQTTPublishHandler.java: ########## @@ -0,0 +1,372 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +package org.apache.iotdb.db.pipe.extractor.mqtt; + +import org.apache.iotdb.common.rpc.thrift.TSStatus; +import org.apache.iotdb.commons.conf.IoTDBConstant.ClientVersion; +import org.apache.iotdb.commons.pipe.agent.task.connection.UnboundedBlockingPendingQueue; +import org.apache.iotdb.commons.pipe.agent.task.meta.PipeTaskMeta; +import org.apache.iotdb.commons.pipe.config.constant.PipeExtractorConstant; +import org.apache.iotdb.commons.pipe.config.plugin.env.PipeTaskExtractorRuntimeEnvironment; +import org.apache.iotdb.commons.pipe.event.EnrichedEvent; +import org.apache.iotdb.commons.service.metric.PerformanceOverviewMetrics; +import org.apache.iotdb.db.auth.AuthorityChecker; +import org.apache.iotdb.db.exception.query.QueryProcessException; +import org.apache.iotdb.db.pipe.event.common.tablet.PipeRawTabletInsertionEvent; +import org.apache.iotdb.db.protocol.mqtt.Message; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatManager; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatter; +import org.apache.iotdb.db.protocol.mqtt.TableMessage; +import org.apache.iotdb.db.protocol.mqtt.TreeMessage; +import org.apache.iotdb.db.protocol.session.IClientSession; +import org.apache.iotdb.db.protocol.session.MqttClientSession; +import org.apache.iotdb.db.protocol.session.SessionManager; +import org.apache.iotdb.db.queryengine.plan.Coordinator; +import org.apache.iotdb.db.utils.CommonUtils; +import org.apache.iotdb.db.utils.TimestampPrecisionUtils; +import org.apache.iotdb.db.utils.TypeInferenceUtils; +import org.apache.iotdb.pipe.api.customizer.parameter.PipeParameters; +import org.apache.iotdb.rpc.TSStatusCode; +import org.apache.iotdb.service.rpc.thrift.TSProtocolVersion; + +import io.moquette.interception.AbstractInterceptHandler; +import io.moquette.interception.messages.InterceptConnectMessage; +import io.moquette.interception.messages.InterceptDisconnectMessage; +import io.moquette.interception.messages.InterceptPublishMessage; +import io.netty.buffer.ByteBuf; +import io.netty.handler.codec.mqtt.MqttQoS; +import org.apache.tsfile.enums.TSDataType; +import org.apache.tsfile.utils.Binary; +import org.apache.tsfile.utils.BitMap; +import org.apache.tsfile.write.record.Tablet; +import org.apache.tsfile.write.schema.MeasurementSchema; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; + +import java.time.ZoneId; +import java.util.Arrays; +import java.util.List; +import java.util.concurrent.ConcurrentHashMap; +import java.util.stream.Collectors; +import java.util.stream.Stream; + +/** PublishHandler handle the messages from MQTT clients. */ +public class MQTTPublishHandler extends AbstractInterceptHandler { + + private static final Logger LOGGER = LoggerFactory.getLogger(MQTTPublishHandler.class); + + private final SessionManager sessionManager = SessionManager.getInstance(); + + private final ConcurrentHashMap<String, MqttClientSession> clientIdToSessionMap = + new ConcurrentHashMap<>(); + private final PayloadFormatter payloadFormat; + private final boolean useTableInsert; + private final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue; + private final String pipeName; + private final long creationTime; + private final PipeTaskMeta pipeTaskMeta; + + public MQTTPublishHandler( + final PipeParameters pipeParameters, + final PipeTaskExtractorRuntimeEnvironment environment, + final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue) { + this.payloadFormat = + PayloadFormatManager.getPayloadFormat( + pipeParameters.getStringOrDefault( + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_KEY, + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_DEFAULT_VALUE)); + useTableInsert = PayloadFormatter.TABLE_TYPE.equals(this.payloadFormat.getType()); + pipeName = environment.getPipeName(); + creationTime = environment.getCreationTime(); + pipeTaskMeta = environment.getPipeTaskMeta(); + this.pendingQueue = pendingQueue; + } + + @Override + public String getID() { + return "mqtt-source-broker-listener"; + } + + @Override + public void onConnect(InterceptConnectMessage msg) { + if (!clientIdToSessionMap.containsKey(msg.getClientID())) { + final MqttClientSession session = new MqttClientSession(msg.getClientID()); + sessionManager.login( + session, + msg.getUsername(), + new String(msg.getPassword()), + ZoneId.systemDefault().toString(), + TSProtocolVersion.IOTDB_SERVICE_PROTOCOL_V3, + ClientVersion.V_1_0, + useTableInsert ? IClientSession.SqlDialect.TABLE : IClientSession.SqlDialect.TREE); + sessionManager.registerSession(session); + clientIdToSessionMap.put(msg.getClientID(), session); + } + } + + @Override + public void onDisconnect(InterceptDisconnectMessage msg) { + final MqttClientSession session = clientIdToSessionMap.remove(msg.getClientID()); + if (null != session) { + sessionManager.removeCurrSession(); + sessionManager.closeSession(session, Coordinator.getInstance()::cleanupQueryExecution); + } + } + + @Override + public void onPublish(InterceptPublishMessage msg) { + try { + final String clientId = msg.getClientID(); + if (!clientIdToSessionMap.containsKey(clientId)) { + return; + } + final MqttClientSession session = clientIdToSessionMap.get(msg.getClientID()); + final ByteBuf payload = msg.getPayload(); + final String topic = msg.getTopicName(); + final String username = msg.getUsername(); + final MqttQoS qos = msg.getQos(); + + LOGGER.debug( + "Receive publish message. clientId: {}, username: {}, qos: {}, topic: {}, payload: {}", + clientId, + username, + qos, + topic, + payload); + + final List<Message> messages = payloadFormat.format(payload); + if (messages == null) { + return; + } + + for (Message message : messages) { + if (message == null) { + continue; + } + if (useTableInsert) { + final TableMessage tableMessage = (TableMessage) message; + // '/' previously defined as a database name + final String database = + !msg.getTopicName().contains("/") + ? msg.getTopicName() + : msg.getTopicName().substring(0, msg.getTopicName().indexOf("/")); + tableMessage.setDatabase(database.toLowerCase()); + extractTable(tableMessage, session); + } else { + extractTree((TreeMessage) message, session); + } + } + } catch (Throwable t) { + LOGGER.warn("onPublish execution exception, msg is [{}], error is ", msg, t); + } finally { + // release the payload of the message + super.onPublish(msg); + } + } + + /** Inserting table using tablet */ + private void extractTable(final TableMessage message, final MqttClientSession session) { + try { + TimestampPrecisionUtils.checkTimestampPrecision(message.getTimestamp()); + session.setDatabaseName(message.getDatabase().toLowerCase()); + session.setSqlDialect(IClientSession.SqlDialect.TABLE); + final EnrichedEvent event = generateEvent(message); + if (!event.increaseReferenceCount(MQTTPublishHandler.class.getName())) { + LOGGER.warn("The reference count of the event {} cannot be increased, skipping it.", event); + } + pendingQueue.waitedOffer(event); + } catch (Exception e) { + LOGGER.warn( + "meet error when polling mqtt source message database {}, table {}, tags {}, attributes {}, fields {}, at time {}, because ", + message.getDatabase(), + message.getTable(), + message.getTagKeys(), + message.getAttributeKeys(), + message.getFields(), + message.getTimestamp(), + e); + } + } + + private PipeRawTabletInsertionEvent generateEvent(final TableMessage message) { + final List<String> measurements = + Stream.of(message.getFields(), message.getTagKeys(), message.getAttributeKeys()) + .flatMap(List::stream) + .collect(Collectors.toList()); + final long[] timestamps = new long[] {message.getTimestamp()}; + final BitMap[] bitMaps = new BitMap[measurements.size()]; + final Object[] columns = + Stream.of(message.getValues(), message.getTagValues(), message.getAttributeValues()) + .flatMap(List::stream) + .toArray(Object[]::new); + final TSDataType[] dataTypes = new TSDataType[measurements.size()]; + final Tablet.ColumnCategory[] columnCategories = new Tablet.ColumnCategory[measurements.size()]; + final MeasurementSchema[] schemas = new MeasurementSchema[measurements.size()]; + for (int i = 0; i < message.getFields().size(); i++) { + dataTypes[i] = message.getDataTypes().get(i); + columnCategories[i] = Tablet.ColumnCategory.FIELD; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + for (int i = message.getFields().size(); + i < message.getFields().size() + message.getTagKeys().size(); + i++) { + dataTypes[i] = TSDataType.STRING; + columnCategories[i] = Tablet.ColumnCategory.TAG; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + for (int i = message.getFields().size() + message.getTagKeys().size(); + i + < message.getFields().size() + + message.getTagKeys().size() + + message.getAttributeKeys().size(); + i++) { + dataTypes[i] = TSDataType.STRING; + columnCategories[i] = Tablet.ColumnCategory.ATTRIBUTE; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + + final Tablet eventTablet = + new Tablet( + message.getTable(), + Arrays.asList(schemas), + Arrays.asList(columnCategories), + timestamps, + columns, + bitMaps, + 1); + + return new PipeRawTabletInsertionEvent( + true, + message.getDatabase(), Review Comment: better set "toLowerCase" here ########## iotdb-core/datanode/src/main/java/org/apache/iotdb/db/pipe/extractor/mqtt/MQTTPublishHandler.java: ########## @@ -0,0 +1,372 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +package org.apache.iotdb.db.pipe.extractor.mqtt; + +import org.apache.iotdb.common.rpc.thrift.TSStatus; +import org.apache.iotdb.commons.conf.IoTDBConstant.ClientVersion; +import org.apache.iotdb.commons.pipe.agent.task.connection.UnboundedBlockingPendingQueue; +import org.apache.iotdb.commons.pipe.agent.task.meta.PipeTaskMeta; +import org.apache.iotdb.commons.pipe.config.constant.PipeExtractorConstant; +import org.apache.iotdb.commons.pipe.config.plugin.env.PipeTaskExtractorRuntimeEnvironment; +import org.apache.iotdb.commons.pipe.event.EnrichedEvent; +import org.apache.iotdb.commons.service.metric.PerformanceOverviewMetrics; +import org.apache.iotdb.db.auth.AuthorityChecker; +import org.apache.iotdb.db.exception.query.QueryProcessException; +import org.apache.iotdb.db.pipe.event.common.tablet.PipeRawTabletInsertionEvent; +import org.apache.iotdb.db.protocol.mqtt.Message; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatManager; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatter; +import org.apache.iotdb.db.protocol.mqtt.TableMessage; +import org.apache.iotdb.db.protocol.mqtt.TreeMessage; +import org.apache.iotdb.db.protocol.session.IClientSession; +import org.apache.iotdb.db.protocol.session.MqttClientSession; +import org.apache.iotdb.db.protocol.session.SessionManager; +import org.apache.iotdb.db.queryengine.plan.Coordinator; +import org.apache.iotdb.db.utils.CommonUtils; +import org.apache.iotdb.db.utils.TimestampPrecisionUtils; +import org.apache.iotdb.db.utils.TypeInferenceUtils; +import org.apache.iotdb.pipe.api.customizer.parameter.PipeParameters; +import org.apache.iotdb.rpc.TSStatusCode; +import org.apache.iotdb.service.rpc.thrift.TSProtocolVersion; + +import io.moquette.interception.AbstractInterceptHandler; +import io.moquette.interception.messages.InterceptConnectMessage; +import io.moquette.interception.messages.InterceptDisconnectMessage; +import io.moquette.interception.messages.InterceptPublishMessage; +import io.netty.buffer.ByteBuf; +import io.netty.handler.codec.mqtt.MqttQoS; +import org.apache.tsfile.enums.TSDataType; +import org.apache.tsfile.utils.Binary; +import org.apache.tsfile.utils.BitMap; +import org.apache.tsfile.write.record.Tablet; +import org.apache.tsfile.write.schema.MeasurementSchema; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; + +import java.time.ZoneId; +import java.util.Arrays; +import java.util.List; +import java.util.concurrent.ConcurrentHashMap; +import java.util.stream.Collectors; +import java.util.stream.Stream; + +/** PublishHandler handle the messages from MQTT clients. */ +public class MQTTPublishHandler extends AbstractInterceptHandler { + + private static final Logger LOGGER = LoggerFactory.getLogger(MQTTPublishHandler.class); + + private final SessionManager sessionManager = SessionManager.getInstance(); + + private final ConcurrentHashMap<String, MqttClientSession> clientIdToSessionMap = + new ConcurrentHashMap<>(); + private final PayloadFormatter payloadFormat; + private final boolean useTableInsert; + private final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue; + private final String pipeName; + private final long creationTime; + private final PipeTaskMeta pipeTaskMeta; + + public MQTTPublishHandler( + final PipeParameters pipeParameters, + final PipeTaskExtractorRuntimeEnvironment environment, + final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue) { + this.payloadFormat = + PayloadFormatManager.getPayloadFormat( + pipeParameters.getStringOrDefault( + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_KEY, + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_DEFAULT_VALUE)); + useTableInsert = PayloadFormatter.TABLE_TYPE.equals(this.payloadFormat.getType()); + pipeName = environment.getPipeName(); + creationTime = environment.getCreationTime(); + pipeTaskMeta = environment.getPipeTaskMeta(); + this.pendingQueue = pendingQueue; + } + + @Override + public String getID() { + return "mqtt-source-broker-listener"; + } + + @Override + public void onConnect(InterceptConnectMessage msg) { + if (!clientIdToSessionMap.containsKey(msg.getClientID())) { + final MqttClientSession session = new MqttClientSession(msg.getClientID()); + sessionManager.login( + session, + msg.getUsername(), + new String(msg.getPassword()), + ZoneId.systemDefault().toString(), + TSProtocolVersion.IOTDB_SERVICE_PROTOCOL_V3, + ClientVersion.V_1_0, + useTableInsert ? IClientSession.SqlDialect.TABLE : IClientSession.SqlDialect.TREE); + sessionManager.registerSession(session); + clientIdToSessionMap.put(msg.getClientID(), session); + } + } + + @Override + public void onDisconnect(InterceptDisconnectMessage msg) { + final MqttClientSession session = clientIdToSessionMap.remove(msg.getClientID()); + if (null != session) { + sessionManager.removeCurrSession(); + sessionManager.closeSession(session, Coordinator.getInstance()::cleanupQueryExecution); + } + } + + @Override + public void onPublish(InterceptPublishMessage msg) { + try { + final String clientId = msg.getClientID(); + if (!clientIdToSessionMap.containsKey(clientId)) { + return; + } + final MqttClientSession session = clientIdToSessionMap.get(msg.getClientID()); + final ByteBuf payload = msg.getPayload(); + final String topic = msg.getTopicName(); + final String username = msg.getUsername(); + final MqttQoS qos = msg.getQos(); + + LOGGER.debug( + "Receive publish message. clientId: {}, username: {}, qos: {}, topic: {}, payload: {}", + clientId, + username, + qos, + topic, + payload); + + final List<Message> messages = payloadFormat.format(payload); + if (messages == null) { + return; + } + + for (Message message : messages) { + if (message == null) { + continue; + } + if (useTableInsert) { + final TableMessage tableMessage = (TableMessage) message; + // '/' previously defined as a database name + final String database = + !msg.getTopicName().contains("/") + ? msg.getTopicName() + : msg.getTopicName().substring(0, msg.getTopicName().indexOf("/")); + tableMessage.setDatabase(database.toLowerCase()); + extractTable(tableMessage, session); + } else { + extractTree((TreeMessage) message, session); + } + } + } catch (Throwable t) { + LOGGER.warn("onPublish execution exception, msg is [{}], error is ", msg, t); + } finally { + // release the payload of the message + super.onPublish(msg); + } + } + + /** Inserting table using tablet */ + private void extractTable(final TableMessage message, final MqttClientSession session) { + try { + TimestampPrecisionUtils.checkTimestampPrecision(message.getTimestamp()); + session.setDatabaseName(message.getDatabase().toLowerCase()); + session.setSqlDialect(IClientSession.SqlDialect.TABLE); + final EnrichedEvent event = generateEvent(message); + if (!event.increaseReferenceCount(MQTTPublishHandler.class.getName())) { + LOGGER.warn("The reference count of the event {} cannot be increased, skipping it.", event); Review Comment: ```suggestion LOGGER.warn("The reference count of the event {} cannot be increased, skipping it.", event); return; ``` ########## iotdb-core/datanode/src/main/java/org/apache/iotdb/db/pipe/extractor/mqtt/MQTTPublishHandler.java: ########## @@ -0,0 +1,372 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +package org.apache.iotdb.db.pipe.extractor.mqtt; + +import org.apache.iotdb.common.rpc.thrift.TSStatus; +import org.apache.iotdb.commons.conf.IoTDBConstant.ClientVersion; +import org.apache.iotdb.commons.pipe.agent.task.connection.UnboundedBlockingPendingQueue; +import org.apache.iotdb.commons.pipe.agent.task.meta.PipeTaskMeta; +import org.apache.iotdb.commons.pipe.config.constant.PipeExtractorConstant; +import org.apache.iotdb.commons.pipe.config.plugin.env.PipeTaskExtractorRuntimeEnvironment; +import org.apache.iotdb.commons.pipe.event.EnrichedEvent; +import org.apache.iotdb.commons.service.metric.PerformanceOverviewMetrics; +import org.apache.iotdb.db.auth.AuthorityChecker; +import org.apache.iotdb.db.exception.query.QueryProcessException; +import org.apache.iotdb.db.pipe.event.common.tablet.PipeRawTabletInsertionEvent; +import org.apache.iotdb.db.protocol.mqtt.Message; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatManager; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatter; +import org.apache.iotdb.db.protocol.mqtt.TableMessage; +import org.apache.iotdb.db.protocol.mqtt.TreeMessage; +import org.apache.iotdb.db.protocol.session.IClientSession; +import org.apache.iotdb.db.protocol.session.MqttClientSession; +import org.apache.iotdb.db.protocol.session.SessionManager; +import org.apache.iotdb.db.queryengine.plan.Coordinator; +import org.apache.iotdb.db.utils.CommonUtils; +import org.apache.iotdb.db.utils.TimestampPrecisionUtils; +import org.apache.iotdb.db.utils.TypeInferenceUtils; +import org.apache.iotdb.pipe.api.customizer.parameter.PipeParameters; +import org.apache.iotdb.rpc.TSStatusCode; +import org.apache.iotdb.service.rpc.thrift.TSProtocolVersion; + +import io.moquette.interception.AbstractInterceptHandler; +import io.moquette.interception.messages.InterceptConnectMessage; +import io.moquette.interception.messages.InterceptDisconnectMessage; +import io.moquette.interception.messages.InterceptPublishMessage; +import io.netty.buffer.ByteBuf; +import io.netty.handler.codec.mqtt.MqttQoS; +import org.apache.tsfile.enums.TSDataType; +import org.apache.tsfile.utils.Binary; +import org.apache.tsfile.utils.BitMap; +import org.apache.tsfile.write.record.Tablet; +import org.apache.tsfile.write.schema.MeasurementSchema; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; + +import java.time.ZoneId; +import java.util.Arrays; +import java.util.List; +import java.util.concurrent.ConcurrentHashMap; +import java.util.stream.Collectors; +import java.util.stream.Stream; + +/** PublishHandler handle the messages from MQTT clients. */ +public class MQTTPublishHandler extends AbstractInterceptHandler { + + private static final Logger LOGGER = LoggerFactory.getLogger(MQTTPublishHandler.class); + + private final SessionManager sessionManager = SessionManager.getInstance(); + + private final ConcurrentHashMap<String, MqttClientSession> clientIdToSessionMap = + new ConcurrentHashMap<>(); + private final PayloadFormatter payloadFormat; + private final boolean useTableInsert; + private final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue; + private final String pipeName; + private final long creationTime; + private final PipeTaskMeta pipeTaskMeta; + + public MQTTPublishHandler( + final PipeParameters pipeParameters, + final PipeTaskExtractorRuntimeEnvironment environment, + final UnboundedBlockingPendingQueue<EnrichedEvent> pendingQueue) { + this.payloadFormat = + PayloadFormatManager.getPayloadFormat( + pipeParameters.getStringOrDefault( + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_KEY, + PipeExtractorConstant.MQTT_PAYLOAD_FORMATTER_DEFAULT_VALUE)); + useTableInsert = PayloadFormatter.TABLE_TYPE.equals(this.payloadFormat.getType()); + pipeName = environment.getPipeName(); + creationTime = environment.getCreationTime(); + pipeTaskMeta = environment.getPipeTaskMeta(); + this.pendingQueue = pendingQueue; + } + + @Override + public String getID() { + return "mqtt-source-broker-listener"; + } + + @Override + public void onConnect(InterceptConnectMessage msg) { + if (!clientIdToSessionMap.containsKey(msg.getClientID())) { + final MqttClientSession session = new MqttClientSession(msg.getClientID()); + sessionManager.login( + session, + msg.getUsername(), + new String(msg.getPassword()), + ZoneId.systemDefault().toString(), + TSProtocolVersion.IOTDB_SERVICE_PROTOCOL_V3, + ClientVersion.V_1_0, + useTableInsert ? IClientSession.SqlDialect.TABLE : IClientSession.SqlDialect.TREE); + sessionManager.registerSession(session); + clientIdToSessionMap.put(msg.getClientID(), session); + } + } + + @Override + public void onDisconnect(InterceptDisconnectMessage msg) { + final MqttClientSession session = clientIdToSessionMap.remove(msg.getClientID()); + if (null != session) { + sessionManager.removeCurrSession(); + sessionManager.closeSession(session, Coordinator.getInstance()::cleanupQueryExecution); + } + } + + @Override + public void onPublish(InterceptPublishMessage msg) { + try { + final String clientId = msg.getClientID(); + if (!clientIdToSessionMap.containsKey(clientId)) { + return; + } + final MqttClientSession session = clientIdToSessionMap.get(msg.getClientID()); + final ByteBuf payload = msg.getPayload(); + final String topic = msg.getTopicName(); + final String username = msg.getUsername(); + final MqttQoS qos = msg.getQos(); + + LOGGER.debug( + "Receive publish message. clientId: {}, username: {}, qos: {}, topic: {}, payload: {}", + clientId, + username, + qos, + topic, + payload); + + final List<Message> messages = payloadFormat.format(payload); + if (messages == null) { + return; + } + + for (Message message : messages) { + if (message == null) { + continue; + } + if (useTableInsert) { + final TableMessage tableMessage = (TableMessage) message; + // '/' previously defined as a database name + final String database = + !msg.getTopicName().contains("/") + ? msg.getTopicName() + : msg.getTopicName().substring(0, msg.getTopicName().indexOf("/")); + tableMessage.setDatabase(database.toLowerCase()); + extractTable(tableMessage, session); + } else { + extractTree((TreeMessage) message, session); + } + } + } catch (Throwable t) { + LOGGER.warn("onPublish execution exception, msg is [{}], error is ", msg, t); + } finally { + // release the payload of the message + super.onPublish(msg); + } + } + + /** Inserting table using tablet */ + private void extractTable(final TableMessage message, final MqttClientSession session) { + try { + TimestampPrecisionUtils.checkTimestampPrecision(message.getTimestamp()); + session.setDatabaseName(message.getDatabase().toLowerCase()); + session.setSqlDialect(IClientSession.SqlDialect.TABLE); + final EnrichedEvent event = generateEvent(message); + if (!event.increaseReferenceCount(MQTTPublishHandler.class.getName())) { + LOGGER.warn("The reference count of the event {} cannot be increased, skipping it.", event); + } + pendingQueue.waitedOffer(event); + } catch (Exception e) { + LOGGER.warn( + "meet error when polling mqtt source message database {}, table {}, tags {}, attributes {}, fields {}, at time {}, because ", + message.getDatabase(), + message.getTable(), + message.getTagKeys(), + message.getAttributeKeys(), + message.getFields(), + message.getTimestamp(), + e); + } + } + + private PipeRawTabletInsertionEvent generateEvent(final TableMessage message) { + final List<String> measurements = + Stream.of(message.getFields(), message.getTagKeys(), message.getAttributeKeys()) + .flatMap(List::stream) + .collect(Collectors.toList()); + final long[] timestamps = new long[] {message.getTimestamp()}; + final BitMap[] bitMaps = new BitMap[measurements.size()]; + final Object[] columns = + Stream.of(message.getValues(), message.getTagValues(), message.getAttributeValues()) + .flatMap(List::stream) + .toArray(Object[]::new); + final TSDataType[] dataTypes = new TSDataType[measurements.size()]; + final Tablet.ColumnCategory[] columnCategories = new Tablet.ColumnCategory[measurements.size()]; + final MeasurementSchema[] schemas = new MeasurementSchema[measurements.size()]; + for (int i = 0; i < message.getFields().size(); i++) { + dataTypes[i] = message.getDataTypes().get(i); + columnCategories[i] = Tablet.ColumnCategory.FIELD; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + for (int i = message.getFields().size(); + i < message.getFields().size() + message.getTagKeys().size(); + i++) { + dataTypes[i] = TSDataType.STRING; + columnCategories[i] = Tablet.ColumnCategory.TAG; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + for (int i = message.getFields().size() + message.getTagKeys().size(); + i + < message.getFields().size() + + message.getTagKeys().size() + + message.getAttributeKeys().size(); + i++) { + dataTypes[i] = TSDataType.STRING; + columnCategories[i] = Tablet.ColumnCategory.ATTRIBUTE; + schemas[i] = new MeasurementSchema(measurements.get(i), dataTypes[i]); + } + + final Tablet eventTablet = + new Tablet( + message.getTable(), + Arrays.asList(schemas), + Arrays.asList(columnCategories), + timestamps, + columns, + bitMaps, + 1); + + return new PipeRawTabletInsertionEvent( + true, + message.getDatabase(), + null, + null, + eventTablet, + false, Review Comment: isAligned == true ########## iotdb-core/datanode/src/main/java/org/apache/iotdb/db/pipe/extractor/mqtt/MQTTPublishHandler.java: ########## @@ -0,0 +1,372 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +package org.apache.iotdb.db.pipe.extractor.mqtt; + +import org.apache.iotdb.common.rpc.thrift.TSStatus; +import org.apache.iotdb.commons.conf.IoTDBConstant.ClientVersion; +import org.apache.iotdb.commons.pipe.agent.task.connection.UnboundedBlockingPendingQueue; +import org.apache.iotdb.commons.pipe.agent.task.meta.PipeTaskMeta; +import org.apache.iotdb.commons.pipe.config.constant.PipeExtractorConstant; +import org.apache.iotdb.commons.pipe.config.plugin.env.PipeTaskExtractorRuntimeEnvironment; +import org.apache.iotdb.commons.pipe.event.EnrichedEvent; +import org.apache.iotdb.commons.service.metric.PerformanceOverviewMetrics; +import org.apache.iotdb.db.auth.AuthorityChecker; +import org.apache.iotdb.db.exception.query.QueryProcessException; +import org.apache.iotdb.db.pipe.event.common.tablet.PipeRawTabletInsertionEvent; +import org.apache.iotdb.db.protocol.mqtt.Message; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatManager; +import org.apache.iotdb.db.protocol.mqtt.PayloadFormatter; +import org.apache.iotdb.db.protocol.mqtt.TableMessage; +import org.apache.iotdb.db.protocol.mqtt.TreeMessage; +import org.apache.iotdb.db.protocol.session.IClientSession; +import org.apache.iotdb.db.protocol.session.MqttClientSession; +import org.apache.iotdb.db.protocol.session.SessionManager; +import org.apache.iotdb.db.queryengine.plan.Coordinator; +import org.apache.iotdb.db.utils.CommonUtils; +import org.apache.iotdb.db.utils.TimestampPrecisionUtils; +import org.apache.iotdb.db.utils.TypeInferenceUtils; +import org.apache.iotdb.pipe.api.customizer.parameter.PipeParameters; +import org.apache.iotdb.rpc.TSStatusCode; +import org.apache.iotdb.service.rpc.thrift.TSProtocolVersion; + +import io.moquette.interception.AbstractInterceptHandler; +import io.moquette.interception.messages.InterceptConnectMessage; +import io.moquette.interception.messages.InterceptDisconnectMessage; +import io.moquette.interception.messages.InterceptPublishMessage; +import io.netty.buffer.ByteBuf; +import io.netty.handler.codec.mqtt.MqttQoS; +import org.apache.tsfile.enums.TSDataType; +import org.apache.tsfile.utils.Binary; +import org.apache.tsfile.utils.BitMap; +import org.apache.tsfile.write.record.Tablet; +import org.apache.tsfile.write.schema.MeasurementSchema; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; + +import java.time.ZoneId; +import java.util.Arrays; +import java.util.List; +import java.util.concurrent.ConcurrentHashMap; +import java.util.stream.Collectors; +import java.util.stream.Stream; + +/** PublishHandler handle the messages from MQTT clients. */ +public class MQTTPublishHandler extends AbstractInterceptHandler { Review Comment: Can we just extend the "MPPPublishHandler"? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: reviews-unsubscr...@iotdb.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org