Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
case_expr
/
castToBoln_63.q
blob: 65e646006dbe1270025898222efe6a9631b21080 [
file
] [
log
] [
blame
]
SELECT count
(
CAST
(
columns
[
0
]
AS integer
))
count_c1
,
CAST
(
columns
[
1
]
AS BOOLEAN
)
c2 FROM
`bools.csv`
GROUP BY CAST
(
columns
[
1
]
AS BOOLEAN
)
ORDER BY CAST
(
columns
[
1
]
AS BOOLEAN
);