用元编程的方式可实现,示例如下:
t=table(2015.01.05 as date,2015.01.05T09:30:00 as datetime,1.0 as `000001,2.0 as `000002,3.0 as `000003)
sql(select =sqlCol(t.colNames()[2:],max),from =t,groupBy=sqlCol(`date)).eval()
执行后,输出如下所示:
date 000001 000002 000003 2015.01.05 1 2 3