SELECT YYYYMMDD, cv, idx FROM tbla
MODEL
RETURN UPDATED ROWS
PARTITION BY (YYYYMMDD)
DIMENSION BY ('x' AS idx)
MEASURES ( 'aa' as cv,
V01,V02,V03,V04,V05,V06,V07,V08,V09,V10,
V11,V12,V13,V14,V15,V16,V17,V18,V19,V20,
V21,V22,V23,V24,V25,V26,V27,V28,V29,V30,
V31,V32,V33,V34,V35,V36,V37,V38,V39,V40,
V41,V42,V43,V44,V45,V46,V47,V48)
RULES UPSERT ALL
(
cv[1]   = V01['x'],
cv[2]   = V02['x'],
cv[3]   = V03['x'],
cv[4]   = V04['x'],
cv[5]   = V05['x'],
cv[6]   = V06['x'],
cv[7]   = V07['x'],
cv[8]   = V08['x'],
cv[9]   = V09['x'],
cv[10] = V10['x'],
cv[11] = V11['x'],
cv[12] = V12['x'],
cv[13] = V13['x'],
cv[14] = V14['x'],
cv[15] = V15['x'],
cv[16] = V16['x'],
cv[17] = V17['x'],
cv[18] = V18['x'],
cv[19] = V19['x'],
cv[20] = V20['x'],
cv[21] = V21['x'],
cv[22] = V22['x'],
cv[23] = V23['x'],
cv[24] = V24['x'],
cv[25] = V25['x'],
cv[26] = V26['x'],
cv[27] = V27['x'],
cv[28] = V28['x'],
cv[29] = V29['x'],
cv[30] = V30['x'],
cv[31] = V31['x'],
cv[32] = V32['x'],
cv[33] = V33['x'],
cv[34] = V34['x'],
cv[35] = V35['x'],
cv[36] = V36['x'],
cv[37] = V37['x'],
cv[38] = V38['x'],
cv[39] = V39['x'],
cv[40] = V40['x'],
cv[41] = V41['x'],
cv[42] = V42['x'],
cv[43] = V43['x'],
cv[44] = V44['x'],
cv[45] = V45['x'],
cv[46] = V46['x'],
cv[47] = V47['x'],
cv[48] = V48['x']
)
ORDER BY YYYYMMDD,cv,idx;