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 Para
.apache.org<mailto:user@drill.apache.org>"
mailto: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&
ll.apache.org>" <
> user@drill.apache.org<mailto: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(10