decade
decade
> 可以给一下配置 ``` "shardingTables":{ "hunt_industry":{ "createTableSQL":"CREATE TABLE IF NOT EXISTS `headhunt`.`hunt_industry` (\n\t`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',\n\t`industry_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '行业名称',\n\t`parent_id` int...
> 接下来又报了这个错: ` rg.apache.calcite.runtime.CalciteContextException: At line 0, column 0: Expression 'hc.create_time' is not being grouped `
> 还不行就把涉及的表的建表语句给我,说明哪个是分片表 ### 依然报错,以下是配置内容: ``` "hunt_customer":{ "function":{ "properties":{ "dbNum":"2", "mappingFormat":"c${targetIndex}/headhunt_${dbIndex}/hunt_customer_${tableIndex}", "storeNum":1, "dbMethod":"mod_hash(tenant_id)" } }, "shardingIndexTables":{} }, "hunt_user":{ "function":{ "properties":{ "dbNum":"2", "mappingFormat":"c${targetIndex}/headhunt_${dbIndex}/hunt_user_${tableIndex}", "storeNum":1, "dbMethod":"mod_hash(tenant_id)" } }, "shardingIndexTables":{} }, ``` ### 建表SQL:...
> 涉及分片表不支持with子句 可是hunt_dictionary 这张表是normal table,并不是分片表
> hunt_dictionary_type 是什么表,你把配置发出来看看 ``` { "customTables":{}, "globalTables":{}, "normalProcedures":{}, "normalTables":{ "hunt_dictionary_type":{ "createTableSQL":"CREATE TABLE IF NOT EXISTS `headhunt`.`hunt_dictionary_type` (\n\t`id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',\n\t`type_view` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci...