hive里表数据同步到mysql

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<flowController>
    <processGroups>
        <processGroup>
            <id>root</id>
            <position>
                <x>0.0</x>
                <y>0.0</y>
            </position>
            <contents>
                <processor>
                    <id>hive-to-mysql</id>
                    <parentGroupId>root</parentGroupId>
                    <position>
                        <x>200.0</x>
                        <y>200.0</y>
                    </position>
                    <type>org.apache.nifi.processors.hive.HiveQueryProcessor</type>
                    <bundle>
                        <artifact>org.apache.nifi:nifi-hive-nar:2.0.0</artifact>
                        <group>org.apache.nifi</group>
                        <version>2.0.0</version>
                    </bundle>
                    <properties>
                        <property name="Hive Database">default</property>
                        <property name="Hive Query">SELECT * FROM your_hive_table</property>
                        <property name="Hive Result Format">CSV</property>
                    </properties>
                </processor>
                <processor>
                    <id>put-mysql</id>
                    <parentGroupId>root</parentGroupId>
                    <position>
                        <x>400.0</x>
                        <y>200.0</y>
                    </position>
                    <type>org.apache.nifi.processors.standard.PutSQL</type>
                    <bundle>
                        <artifact>org.apache.nifi:nifi-standard-nar:2.0.0</artifact>
                        <group>org.apache.nifi</group>
                        <version>2.0.0</version>
                    </bundle>
                    <properties>
                        <property name="Database Connection URL">jdbc:mysql://localhost:3306/your_database</property>
                        <property name="Username">your_username</property>
                        <property name="Password">your_password</property>
                        <property name="SQL Statement">INSERT INTO your_mysql_table VALUES (?, ?, ?)</property>
                    </properties>
                </processor>
            </contents>
        </processGroup>
    </processGroups>
</flowController>