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 SELECT 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 FROM dfs.`/Users/drilluser/apache-drill-1.0/sample-sata/nation.parquet`; still getting error can anyone suggest me what I am doing wrong second can anyone share how to create table over parquet file which is on hdfs? On Tue, Dec 27, 2016 at 2:52 AM, Ted Dunning <[email protected]> wrote: > On Sun, Dec 25, 2016 at 9:56 PM, Manjeet Singh <[email protected] > > > wrote: > > > CREATE TABLE 'ttttt'( > > "AAA", "Domain", "certValidity", "protocol", "LastActive", "GetCount", > > "PostCount", "Data_Transfer", "Data_Receive", "Total_Communication", > > "Last_Active") AS SELECT "AAA", "Domain", "certValidity", "protocol", > > "LastActive", "GetCount", "PostCount", "Data_Transfer", "Data_Receive", > > "Total_Communication", "Last_Active" FROM > > dfs."/user/Domain-1-_1481273732716/*"; > > > > You aren't specifying where your new table will be created. THis is > probably in dfs. You may also need to provide a workspace. For instance, > when I was creating a file this morning I used this: > > create table maprfs.ted.fooble as ... > > The parts of this table name are: > > maprfs - the storage > > ted - the workspace (aka my home directory) > > fooble - the table (no need for quotes for some kinds of names ... commonly > necessary, however) > > You have to make sure that your workspace allows writes. > -- luv all
