blob: d8cbee145b7358e12fe78a7c40b3f9a9e82bea39 [file] [log] [blame]
select
ROUND(EXTRACT(year from CONVERT_FROM(c_timestamp, 'TIMESTAMP_IMPALA'))),
count(*)
from
imp_t1
group by
ROUND(EXTRACT(year from CONVERT_FROM(c_timestamp, 'TIMESTAMP_IMPALA')))
order by
1,2;