Please look at these examples on the documentation links below
here is the link to supported datatypes in Drill -
https://drill.apache.org/docs/supported-data-types/
and link to CTAS in Drill -
http://drill.apache.org/docs/create-table-as-ctas-command/
On Thu, Dec 29, 2016 at 4:40 PM, Manjeet
Hi
I am trying below query
USE dfs;
CREATE table dfs.`view_name`(AAA String,
Domain String,
certValidity String,
protocol String,
LastActive String,
GetCount DOUBLE,
PostCount DOUBLE,
Data_Transfer DOUBLE,
Data_Receive DOUBLE,
Total_Communication DOUBLE,
Last_Active String)AS