sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarek Jarcec Cecho <jar...@apache.org>
Subject Re: Unable to merge 3 tables in hive
Date Wed, 01 Aug 2012 14:58:24 GMT
Hi sir,
could you provide more details of your use case? 

I would be interested to see table structures of all 3 tables on MySQL side, the merged variant
in Hive and also it would be helpful to know precise Sqoop commands you're currently using
to populate data.

Jarcec

On Wed, Aug 01, 2012 at 12:28:05PM +0530, iwannaplay games wrote:
> Hi all,
> 
> I have 3 tables in Mysql and i want to club the data of 3 tables in 1
> table of hive.(create a data warehouse).I created table with all the
> columns of 3 tables but i am unable to push data in table of
> hive.After running an import statement of sqoop i pulled all the
> records in hdfs but At a time only one mysql table's data becomes
> visible in hive table
> 
> I want to view the full table in hive.can anybody help?

Mime
View raw message