Re: Table value functions in Drill

[Aman Sinha]

Tushar,
Drill does not currently support the table functions as described (it looks
like your example is close to MS SQL Server syntax).
Drill has support for VALUES list in the FROM clause and a table with
options (see [1]) to interpret text data but neither of these match your
requirement.

[1]
https://drill.apache.org/docs/plugin-configuration-basics/#using-the-formats-attributes-as-table-function-parameters

On Thu, Jul 28, 2016 at 2:44 AM, Tushar Pathare  wrote:

> Hello Team,
> Any update from the developers or users or comments on this.
>
> Tushar B Pathare
> High Performance Computing (HPC) Administrator
> General Parallel File System
> Scientific Computing
> Bioinformatics Division
> Research
>
> Sidra Medical and Research Centre
> Sidra OPC Building
> PO Box 26999  |  Doha, Qatar
> Near QNCC,5th Floor
> Office 4003  ext 37443 | M +974 74793547
> tpath...@sidra.org | www.sidra.org<
> http://www.sidra.org/>
>
>
>
> From: Tushar Pathare >
> Date: Monday, July 25, 2016 at 2:01 PM
> To: "user@drill.apache.org" <
> user@drill.apache.org>
> Subject: Table value functions in Drill
>
> Like suppose I need to get the following sql function in drill
>
> create function abc ()
> returns @xyz table (id int,name varchar(100))
> as
> begin
> insert into @xyz
> select 1 id,'aaa' name
> union
> select 2 id,'bbb' name
> return
> end
>
> Tushar B Pathare
> High Performance Computing (HPC) Administrator
> General Parallel File System
> Scientific Computing
> Bioinformatics Division
> Research
>
> Sidra Medical and Research Centre
> Sidra OPC Building
> PO Box 26999  |  Doha, Qatar
> Near QNCC,5th Floor
> Office 4003  ext 37443 | M +974 74793547
> tpath...@sidra.org | www.sidra.org<
> http://www.sidra.org/>
>
>
> Disclaimer: This email and its attachments may be confidential and are
> intended solely for the use of the individual to whom it is addressed. If
> you are not the intended recipient, any reading, printing, storage,
> disclosure, copying or any other action taken in respect of this e-mail is
> prohibited and may be unlawful. If you are not the intended recipient,
> please notify the sender immediately by using the reply function and then
> permanently delete what you have received. Any views or opinions expressed
> are solely those of the author and do not necessarily represent those of
> Sidra Medical and Research Center.
>

Re: Table value functions in Drill

[Tushar Pathare]

Hello Team,
Any update from the developers or users or comments on this.

Tushar B Pathare
High Performance Computing (HPC) Administrator
General Parallel File System
Scientific Computing
Bioinformatics Division
Research

Sidra Medical and Research Centre
Sidra OPC Building
PO Box 26999  |  Doha, Qatar
Near QNCC,5th Floor
Office 4003  ext 37443 | M +974 74793547
tpath...@sidra.org | 
www.sidra.org



From: Tushar Pathare >
Date: Monday, July 25, 2016 at 2:01 PM
To: "user@drill.apache.org" 
>
Subject: Table value functions in Drill

Like suppose I need to get the following sql function in drill

create function abc ()
returns @xyz table (id int,name varchar(100))
as
begin
insert into @xyz
select 1 id,'aaa' name
union
select 2 id,'bbb' name
return
end

Tushar B Pathare
High Performance Computing (HPC) Administrator
General Parallel File System
Scientific Computing
Bioinformatics Division
Research

Sidra Medical and Research Centre
Sidra OPC Building
PO Box 26999  |  Doha, Qatar
Near QNCC,5th Floor
Office 4003  ext 37443 | M +974 74793547
tpath...@sidra.org | 
www.sidra.org


Disclaimer: This email and its attachments may be confidential and are intended 
solely for the use of the individual to whom it is addressed. If you are not 
the intended recipient, any reading, printing, storage, disclosure, copying or 
any other action taken in respect of this e-mail is prohibited and may be 
unlawful. If you are not the intended recipient, please notify the sender 
immediately by using the reply function and then permanently delete what you 
have received. Any views or opinions expressed are solely those of the author 
and do not necessarily represent those of Sidra Medical and Research Center.