Can I know what is difference between view and tables in Drill?
Hi Mark Dendrix Garcia,
Were you referring to CTAS or CTTAS? Just remember you can't create a view over a temporary table.
A view can combine data from multiple underlying data sources and provide the illusion that all of the data is from one source. (copied from https://drill.apache.org/docs/create-view/)
My understanding is that table is more like a directory, and temporary table can store queries within the same session to improve query performance. Hope that helps.
Retrieving data ...