Sign in
apache
/
drill-test-framework
/
b5ed55188c294aa172ccc7d30e7981884fedc8f0
/
.
/
framework
/
resources
/
Functional
/
case_expr
/
castToBooln_5.q
blob: 65238892f67f239ab783331161894229f017828d [
file
] [
log
] [
blame
]
CREATE OR REPLACE VIEW VW_ON_BLN_5
(
c1
,
c2
,
c3
)
AS SELECT cast
(
columns
[
0
]
as
int
),
cast
(
columns
[
1
]
as
boolean
),
cast
(
columns
[
2
]
as
char
(
2
))
FROM
`bools.csv`
;
select
count
(
c1
),
c2
from
VW_ON_BLN_5
group
by
c2 order
by
c2
;
DROP VIEW VW_ON_BLN_5
;