hive0.4.1 do not support union,only support union all
在 2011-2-18 下午3:12，"sangeetha s" <sangee....@gmail.com>写道：
>
> Hi,
>
> I am trying to perform union of two tables which are having identical
> schemas and distinct data.There are two tables 'oldtable' and 'newtable'.
> The old table contains the information of old users and the new table will
> conatin the information of new user. I am trying to update the new entry
in
> the old table using the following query.
>
> INSERT OVERWRITE TABLE oldtable SELECT * FROM (SELECT * FROM oldtable
UNION
> select * from newtable);
>
> executing the above query results,
> FAILED:Parse Error:line 1.68 mismatched input 'select' expecting ALL in
> query operator.
>
> I am currently using Hadoop verso 0.20.2 and Hive 0.4.1 from apache
> disctribution. Will Hive 0.4.1 support UNION and UNION ALL queries? Is the
> above problem is dueto the Hive version or due to a wrong query? Also I am
> not using any partitions in these tables and the table format is TextFile.
>
> Any pointers in this regard would be highly helpful.
>
> --
>
>
>
> Regards,
> Sangita
>
>
> --
>
