pivot by的奇怪问题

试一下分两部 t=select tradetime,securityid,factorname,value from loadTable('dfs://K_FACTOR_LONG','factor_k_long') where (securityid = `US_MSFT) and (tradetime between timestamp(2023.11.02):timestamp(2023.12.03) ) select value from t pivot by tradetime,securityid,factorname

回答于 2023-12-04 11:18