Q:
Server response: 'The number of partitions [85380] relevant to the query is too large. Please add more specific filtering conditions on partition columns in WH
ERE clause, or consider changing the value of the configuration parameter maxPartitionNumPerQuery.'
A:
分区太多了,有可能超过了maxPartitionNumPerQuery。尝试改变分区策略或重新设置maxPartitionNumPerQuery大小。
dbDate=database(, partitionType=VALUE, partitionScheme=2000.01.01..2099.12.30)
dbCode=database(, partitionType=HASH, partitionScheme=[SYMBOL,3])
db = database(dbName, partitionType=COMPO, partitionScheme=[dbDate,dbCode],engine='TSDB',atomic='CHUNK')
如上面一句,会产生365 * 100 * 3 = 109500个分区。远超 maxPartitionNumPerQuery默认值65536。所以建议调整分区大小:如:partitionScheme=2022.01.01..2050.12.01