如果一个表有很多列，如何写定义的脚本看起来会清晰一点

如果一个表有100多列，我使用下面的代码创建，确认name和type对应的问题会很不方便：

t = table(1000:0, `TradeDate`TradeTime`SecurityID`TradePrice`TradeVolume`TradeBSFlag……, [DATE, TIME, SYMBOL,DOUBLE,DOUBLE,SYMBOL……])

请问有其它的创建方法吗？

0 条评论
分类：技术问答

默认排序时间排序

1 个回答

Jason Tang - 时序数据库技术支持 2021-07-21 18:19

可以尝试这样的写法：

schemaTable=table(	
	array(SYMBOL,0) as  symbol,
	array(SYMBOL,0) as  market,
	array(DATE,0) as  date,
	array(TIME,0) as  time,
	array(DOUBLE,0) as  preClose,
	array(DOUBLE,0) as  open,
	array(DOUBLE,0) as  high,
	array(DOUBLE,0) as  low,
	array(DOUBLE,0) as  last,
	array(INT,0) as  numTrades,
	array(INT,0) as  curNumTrades,
	array(INT,0) as  volume,
	array(INT,0) as  curVol,
	array(DOUBLE,0) as  turnover,
	array(INT,0) as  curTurnover,
	array(INT,0) as  peratio1,
	array(INT,0) as  peratio2,
	array(INT,0) as  totalAskVolume,
	array(DOUBLE,0) as  wavgAskPrice,
	array(INT,0) as  askLevel,
	array(INT,0) as  totalBidVolume,
	array(DOUBLE,0) as  wavgBidPrice,
	array(INT,0) as  bidLevel,
	array(DOUBLE,0) as  iopv,
	array(INT,0) as  ytm
)

如果一个表有很多列，如何写定义的脚本看起来会清晰一点

1 个回答

相似问题