drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: Drill with Parquet
Date Mon, 26 Dec 2016 21:22:48 GMT
On Sun, Dec 25, 2016 at 9:56 PM, Manjeet Singh <manjeet.chandhok@gmail.com>
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message