@ramarov Thank you for the suggestion! We'll keep it in mind for our future sprint updates.  ... View more

There is now a way to do this with .impalarc using the following:   [impala.query_options] REQUEST_POOL=mypoolname ... View more

Hi ,   I am also getting the same below error running Hive on Spark using IBM data stage   main_program: Fatal Error: The connector received an error from the driver. The reported error is: [SQLSTATE HY000] java.sql.SQLException: [IBM][Hive JDBC Driver][Hive]Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.spark.SparkTask.   Were you able to resolve the issue.   Thanks, Jalaj ... View more

   Kindly check log detail on Resource manager:   <clusterip>:8088    Open terminal and checl actual log problem:   yarn logs -applicationId <APP_ID>    Example: APP_ID = application_1535002188113_0001      In mine case it was showing permission issue to directory '/user/history' so i gave it   sudo -u hdfs hadoop fs -chmod 775 /user/history or sudo -u hdfs hadoop fs -chmod 777 /user/history   Then it works.   ... View more

Were you able to set custom prefix ? I want to do multiple inserts into same partition. I hope if custom prefix works, I can do multiple inserts in hive table. Any suggestions appreciated ... View more

@VuSand3259,     You can use this endpoint:   https://cloudera.github.io/cm_api/apidocs/v19/path__users_-userName-.html   using the PUT method via REST API allows you to update the user object defined here:   https://cloudera.github.io/cm_api/apidocs/v19/ns0_apiUser.html   For example, the following would make an existing user "mytestuser" a full administrator in CM 5.15 (you would need to use the api version that is right for your CM version):   curl -u cm_user:cm_pass -H "Content-Type: application/json" -X PUT -d '{"roles" : [ "ROLE_ADMIN"]}' http://cm_host:7180/api/v19/users/mytestuser ... View more

how did you stored logs in local? can you please provide me the way you did it. ... View more

The only issue I can see is the way you are writing request_pool, it should be all Caps else it will not set to the specific pool.   Kinldy use impala-shell -k -i hostname:portnum -B -q 'set REQUEST_POOL=pool_name;'   Hope this will resolve the issue.   NOTE: I am considering that the Impala Admission Control is applied and the poolname is the one that is created using Cloudera Manager.  ... View more

During install if SElinux is enabled then apparently the hadoop directories created in /var/lib like hbase, hive, impala, sqoop, zookeeper etc. seem to have all the permissions set as 000 instead of 755 and also owned by root instead of the service accounts. This causes these roles unable to startup. Ended up having to chmod 755 and chown all these 15 or so directories after which the install completed sucessfully. ... View more

Fawze You said that any role can be moved. How is that done for ones like "HDFS Balancer" or JobHistory servers? These roles can't be added/moved via CM that I can see. ... View more