在使用join引擎时左右两表有相同的字段名在metric中如何区分?

share streamTable(1:0, `time`sym`factor, [TIMESTAMP, SYMBOL, DOUBLE]) as table1

share streamTable(1:0, `time`sym`factor, [TIMESTAMP, SYMBOL, DOUBLE]) as table2

在使用join引擎关联table1和table2时,在metrics中如何区分factor字段

请先 登录 后评论

1 个回答

Yating Xie

用table1.factor 这样的写法

share streamTable(1:0, `time`sym`factor, [TIMESTAMP, SYMBOL, DOUBLE]) as table1
share streamTable(1:0, `time`sym`factor, [TIMESTAMP, SYMBOL, DOUBLE]) as table2
prevailingQuotes=table(100:0, `time`sym`factor1`factor2, [TIMESTAMP, SYMBOL, DOUBLE, DOUBLE])
ajEngine=createAsofJoinEngine(name="aj1", leftTable=table1, rightTable=table2, outputTable=prevailingQuotes, metrics=<[table1.factor, table2.factor]>, matchingColumn=`sym, timeColumn=`time, useSystemTime=false, delayedTime=1)
请先 登录 后评论
  • 1 关注
  • 0 收藏,1125 浏览
  • BMO 提出于 2022-04-21 21:53