我的数据库是用下面的脚本创建的,按日期和品种进行值分区:
DB_DIR="dfs://future";
db1 = database(,VALUE, 2018.01.01..2019.12.31);
db2 = database(,VALUE,`IC`IF) ;
db = database(DB_DIR, COMPO, [db1, db2]);
columns =`ID_`TaskID`JobID`TradingDay`ActionDay`Timestamp`UpdateTime`UpdateMillisec`InstrumentID`ProductID`ExchangeID`ExchangeInstID`LastPrice`PreSettlementPrice`PreClosePrice`PreOpenInterest`OpenPrice`HighestPrice`LowestPrice`Volume`Turnover`OpenInterest`ClosePrice`SettlementPrice`UpperLimitPrice`LowerLimitPrice`PreDelta`CurrDelta`BidPrice1`BidVolume1`AskPrice1`AskVolume1`BidPrice2`BidVolume2`AskPrice2`AskVolume2`BidPrice3`BidVolume3`AskPrice3`AskVolume3`BidPrice4`BidVolume4`AskPrice4`AskVolume4`BidPrice5`BidVolume5`AskPrice5`AskVolume5`AveragePrice
columntypes =[LONG,LONG,LONG,DATE,DATE,TIMESTAMP,SECOND,INT,SYMBOL,SYMBOL,SYMBOL,SYMBOL,DOUBLE,DOUBLE,DOUBLE,LONG,DOUBLE,DOUBLE,DOUBLE,LONG,DOUBLE,LONG,DOUBLE,DOUBLE,DOUBLE,DOUBLE,DOUBLE,DOUBLE,DOUBLE,LONG,DOUBLE,LONG,DOUBLE,LONG,DOUBLE,LONG,DOUBLE,LONG,DOUBLE,LONG,DOUBLE,LONG,DOUBLE,LONG,DOUBLE,LONG,DOUBLE,LONG ,DOUBLE]
ticks = db.createPartitionedTable(table(100:0,columns, columntypes),`ticks,`TradingDay`ProductID);
现在我想增加日期值分区,代码如下:
db= database("dfs://future")
addValuePartitions(db,2020.01.01..2020.01.10,0)
但执行后报错:
getSymbolConst method not supported
请问该如何增加分区?怎么知道分区有没有加成功,或怎么查看数据库已有哪些分区?