Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
case_expr
/
castToBooln_9.q
blob: 4290cbc587777c2adc2d2edb8239139b663a3792 [
file
] [
log
] [
blame
]
CREATE TABLE TBL_ON_BLN_9
(
c1
,
c2
,
c3
,
c4
)
AS SELECT cast
(
columns
[
0
]
as
int
),
cast
(
columns
[
1
]
as
boolean
),
cast
(
columns
[
2
]
as
char
(
2
)),
cast
(
columns
[
3
]
as
varchar
(
64
))
FROM
`bools.csv`
;
select
count
(*)
from
TBL_ON_BLN_9
;
DROP TABLE TBL_ON_BLN_9
;