hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From iwannaplay games <>
Subject Re: Unable to merge 3 tables in hive
Date Wed, 01 Aug 2012 08:55:21 GMT
thanks i did it by creating 3 external tables and then using this
query to update createddate from users table for a particular userid.

insert overwrite table userinfo
select u.userid,a.createddate from users a join userinfo u on u.userid=a.userid

i can use query option also
I ll try that now :)

On 8/1/12, Bejoy KS <> wrote:
> Hi
> If you have run simple table level sqoop import the definitely all the
> tables will be imported separately to hdfs. If you need the data from 3
> tables joined together, frame a proper sql query and use this query in the
> sqoop import (sqoop import has a --query option)
> If it is like 3 tables have the same structure and you need to just club the
> data together into single table in hive.
> 1) Import data into hdfs separately for 3 tables.
> 2) Create hive table.
> 3) Use 3 load data statements without Overwrite option to load the imported
> data into same hive table.
> Regards
> Bejoy KS
> Sent from handheld, please excuse typos.
> -----Original Message-----
> From: iwannaplay games <>
> Date: Wed, 1 Aug 2012 12:28:05
> To: user<>; user<>
> Reply-To:
> Subject: Unable to merge 3 tables in hive
> 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?

View raw message