Can you say more about what you mean by this? Would this kind of thing help?
WITH foo as (select * from yadda_yadda) ... https://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL#Common_table_expression On Thu, May 26, 2016 at 5:41 PM, Andrew Evans <[email protected] > wrote: > I was looking for the implicit table creation in a Select statement > without using CREATE TABLE table AS .... > ________________________________________ > ... > > You can read read strings that contain json as if they were json data > already. > > See https://drill.apache.org/docs/data-type-conversion/ >
