我有一个h5文件,运行下面代码,
use hdf5
dataFilePath = "/home/database/v10012/server/comm-ticks-updates1.hdf5"
datasetName = "/A2005/20200506"
schema=hdf5::extractHDF5Schema(dataFilePath,datasetName)
tmpTB = hdf5::loadHDF5(dataFilePath,datasetName)
得到schema如下所示:
数据集tmpTB如下所示:
现在我要h5文件的数据导入下列DolphinDB分布式表:
db1 = database("", VALUE, 2020.01.01..2020.12.31)
db2 = database("", HASH,[SYMBOL,3])
db = database("dfs://future",COMPO, [db1,db2])
colNames=`instrument`tradingday`calendarday`time`lastp`volume`openinterest`turnover`ask1`asksz1`bid1`bidsz1
colTypes=[SYMBOL,DATE,DATE,TIME,DOUBLE,INT,DOUBLE,DOUBLE,DOUBLE,INT,DOUBLE,INT]
t=table(1:0,colNames,colTypes)
transpt=db.createPartitionedTable(t,`tick,`tradingday`instrument)
碰到一个问题就是tradingday、calendarday、time的值如何从整数抓换成DATE和TIME,也即20200506如何转换成2020.05.06,900003376如何转换成9:00:03.376?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…