DolphinDB:创建分区表

Question

请问是哪里出了问题?

//创建数据库
deviceId = "device" + string(1..100000) 
db1 = database("", VALUE, 2019.06.01..2019.06.30) 
db2 = database("", HASH, INT:20) 
db = database("dfs://repartitionExample", COMPO, [db1, db2]) 

// 创建DFS表 
t = db.createPartitionedTable(table(100000:0, `deviceId`time`temperature, [SYMBOL,DATETIME,DOUBLE]), `tb, `deviceId`time)

Usage: createPartitionedTable(dbHandle, table, tableName, partitionColumns, [compressMethods]). The data type of partition column [deviceId] doesn't match the partition scheme in dbHandle.

Answer 1

你的哈希分区数据类型是INT，而创建表格时候deviceId的数据类型是symbol，数据类型不匹配导致无法创建分区表。