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.
|