Thanks!
On 13 February 2012 19:45, Roberto Congiu wrote:
> You can use UNION even if the tables are different:
> SELECT *
> FROM (
> select_statement
> UNION ALL
> select_statement
> ) unionResult
>
>
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Union
>
> On Mon, Feb 13,
You can use UNION even if the tables are different:
SELECT *
FROM (
select_statement
UNION ALL
select_statement
) unionResult
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Union
On Mon, Feb 13, 2012 at 7:10 PM, Sameer Agarwal
wrote:
> Hi,
>
> Is there a straightforward w
Hi,
Is there a straightforward way to execute a query on rows from multiple
tables in Hive? Specifically, let's say that we have 2 tables A and B with
exactly the same schema. Is it possible for me to execute a query on all
the rows of A and B? If not, what could be the best way to alter the
table
