You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Tushar Pathare <tp...@sidra.org> on 2016/07/25 11:01:10 UTC
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 3333 ext 37443 | M +974 74793547
tpathare@sidra.org<ma...@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
Posted by Aman Sinha <am...@apache.org>.
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 <tp...@sidra.org> 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 3333 ext 37443 | M +974 74793547
> tpathare@sidra.org<ma...@sidra.org> | www.sidra.org<
> http://www.sidra.org/>
>
>
>
> From: Tushar Pathare <tp...@sidra.org>>
> Date: Monday, July 25, 2016 at 2:01 PM
> To: "user@drill.apache.org<ma...@drill.apache.org>" <
> user@drill.apache.org<ma...@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 3333 ext 37443 | M +974 74793547
> tpathare@sidra.org<ma...@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
Posted by Tushar Pathare <tp...@sidra.org>.
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 3333 ext 37443 | M +974 74793547
tpathare@sidra.org<ma...@sidra.org> | www.sidra.org<http://www.sidra.org/>
From: Tushar Pathare <tp...@sidra.org>>
Date: Monday, July 25, 2016 at 2:01 PM
To: "user@drill.apache.org<ma...@drill.apache.org>" <us...@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 3333 ext 37443 | M +974 74793547
tpathare@sidra.org<ma...@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.