'Unable to Insert/Create Table from Query Results in IMPALA

select * 
into temp_DB.TEMP2
from MyDb.Mytable

Error:

AnalysisException: Syntax error in line 2:undefined: into MyDb.Mytable ^ Encountered: INTO Expected: FROM, LIMIT, ORDER, UNION, COMMA CAUSED BY: Exception: Syntax error

sql-insert impala

Solution 1:^[1]

Resolved:

CREATE TABLE temp_DB.TEMP2 AS select * from MyDb.Mytable

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	cigien

'Unable to Insert/Create Table from Query Results in IMPALA

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]