用元编程的方式可实现，示例如下：

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