PREHOOK: query: DROP VIEW xxx8
PREHOOK: type: DROPVIEW
POSTHOOK: query: DROP VIEW xxx8
POSTHOOK: type: DROPVIEW
PREHOOK: query: DROP VIEW xxx9
PREHOOK: type: DROPVIEW
POSTHOOK: query: DROP VIEW xxx9
POSTHOOK: type: DROPVIEW
PREHOOK: query: -- create two levels of view reference, then invalidate intermediate view
-- by dropping a column from underlying table, and verify that
-- querying outermost view results in full error context
CREATE TABLE xxx10 (key int, value int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: -- create two levels of view reference, then invalidate intermediate view
-- by dropping a column from underlying table, and verify that
-- querying outermost view results in full error context
CREATE TABLE xxx10 (key int, value int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@xxx10
PREHOOK: query: CREATE VIEW xxx9 AS SELECT * FROM xxx10
PREHOOK: type: CREATEVIEW
PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-05-06_18-21-57_294_3082316283829832124/-mr-10000
POSTHOOK: query: CREATE VIEW xxx9 AS SELECT * FROM xxx10
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@xxx9
POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-05-06_18-21-57_294_3082316283829832124/-mr-10000
PREHOOK: query: CREATE VIEW xxx8 AS SELECT * FROM xxx9 xxx
PREHOOK: type: CREATEVIEW
PREHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-05-06_18-21-57_322_9196564361024798339/-mr-10000
POSTHOOK: query: CREATE VIEW xxx8 AS SELECT * FROM xxx9 xxx
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@xxx8
POSTHOOK: Output: file:/var/folders/5V/5V4Zq77qGD4aSK9m8V3frVsFdRU/-Tmp-/salbiz/hive_2011-05-06_18-21-57_322_9196564361024798339/-mr-10000
PREHOOK: query: ALTER TABLE xxx10 REPLACE COLUMNS (key int)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@xxx10
PREHOOK: Output: default@xxx10
POSTHOOK: query: ALTER TABLE xxx10 REPLACE COLUMNS (key int)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@xxx10
POSTHOOK: Output: default@xxx10
FAILED: Error in semantic analysis: Line 1:30 Invalid column reference `value` in definition of VIEW xxx9 [
SELECT `xxx10`.`key`, `xxx10`.`value` FROM `xxx10`
] used as xxx at Line 1:39 in definition of VIEW xxx8 [
SELECT `xxx`.`key`, `xxx`.`value` FROM `xxx9` `xxx`
] used as yyy at Line 2:14