Sqoop Action with –query fails on oozie using tag

Yesterday I have discovered an Oozie bug that it does not handle the –query parameter for sqoop action. See my example sqoop action XML below: <action name="sqoop-ed7d" cred="hive2"> <sqoop xmlns="uri:oozie:sqoop-action:0.2"> <job-tracker>${jobTracker}</job-tracker> <name-node>${nameNode}</name-node> <prepare> <delete path="${nameNode}/user/eric/sqoop-import"> </delete></prepare> <command></command>import –connect jdbc:mysql://node6.lab.cloudera.com/test –username root –password cloudera –target-dir hdfs://node5.lab.cloudera.com:8020/user/eric/sqoop-import –query "SELECT * FROM test …

Impala metadata not synced across all Impala Daemons when Load Balancer is enabled

Recently I have be dealing with quite a few customers with the same issue that Impala metadata out of sync between each Impala Daemons. And the common cause was to do with Load Balancer setup in front of Impala Daemons and the way they run impala queries. So this was …