ch 29, 2019 11:02 AM
To: user@hive.apache.org
Subject: Re: Creating temp tables in select statements
Thanks everyone for the reply.
We are using 2.3.2 :( but good to see this implemented in Hive. It is such a
common use case.
Edward, will you be having the UDTF source anywhere.
On a related note,
.apache.org>>
> Date: Thursday, March 28, 2019 at 4:44 AM
> To: "user@hive.apache.org <mailto:user@hive.apache.org>"
> mailto:user@hive.apache.org>>
> Subject: Re: Creating temp tables in select statements
>
>
>
> Hi Mainak,
>
>
>
March 28, 2019 at 4:44 AM
> *To: *"user@hive.apache.org"
> *Subject: *Re: Creating temp tables in select statements
>
>
>
> Hi Mainak,
>
>
>
> For select queries the only way I know of for multiple records is through
> using union:
>
>
&
To: "user@hive.apache.org"
Subject: Re: Creating temp tables in select statements
Hi Mainak,
For select queries the only way I know of for multiple records is through using
union:
0: jdbc:hive2://localhost:1> with x as (select 1 num union select 2 union
select 3) select * fro
Hi Mainak,
For select queries the only way I know of for multiple records is through
using union:
0: jdbc:hive2://localhost:1> with x as (select 1 num union select 2
union select 3) select * from x;
++
| x.num |
++
| 1 |
| 2 |
| 3 |
++
For table insert
Hello,
We want to create temp tables at a select query level. For example:
with x as (1, 2, 3) select * from x;
Or
Select * from table where id in ; Here list of integers is an
input and can change.
Currently Postgres VALUES syntax is not supported in Hive. Is there some easy
workarounds wh
