Charles, Drill does not have a metastore for tables, so unless you have defined a view with CAST or are querying Hive tables (Hive has a metastore), the column types are determined at run-time. Have you tried the typeof() function ? SELECT typeof(column) FROM dfs.`data.json` LIMIT 1;
On Sun, Dec 4, 2016 at 8:47 AM, Charles Givre <[email protected]> wrote: > Hello all, > I’m trying to figure out if there is some way to determine what types of > columns a given data source contains. It looks like this should exist in > the INFORMATION_SCHEMA somewhere, but I’m not clear how to do it. > > For instance, let’s say that I have a file called data.json. I could > execute: > SELECT * > FROM dfs.`data.json` > LIMIT 0 > and get the column names, but is there some way to get at the data types > for these columns? > TIA, > — Charles
