Thank you for the syntax.How do I insert data into this created temp table. When I use SQL syntax it gives me an error message..AnalysisException: Can only write data to relations with a single path.
When there is a complex logic which takes long time to process using TEMP views for further processing will take processing time of the calling script + the time of the TEMP view which is not optimal in DBMS. SAme effect or slower than writing the te...
