[IMPALA-5401] CTAS does not allow creating tables as SEQUENCEFILE even with ALLOW_UNSUPPORTED_FORMATS=true

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: Impala 2.8.0, Impala 2.9.0
• Component/s: Frontend
• Labels: bugbash-2017-05-31
• Epic Color: ghx-label-3
• Assignee: Unassigned
• Reporter: Alexander Behm
• Created: 31/May/17 18:53
• Updated: 14/Nov/18 16:33
• Resolved: 14/Nov/18 16:33

Description

Repro:

set allow_unsupported_formats=true;
create table test stored as sequencefile as select * from functional.alltypes;
ERROR: AnalysisException: CREATE TABLE AS SELECT does not support the (SEQUENCEFILE) file format. Supported formats are: (PARQUET, TEXTFILE, KUDU)