Hi, I have created a global temp table in the test database and executed the Collect stats statement successfully but I am unable to Select * that table. Also am able to drop it. I executed the select following select statement successfully but fetched now rows. Can any body suggest me how to fetch the rows from the temp table using the following queries.
CREATE GLOBAL TEMPORARY TABLE test.Raj_test (product_id DECIMAL(18,0));
INSERT INTO Raj_test SELECT item_id FROM views.product; --57 rows are inserted
COLLECT STATS ON TEMPORARY test. Raj_test COLUMN(upc_cd); --Executed successfully
SEL * FROM test. Raj_test; -- Getting now rows (How to sel * from the temp table). --Note: Though 57 rows are inserted , we are ubale to Sel *