tba=select * from tba;
tbc = tba join tmptb
dolphindb中已存在表包含6列,现在想从另一文件读出一列,增加到已存在的表中,并且对应赋值。
fn="/home/shuser/000998.XSHE.csv"
tb = "tab1"
col = "datetime"
dm=","
db=database("dfs://STKDB1")
schemaTB=extractTextSchema(fn)
loadTextEx(db, tb, col, fn, dm,schemaTB)
fn="/home/shuser/000998a.XSHE.csv"
tb = "tab2"
col = "datetime"
dm=","
db=database("dfs://STKDB1")
schemaTB=extractTextSchema(fn)
tmptb = loadText(fn,dm,schemaTB)
//select * from tmptb
tba = loadTable("dfs://STKDB1","tab1")
//select * from tba;
//addColumn(tba,["ma"],[double]);
//append!(tb,)
tbc = tba join tmptb
tbc
报错:tbc = tba <- tmptb => The two objects to be joined must have the same number of rows.
但实际上两个文件的行数是一样的