I run queries in Hive...I wanted to create a temporary tables to save intermediate results of a complex query. Here is my query:
CREATE TEMPORARY TABLE test AS SELECT * FROM my_table LIMIT 100
The query ran through without reporting an error. But when I did a select statement from the table I got this error "Table test is not found". Is temporary table supported in Hive? I read docs and posts here and there. Most say yes so I do not know what is wrong.