Member since
10-28-2016
392
Posts
7
Kudos Received
20
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2833 | 03-12-2018 02:28 AM | |
4380 | 12-18-2017 11:41 PM | |
3142 | 07-17-2017 07:01 PM | |
2175 | 07-13-2017 07:20 PM | |
6606 | 07-12-2017 08:31 PM |
12-07-2016
07:04 AM
@Karthik Narayanan, - yes, the principal is correct for user - hive & I was able to use this command to connect to hive using beeline using the command you provided.. thanks for that. command -> !connect jdbc:hive2://sandbox.hortonworks.com:10000/default;principal=hive/sandbox.hortonworks.com@EXAMPLE.COM
... View more
12-07-2016
01:58 AM
Hi - i've a kerberized HDP 2.4 cluster, and i'm trying to access Hive using Beeline. Command used -> !connect jdbc:hive2://sandbox.hortonworks.com:10001/default;principal=hive/sandbox.hortonworks.com@EXAMPLE.COM;hive.server2.transport.mode=binary;hive.server2.thrift.http.path=cliservice;auth=kerberos;hive.server2.thrift.sasl.qop=auth-int Error : Error: Could not open client transport with JDBC Uri: jdbc:hive2://sandbox.hortonworks.com:10001/default;principal=hive/sandbox.hortonworks.com@EXAMPLE.COM;hive.server2.transport.mode=binary;hive.server2.thrift.http.path=cliservice: java.net.ConnectException: Connection refused (state=08S01,code=0) reference -> https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_dataintegration/content/beeline-vs-hive-cli.html Pls let me know what needs to be done ? Also, what is the username/password to be put in, on firing the command above ? I tried leaving it blank, and also the Unix hive username/passwd, but the error is the same.
... View more
Labels:
12-05-2016
11:55 PM
@Daniel Kozlowski - thanks for your input on this, i was able to make this work ! The missing entry (as you mentioned) was -> hive.server2.proxy.user=${username} in Hive Authorization After adding this, i'm able to control access to Hive tables using Ranger .
However, there is still one issue which needs clarification .. the value of constant -> hive.server2.enable.doAs does not seem to be affecting behavior. Even when it is set to false (or true), the above behavior is seen. Any ideas/comments on this ?
... View more
12-05-2016
04:28 AM
@jss - here is the output of the command [root@sandbox ambari-server]# rpm -qa | grep ambari-metrics
ambari-metrics-hadoop-sink-2.2.1.0-161.x86_64
ambari-metrics-collector-2.2.1.0-161.x86_64
ambari-metrics-monitor-2.2.1.0-161.x86_64 yes, url - http://127.0.0.1:8080/api/v1/clusters/Sandbox/services shows the services including AMBARI_METRICS
... View more
12-05-2016
04:11 AM
@Sunile Manjee, @prao - pls. let me know if you have any inputs on this ? (I believe you've fixed this in HDP 2.5, per the link posted above)
... View more
12-05-2016
04:07 AM
Hi All, I'm adding Grafana to Ambari .. and getting error -> Reference link -> https://community.hortonworks.com/questions/43334/ambari-metrics-link-grafana-not-available-on-hdp-2.html Cmd run -> curl -u admin:4o12t0n -H "X-Requested-By:ambari" -i -X POST http://sandbox.hortonworks.com:8080/api/v1/clusters/Sandbox/services/AMBARI_METRICS/components/METRICS_GRAFANA Error (in ambari-server.log) -> -------------------------------------------------------------------------------------------------------- 05 Dec 2016 03:52:10,815 ERROR [qtp-ambari-client-745] BaseManagementHandler:66 - Caught a runtime exception while attempting to create a resource: Trying to create a ServiceComponent not recognized in stack info, clusterName=Sandbox, serviceName=AMBARI_METRICS, componentName=METRICS_GRAFANA, stackInfo=HDP-2.4
java.lang.RuntimeException: Trying to create a ServiceComponent not recognized in stack info, clusterName=Sandbox, serviceName=AMBARI_METRICS, componentName=METRICS_GRAFANA, stackInfo=HDP-2.4
at org.apache.ambari.server.state.ServiceComponentImpl.<init>(ServiceComponentImpl.java:111)
at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByGuice$$fb135ca4.<init>(<generated>)
at org.apache.ambari.server.state.ServiceComponentImpl$$EnhancerByGuice$$fb135ca4$$FastClassByGuice$$38a29767.newInstance(<generated>)
at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40)
at com.google.inject.internal.ProxyFactory$ProxyConstructor.newInstance(ProxyFactory.java:260)
at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)
at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
at com.google.inject.assistedinject.FactoryProvider2.invoke(FactoryProvider2.java:632)
at com.sun.proxy.$Proxy18.createNew(Unknown Source)
at org.apache.ambari.server.controller.internal.ComponentResourceProvider.createComponents(ComponentResourceProvider.java:408)
at org.apache.ambari.server.controller.internal.ComponentResourceProvider$1.invoke(ComponentResourceProvider.java:130)
at org.apache.ambari.server.controller.internal.ComponentResourceProvider$1.invoke(ComponentResourceProvider.java:127)
at org.apache.ambari.server.controller.internal.AbstractResourceProvider.invokeWithRetry(AbstractResourceProvider.java:450)
at org.apache.ambari.server.controller.internal.AbstractResourceProvider.createResources(AbstractResourceProvider.java:273)
at org.apache.ambari.server.controller.internal.ComponentResourceProvider.createResources(ComponentResourceProvider.java:127)
at org.apache.ambari.server.controller.internal.ClusterControllerImpl.createResources(ClusterControllerImpl.java:289)
at org.apache.ambari.server.api.services.persistence.PersistenceManagerImpl.create(PersistenceManagerImpl.java:76)
at org.apache.ambari.server.api.handlers.CreateHandler.persist(CreateHandler.java:36)
at org.apache.ambari.server.api.handlers.BaseManagementHandler.handleRequest(BaseManagementHandler.java:72)
at org.apache.ambari.server.api.services.BaseRequest.process(BaseRequest.java:135)
at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:106)
at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:75)
at org.apache.ambari.server.api.services.ComponentService.createComponent(ComponentService.java:137)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
... View more
Labels:
- Labels:
-
Apache Ambari
12-05-2016
02:47 AM
@Sunile Manjee - when you say - if you have impersonation turned on (i.e. set hive.server2.enable.doAs = true), control access from both hive and hdfs - do you mean to say that i've to change the permissions in hdfs as well (i.e group) ? what if impersonation is turned off ? Pls. clarify.
... View more
12-05-2016
12:34 AM
@Kuldeep Kulkarni, @Sunile Manjee, @Daniel Kozlowski This is what i see in the logs -> 2016-12-04 23:54:35,491 INFO [HiveServer2-Handler-Pool: Thread-76]: security.SecureClientUtils (SecureClientUtils.java:getClientConnectionHandler(94)) - doAsUser: ambari-server so, seem it is trying to access the HIve instance as user - ambari-user.. how do i get it to access Hive as custom users (hive_user1 or hive_user2)
... View more
12-05-2016
12:08 AM
@Daniel Kozlowski - pls see response to your note above.
... View more
12-05-2016
12:08 AM
@Kuldeep Kulkarni - any ides on how to fix this ?
... View more