Table value functions in Drill

2016-07-25 Thread Tushar Pathare
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

Re: Table value functions in Drill

2016-07-28 Thread Tushar Pathare
.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&

Re: Table value functions in Drill

2016-07-28 Thread Aman Sinha
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