请问这个问题您那边是否必现?
我2.00.9版本,试了复现不了。
在已有库中新建第二个分布表时,表名被自动添加字母e。
执行如下:
def createDB(dbName){
if(existsDatabase(dbName))
dropDatabase(dbName)
database(dbName, RANGE, date(2000.01M + 0..40*12) ,engine = 'TSDB')
}
def createPT1(dbName,tableName){
db=database(dbName, RANGE, date(2000.01M + 0..40*12) ,engine = 'TSDB')
if(existsTable(dbName,tableName))
dropTable(db,tableName)
columns =`stock`exchange`date`frequency`open`high`low`close`volume`amount
type=[SYMBOL,SYMBOL,DATE,SYMBOL,DOUBLE,DOUBLE,DOUBLE,DOUBLE,LONG,DOUBLE]
orderData = table(1:0, columns,type)
db.createPartitionedTable(orderData, tableName,partitionColumns=`date, sortColumns=`stock`date,keepDuplicates=LAST)
}
def createPT2(dbName,tableName){
db=database(dbName)
if(existsTable(dbName,tableName))
dropTable(db,tableName)
columns2=`stock`date`close`tov_rate
type2=`SYMBOL`DATE`DOUBLE`DOUBLE
orderData = table(1:0, columns2,type2)
db.createPartitionedTable(orderData, tableName,partitionColumns=`date, sortColumns=`stock`date,keepDuplicates=LAST)
}
dbName = "dfs://day_data"
tableName1 = `daily_kline
tableName2 = `daily_basic
//createDB(dbName)
//createPT1(dbName,tableName1)
createPT2(dbName,tableName2)
新建第二个分布表后,查询表daily_basic报错路径错误,查询表daily_basice显示正常。
请问这是什么原因,可以解决吗?