Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
int96
/
q12.sql_drill5495
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
;