@Mourad Chahri The version of Python required by the ambari-server can not be changed because of certain requirements in the code. For example, on RHEL/CentOS 6, the ambari-server requires Python 2.6. If you try to use Python 2.7, the server may not start nor be able to execute certain scripts to start/stop services due to library dependencies. ... View more

The ExecuteSQL processor says that it's for SELECT only because the intended purpose of that processor is to extract data from an RDBMS. It's not really intended to do a lot of database processing. One thing you could do is to create a stored procedure on your database that does the DDL you're describing and use the ExecuteSQL processor to issue a SELECT statement that will invoke the stored procedure. In Oracle, for example, you could create a procedure called MyProc() that would drop, create, copy, and insert and then run a query like: sql> select MyProc() from dual; You could then use the return code from MyProc() as the output from the ExecuteSQL processor to make decisions about whether the execution was successful. ... View more

@Sushant Bharti You'll want to start by looking at the oozie server logs to see what errors are there that are causing the oozie server to fail startup. These logs are in /var/log/oozie on the node where the oozie server runs. ... View more

@Kaliyug Antagonist The sqoop create table options do not provide for specifying the location to store the files. You can pre-create the tables in Hive specifying the "LOCATION" parameter to specify the HDFS directory in which to store the files (e.g. LOCATION '/org/company/datalake/incoming/System_1'). Precreating the table provides a couple of benefits over putting the text files into HDFS then creating an external table on top of it: You can use ORCFile format to store the rows which will optimize access to the tables. You can still use sqoop to import the data into the Hive tables making the transfer of data easier to manage. ... View more

@Klaus Lucas You can remove a component using the Ambari REST API. You will first need to determine the service name. You can do this via REST API with something similar to: http://<ambarihost>:8080/api/v1/clusters/<clustername>/services You can search through the services to find the Vora service. You will then want to find the components that Vora provides with: http://<ambarihost>:8080/api/v1/clusters/<ClusterName>/services/<VoraService>/ When you have found the components, you may need to find the host_compnents and remove them: http://<ambarihost>:8080/api/v1/clusters/<ClusterName>/services/<VoraService>/components/ Look for the "host_components" section. For each host_component, execute a call similar to: curl -u admin:admin -H ‘X-Requested-By: Ambari’ -X PUT -d ‘{“RequestInfo”:{“context”:”Remove Vora clients”},”Body”:{“HostRoles”:{“state”:”INIT”}}}’ http://<ambarihost>:8080/api/v1/clusters/<ClusterName>/hosts/<VoraClientHost>/host_components/<VoraClientComponent>; This will remove the client from any hosts that Ambari thinks it is installed on. Then, you can remove the Vora service from the host completely: curl -u admin:admin -H ‘X-Requested-By: Ambari’ -X PUT -d ‘{“RequestInfo”:{“context”:”Remove Vora service”},”Body”:{“HostRoles”:{“state”:”INIT”}}}’ http://<ambarihost>:8080/api/v1/clusters/<ClusterName>/components/<VoraClientComponent>; Alternatively, you could just tell Ambari to install the Vora client on a node with something like: curl -u admin:admin -H ‘X-Requested-By: Ambari’ -X PUT -d ‘{“RequestInfo”:{“context”:”Install Vora client”},”Body”:{“HostRoles”:{“state”:”INSTALLED”}}}’ http://<ambarihost>:8080/api/v1/clusters/<ClusterName>/hosts/<VoraClientHost>/host_components/<VoraClientComponent>; ... View more

@khaja pasha shake The truststore needs to exist on the node where you are running the Falcon commands (e.g. the Falcon server node). You can create the keystore with the keytool command and import the certificate into that node's keystone. Then specify the location on the Falcon server node for the keystore . ... View more

@khaja pasha shake In the configuration for the Hive view, you can add the SSL parameters to the authorization section. Here is a screenshot that should help: ... View more

@khaja pasha shake To use SSL for Hiveserver2, you will need to first enable SSL for Hiveserver2. Assuming you've already done that, your JDBC connection string will need to look something like: jdbc:hive2//server.name:10000/mydb;ssl=true;sslTrustStore=/path/to/truststore.jks;trustStorePassword=MyBadPass1 ... View more

@na dev The first thing I see is that in the XML for your raw-input-feed, you have the ACL owner as "ambari-aq" instead of "ambari-qa". This could be causing the problem with not being able to read the job definition. Correct that and see if it fixes the problem. ... View more

You will need to put the sudo rules in place if you are changing the ambari-agent run_as_user. The ambari-agent process does all of the starting and stopping of services, installation of packages, etc., and requires sudo access to run commands as the service accounts as well as a couple of root level commands. ... View more

@sankar rao It looks like quadprog needs the gfortran command. Can you verify that it's installed on the system? ... View more