@Rahul Buragohain Based on the Ranger documentation you should be able to achieve this by adding additional property: xasecure.audit.destination.hdfs.batch.filespool.archive.dir pointing to the folder you want. Here is the URL I am referring to: https://cwiki.apache.org/confluence/display/RANGER/Ranger+0.5+Audit+Configuration#Ranger0.5AuditConfiguration-ConfigurationrelatedtoFilespooling ... View more

@Nic Hopper If you have Kerberos enabled you need to connect as: !connect jdbc:hive2://<hiveserver2_hostname>:10001/<database_name>;transportMode=http;httpPath=cliservice;principal=<hive_principal> ... View more

@Fernando Lopez Bello To push the graph for the customer you can do this: - in zeppelin UI where you have the graph generated - at the top-right corner, change Default to Report - now get the URL and send to the customer In my test it looks like ... View more

@yjiang To answer your question - --------------- When you use a script, command, or API to create a topic, an entry is created under ZooKeeper. The only user with access to ZooKeeper is the service account running Kafka (by default, kafka ). Therefore, the first step toward creating a Kafka topic on a secure cluster is to run kinit , specifying the Kafka service keytab. The second step is to create the topic. ---------------- See more in here: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.3/bk_secure-kafka-ambari/content/ch_secure-kafka-create-topics.html I hope this helps. ... View more

@Karan Alang Ensure you have: hive.server2.enable.doAs=true Also set the following properties to * hadoop.proxyuser.hive.hosts=* hadoop.proxyuser.hive.groups=* NOTE: I appreciate if you vote for all the answers that helped you fixing the problem. ... View more

@Karan Alang As previously mentioned: > hive.server2.enable.doAs - Setting this property to true will have HiveServer2 execute Hive operations as the user making the calls to it - so set this property to TRUE > review your hive view settings (see all 3 URLs I already posted) - based on what I can see, at least, Hive Authentication is incorrect. This is to be: auth=KERBEROS;principal=hive/_HOST@EXAMPLE.COM;hive.server2.proxy.user=${username} - where EXAMPLE.COM is your REALM ... View more

@sanjeevan mahajan I have made quite few attempts - the ones that actually should work. Similar to SELECT j.* FROM new2_salaries j WHERE j.from_date = (SELECT MIN(j2.from_date) FROM new2_salaries j2 WHERE j.empl_no = j2.empl_no); Unfortunately, this is not working due to an existing bug: https://issues.apache.org/jira/browse/HIVE-8960 ... View more

@sanjeevan mahajan How about this: create table employees2_final stored as ORC tblproperties (‘orc.compress’=‘SNAPPY’) AS SELECT e.emp_no, e.birth_date,e.first_name, e.last_name, e.gender, min(s.from_date) from new2_salaries s, employees e WHERE s.emp_no = e.emp_nosel GROUP BY s.emp_no, s.from_date ... View more

@sanjeevan mahajan Can you try this out: create table employees2_final stored as ORC tblproperties (‘orc.compress’=‘SNAPPY’) AS SELECT e.emp_no, e.birth_date,e.first_name, e.last_name, e.gender, min(s.from_date) from new2_salaries s, employees e WHERE s.emp_no = e.emp_nosel GROUP BY s.emp_no ... View more