Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
group_by_alias
/
group_by_having_2_aliases.sql
blob: c2e7f6d5d4ff1d0bef1623c98be0313537822bef [
file
] [
log
] [
blame
]
select
intField i
,
count
(
intField
)
ci
,
strField s
,
count
(
strField
)
cs
from
dfs
.
drillTestDir
.`
DRILL-1248
/
group_by_parquet
`
group
by
i
,
3
having
ci
>
1
AND
cs
>
2
;