Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Simple hive select insert very slow launched from oozie but fast on command line

Highlighted

Simple hive select insert very slow launched from oozie but fast on command line

New Contributor

I am running a simple select insert sql with hive that selects from a csv table to insert in another parquet partitioned one. The task is ten times faster when run from command line using hive -f than sent from oozie using a hive action. And when run from oozie I see yarn memory at 100% but not from command line.

Can someone tell me where do I have to look for the problem?

Thanks

2 REPLIES 2

Re: Simple hive select insert very slow launched from oozie but fast on command line

New Contributor

Yarn memory is at 100% using command line too, but the task is faster.

Re: Simple hive select insert very slow launched from oozie but fast on command line

New Contributor

@Roberto Ayuso

Here you can find some important properties to improve the performance of oozie. Maybe that will help you.

Regards,

Michael