Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.1.0
-
None
Description
CTAS with PARTITION BY clause fails to resolve column name when partitioning column is from a view.
0: jdbc:drill:schema=dfs.tmp> create table ctas_prtng_01 partition by (col_vchar_52) as select * from vwOnParq_wCst; Error: SYSTEM ERROR: IllegalArgumentException: partition col col_vchar_52 could not be resolved in table's column lists! [Error Id: 7cb227c1-65c5-48cb-a00b-1a89a5309bc8 on centos-04.qa.lab:31010] (state=,code=0)
Table used in above CTAS does exist and the column used to partition by also exists.
0: jdbc:drill:schema=dfs.tmp> describe vwOnParq_wCst; +---------------+--------------------+--------------+ | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | +---------------+--------------------+--------------+ | col_int | INTEGER | YES | | col_bigint | BIGINT | YES | | col_char_2 | CHARACTER | YES | | col_vchar_52 | CHARACTER VARYING | YES | | col_tmstmp | TIMESTAMP | YES | | col_dt | DATE | YES | | col_booln | BOOLEAN | YES | | col_dbl | DOUBLE | YES | | col_tm | TIME | YES | +---------------+--------------------+--------------+ 9 rows selected (0.411 seconds)