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.http://my.safaribooksonline.com/book/databases/9781449364618/6dot-hadoop-ecosystem-integration/integration_hive_partition_html