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?
|