The complex query i have takes 15 minutes to run. So, with sqoop running two queries (one to figure out the schema and one to get the data), the whole operation takes 30 minutes. Can anyone point me to the location in code where i can make a change to add support for specifying a custom schema so that sqoop does not have to figure it out?
Thanks, Pratik On Tue, Sep 9, 2014 at 10:41 AM, pratik khadloya <[email protected]> wrote: > I am trying to import data from a complex query which has 3 subqueries > with UNION ALL. > I see that in the logs, sqoop is trying to figure out the schema on that > query by adding a predicate of 1 == 0. But since on mysql we do not have > materialized views, this is taking a long time as the query itself takes > long time. > > Is there a way i can provide the schema to sqoop separately so that it > does not have the figure it out by itself? > > > Thanks, > Pratik >
