martint
commented
7 years ago Yes, but the syntax would be:
INSERT INTO s1
WITH q1 AS (...)
SELECT * FROM q1Closed bdm123 closed 7 years ago
martint
commented
7 years ago Yes, but the syntax would be:
INSERT INTO s1
WITH q1 AS (...)
SELECT * FROM q1
Is there support for the following HiveQL statement or similar without creating intermediate tables?
WITH q1 AS (SELECT key, value FROM src WHERE key = '5') FROM q1 INSERT INTO s1 SELECT *;