Member since
03-25-2016
142
Posts
48
Kudos Received
7
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
5748 | 06-13-2017 05:15 AM | |
1886 | 05-16-2017 05:20 AM | |
1336 | 03-06-2017 11:20 AM | |
7812 | 02-23-2017 06:59 AM | |
2214 | 02-20-2017 02:19 PM |
01-27-2017
09:47 AM
@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
01-26-2017
03:13 PM
@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
01-26-2017
12:26 PM
1 Kudo
@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
01-23-2017
08:47 AM
@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
12-06-2016
06:18 AM
@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
12-05-2016
06:57 AM
@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
12-03-2016
06:35 AM
@Karan Alang If you have Kerberized cluster - the usual things to check: > Setup HDFS Proxy User - http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.0/bk_ambari_views_guide/content/_setup_HDFS_proxy_user.html > Set Up Kerberos for Ambari Server - http://docs.hortonworks.com/HDPDocuments/Ambari-2.1.1.0/bk_Ambari_Security_Guide/content/_optional_set_up_kerberos_for_ambari_server.html#header > Kerberos Setup for Hive Views - http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.1.0/bk_ambari_views_guide/content/section_kerberos_setup_hive_view.html
... View more
09-02-2016
11:10 PM
@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
09-02-2016
09:58 PM
@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
09-02-2016
09:47 PM
@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
- « Previous
- Next »