Re: Drill with Parquet

[Khurram Faraaz]

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 Singh 
wrote:

> 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 
> wrote:
>
> > On Sun, Dec 25, 2016 at 9:56 PM, Manjeet Singh <
> manjeet.chand...@gmail.com
> > >
> > wrote:
> >
> > > CREATE TABLE 't'(
> > > "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
>

Re: Drill with Parquet

[Manjeet Singh]

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  wrote:

> On Sun, Dec 25, 2016 at 9:56 PM, Manjeet Singh  >
> wrote:
>
> > CREATE TABLE 't'(
> > "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