I was looking for the implicit table creation in a Select statement without using CREATE TABLE table AS .... ________________________________________ From: Ted Dunning [[email protected]] Sent: Thursday, May 26, 2016 10:40 AM To: user Subject: Re: One more with Excepting Columns by name
On Thu, May 26, 2016 at 4:09 PM, Andrew Evans <[email protected] > wrote: > I ended up with this. I just don't know why some things don't exist. Some, > I think are new but others such as being able to read strings as json from > a database would be really helpful. Being able to read in Json, Hstore, and > XML from PostgreSQL like it were on the file system would be great. Thanks > for the help. The tool is really beneficial in lowering maintenance time > costs for ETL. You can read read strings that contain json as if they were json data already. See https://drill.apache.org/docs/data-type-conversion/
