Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
cttas
/
cttas_on_view_b.sql.fail
blob: f0de353ebc98a2f18f9eed086609db48b983109c [
file
] [
log
] [
blame
]
CREATE VIEW v2 AS SELECT
*
FROM typeall_l
;
CREATE TEMPORARY TABLE temp_tbl_v2 PARTITION BY
(
col_chr
)
AS SELECT
*
FROM v2
;
SELECT col_int
,
col_chr
,
col_vrchr1
,
col_vrchr2
,
col_dt
,
col_bln FROM temp_tbl_v2
;
DROP TABLE temp_tbl_v2
;
DROP VIEW v2
;