Whats the migration part? Hope I am not over simplifying but it appears to be a simple case of a) Select & b) Insert / update. ... View more

To add to this, as a rule of thumb, Spark is the best choice when it comes to executing iterative algorithm. It helps that there is inbuilt ML Lib. I haven't seen anyone writing MR by hand anymore (except recently met one of the customers of our competitors because they were misled into believing 'hive is slow'.). ... View more

@Neeraj Sabharwal Just wondering if you tried and found that the ODBC driver does not work with MsAccess? Usually ODBC driver that works for Excel works for Access. ... View more

Yes, it can. Source - http://hortonworks.com/wp-content/uploads/2015/10/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf Snippet - (Page 46) The Hortonworks Hive ODBC Driver with SQL Connector supports translation for INSERT, UPDATE, and DELETE syntax when connecting to a Hive Server 2 instance that is running Hive 0.14 or later. ... View more

@Jonas Straub I've run into that problem also but the issue I was referring to was the fact that Ambari was reporting incorrect status of the process. I think in situations when the PID file already exists the error message is very direct and indicates exactly what the problem is (which is good) ... View more

+1. I miss the 'run selected' option in free version. Still a great tool though and also works with kerberos environment or when Knox is being used. ... View more

Sounds like this could be a bug.. ... View more

@Ravi This value will only impact the processes started with this specific option and the processes that are started after these values are set. So for e.g. - If the namenode is already running, it is probably using the existing value and that wont change for the running process. ... View more

Thanks @Sourygna Luangsay . Will let you know if I find something. I am thinking of starting a simple project for this (after failing to find a good solution) with the following components - - For analytical side, implement rules using a generic rules UDF that will read the rule conditions and outcome operations from a database and use UDF Distributed Cache to store them. - Possibly use an Ambari Views to set rules - The goal will be to make the design extensible to be able to add more rule operators easily. This is very high level but expect to start something soon. ... View more