Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> data transfer from rdbms to hive

Copy link to this message
Re: data transfer from rdbms to hive
It sounds like you might need to export. Via sqoop using a query or view,
as the date granularity in your MySQL table is different from the desired
Hive table. The overall performance may be lower as MySQL must do more than
just read rows from disk, but you may still find ways to get the data in
parallel through Sqoop.

On May 2, 2014 3:34 AM, "Hamza Asad" <[EMAIL PROTECTED]> wrote:
have to enable dynamic partition i.e dynamic partition = true, in hive.
import data from relational DB is SQOOP.