mycat按年月分表

vim /usr/local/mycat/conf/schema.xml

<table name="tb_flow_data1" dataNode="dn1" subTables="tb_flow_data12019_$1-12, tb_flow_data12020_$1-12, tb_flow_data12021_$1-12, tb_flow_data12022_$1-12" rule="sharding-by-month"/>

vim /usr/local/mycat/conf/rule.xml

<tableRule name="sharding-by-month">
<rule>
<columns>tm</columns>
<algorithm>sharding-by-month</algorithm>
</rule>
</tableRule>

<function name="sharding-by-month" class="io.mycat.route.function.PartitionByMonth">
<property name="dateFormat">yyyy-MM</property>
<property name="sBeginDate">2019-01</property>

</function>