group_by_tz_date.sql « aggregate « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/aggregate/group_by_tz_date.sql

blob: 603c7ea45e27c0357bd5d7bfc89e61d8c38bd98b (plain) (blame)

1
2
3

SELECT SUM(CAST(subkey AS Uint8)) AS sum
FROM plato.Input5
GROUP BY CAST(CAST(key AS Uint16) AS TzDate);