> My goal is to create separate independent processing units (queries) >that can then be composed into larger queries. Effectively something like:
Ah, modularization beyond a single statement. Views would be the right thing there as a permanent abstraction. I like CTEs during dev is because I can do the equivalent of "illustrate" easily & read like 10 rows off each alias. Though I have to pull out the with alias & test it independently. > WITH a AS (SELECT ... FROM A); > // I would now like to be able to test 'a' I wish we had a "CREATE TEMPORARY VIEW IF NOT EXISTS" for something like this. Adding views into the metastore using "create view" involves stomping on the public namespace & manual cleanups. Cheers, Gopal
