About subhash_parise3

ilyushin · ‎04-07-2021

Huge thanks. It works for me.

VidyaSargur · ‎02-17-2021

Hi @Narendra_, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.

santoshh · ‎10-07-2020

Its a service that's running, not a job. So avoid killing it.

rcorfield · ‎10-01-2020

Just to clarify, we had this same issue and resolved it by recursively setting the permissions correctly on the folders below /tmp/hive in HDFS (not the filesystem of your Hive Server) and then restarting the Hive services in Ambari. Generally the folders below /tmp/hive/ required 700, apart from "_resultscache_" which needed 733.

Manoj690 · ‎05-14-2020

Did you resolve the issue. what are the steps you follow. Help me with the steps

subhash_parise3 · ‎12-05-2019

Dear community members, we have enabled ssl for nifi in single node and accordingly configured keystore & trustore details in nifi.properties file. services are coming up fine and no errors observed in the nifi server logs. we imported the root certificate in remote windows server and google chrome browser as well but still when we are trying to access nifi UI from remote server browser it's throwing " The client and server don't support a common SSL protocol version or cipher suite " in chrome browser? Any help much appreciated ?

PhuNHB · ‎10-11-2019

On Spark 2 and HDP 3.x . Edit file "/usr/hdp/3.1.4.0-315/spark2/conf/hive-site.xml" . Remove property below: "<property> <name>metastore.catalog.default</name> <value>spark</value> </property>" After i show all databases: scala> val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc); warning: there was one deprecation warning; re-run with -deprecation for details sqlContext: org.apache.spark.sql.hive.HiveContext = org.apache.spark.sql.hive.HiveContext@4e6881e scala> sqlContext.sql("show databases").show(); Hive Session ID = edac02b0-c2f7-4cd9-919d-97bff977be3b +------------------+ | databaseName| +------------------+ | default| |information_schema| | sys| | toy_store| | website| +------------------+

subhash_parise3 · ‎10-09-2019

PFA the below error logs : 19/10/09 16:09:32 DEBUG ServletHandler: chain=org.apache.hadoop.security.authentication.server.AuthenticationFilter-418c020b->org.apache.spark.ui.JettyUtils$$anon$3-75e710b@986efce7==org.apache.spark.ui.JettyUtils$$anon$3,jsp=null,order=-1,inst=true 19/10/09 16:09:32 DEBUG ServletHandler: call filter org.apache.hadoop.security.authentication.server.AuthenticationFilter-418c020b 19/10/09 16:09:32 DEBUG AuthenticationFilter: Got token null from httpRequest http://ip-10-0-10.184. ************:18081/ 19/10/09 16:09:32 DEBUG AuthenticationFilter: Request [http://ip-10-0-10-184.*****:18081/] triggering authentication. handler: class org.apache.hadoop.security.authentication.server.KerberosAuthenticationHandler 19/10/09 16:09:32 DEBUG AuthenticationFilter: Authentication exception: java.lang.IllegalArgumentException org.apache.hadoop.security.authentication.client.AuthenticationException: java.lang.IllegalArgumentException at org.apache.hadoop.security.authentication.server.KerberosAuthenticationHandler.authenticate(KerberosAuthenticationHandler.java:306) at org.apache.hadoop.security.authentication.server.AuthenticationFilter.doFilter(AuthenticationFilter.java:536) at org.spark_project.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759) at org.spark_project.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:582) at org.spark_project.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180) at org.spark_project.jetty.servlet.ServletHandler.doScope(ServletHandler.java:512) at org.spark_project.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112) at org.spark_project.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.spark_project.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:493) at org.spark_project.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213) at org.spark_project.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) at org.spark_project.jetty.server.Server.handle(Server.java:539) at org.spark_project.jetty.server.HttpChannel.handle(HttpChannel.java:333) at org.spark_project.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) at org.spark_project.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283) at org.spark_project.jetty.io.FillInterest.fillable(FillInterest.java:108) at org.spark_project.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) at org.spark_project.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303) at org.spark_project.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148) at org.spark_project.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136) at org.spark_project.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671) at org.spark_project.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.IllegalArgumentException at java.nio.Buffer.limit(Buffer.java:275) at org.apache.hadoop.security.authentication.util.KerberosUtil$DER.<init>(KerberosUtil.java:365) at org.apache.hadoop.security.authentication.util.KerberosUtil$DER.<init>(KerberosUtil.java:358) at org.apache.hadoop.security.authentication.util.KerberosUtil.getTokenServerName(KerberosUtil.java:291) at org.apache.hadoop.security.authentication.server.KerberosAuthenticationHandler.authenticate(KerberosAuthenticationHandler.java:285) ... 22 more 19/10/09 16:09:32 DEBUG GzipHttpOutputInterceptor: org.spark_project.jetty.server.handler.gzip.GzipHttpOutputInterceptor@17d4d832 exclude by status 403 19/10/09 16:09:32 DEBUG HttpChannel: sendResponse info=null content=HeapByteBuffer@26ea8849[p=0,l=365,c=32768,r=365]={<<<<html>\n<head>\n<me.../body>\n</html>\n>>>\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00...\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00} complete=true committing=true callback=Blocker@137652aa{null} 19/10/09 16:09:32 DEBUG HttpChannel: COMMIT for / on HttpChannelOverHttp@4d71d816{r=2,c=true,a=DISPATCHED,uri=//ip-10-0-10-184.******:18081/} 403 java.lang.IllegalArgumentException HTTP/1.1 Date: Wed, 09 Oct 2019 16:09:32 GMT Set-Cookie: hadoop.auth=; HttpOnly Cache-Control: must-revalidate,no-cache,no-store Content-Type: text/html;charset=iso-8859-1

subhash_parise3 · ‎07-12-2019

We have a kerberized 4 node cluster. We are not able to call Livy Api from a remote windows machine. Command to make the API call curl --negotiate -u : -X GET -H "Content-Type: application/json" "http://******:8999/sessions?from=1&size=1" Response <html> <head> <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/> <title>Error 403 </title> </head> <body> <h2>HTTP ERROR: 403</h2> <p>Problem accessing /sessions. Reason: <pre> java.lang.IllegalArgumentException</pre></p> <hr /><i><small>Powered by Jetty://</small></i> </body> </html> -Same curl command works successfully from any of the cluster machines after getting a kerberos ticket. -Windows machine is not part of the realm. -I am using the same keytab file to get the kerberso ticket on windows machine which I use on cluster machine. -I suspect that the curl command is not sending the correct user to authenticate. Please let us know if why more information is needed. Appreciate any help.

jsensharma · ‎06-19-2019

@subhash parise Here is the reason why you needed to add that "sslfactory=org.postgresql.ssl.NonValidatingFactory" property: Using SSL without Certificate Validation ==================================== In some situations it may not be possible to configure your Java environment to make the server certificate available, for example in an applet. For a large scale deployment it would be best to get a certificate signed by recognized certificate authority, but that is not always an option. The JDBC driver provides an option to establish a SSL connection without doing any validation, but please understand the risk involved before enabling this option. A non-validating connection is established via a custom SSLSocketFactory class that is provided with the driver. Setting the connection URL parameter sslfactory=org.postgresql.ssl.NonValidatingFactory will turn off all SSL validation. If you do not want to use that option "sslfactory=org.postgresql.ssl.NonValidatingFactory" to turn off all SSL validation. Then you might have to do the following: 1. Create a Truststore in Ambari 2. Import your Postgres Certificate inside the Ambari truststore.

subhash_parise3 · ‎05-23-2019

Team, i want to setup HDP 3.1.0 cluster in Azure. Does HDP support azure postgres-sql database for ambari,hivemetastore,ranger service bakends ?

subhash_parise3 · ‎05-27-2019

Hi @Predrag Minovic, Thank you for the sharing your input. No issues with the zookeeper name space, have double checked i,e jdbc:hive2://hadoop-zknode01:2181,hadoop-zknode02:2181,hadoop-zknode03:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

ask_bill_brooks · ‎05-20-2019

The above was originally posted in the Community Help Track. On Mon May 20 16:29 UTC 2019, a member of the HCC moderation staff moved it to the Data Processing track. The Community Help Track is intended for questions about using the HCC site itself.

subhash_parise3 · ‎04-08-2019

LOAD DATA LOCAL INPATH '/tmp/sample.txt' OVERWRITE INTO TABLE employee; Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: Principal [name=hive, type=USER] does not have following privileges for operation LOAD [ADMIN] (state=42000,code=40000) 0: jdbc:hive2://starbucks-spark-job-test:2181> dfs -ls /user/hive; Error: Error while processing statement: Permission denied: Principal [name=hive, type=USER] does not have following privileges for operation DFS [ADMIN] (state=,code=1) 0: jdbc:hive2://starbucks-spark-job-test:2181> dfs -ls /tmp; Error: Error while processing statement: Permission denied: Principal [name=hive, type=USER] does not have following privileges for operation DFS [ADMIN] (state=,code=1) 0: jdbc:hive2://starbucks-spark-job-test:2181> In hive config i have found below property in Advanced HiveServer2-site hive.conf.restricted.list = hive.security.authenticator.manager,hive.security.authorization.manager,hive.security.metastore.authorization.manager,hive.security.metastore.authenticator.manager,hive.users.in.admin.role,hive.server2.xsrf.filter.enabled,hive.security.authorization.enabled do something we need to change above property ?? Please Advice ?

subhash_parise3 · ‎03-14-2019

Dear members, i am connecting Hive by using Hive_warehouse_connector from spark-shell with spark user. getting below error while creating the database java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=anonymous, access=EXECUTE, inode="/warehouse/tablespace/managed/hive/hive_test.db/":hive:hadoop:drwxdrwx--- Here my question is why spark-shell using anonymous user to contact hive database instead of spark user?

bhakti_lad831 · ‎02-14-2019

Hi Thank you for reply.I got the solution. Thanks.

subhash_parise3 · ‎01-10-2019

Hi Vikash, This https://community.hortonworks.com/questions/91265/oozie-hive-action-class-not-found-exception.html help you.

ilia987 · ‎12-27-2018

I know, i just wanted to prevent managaing multuiple configurations

Jim_B · ‎12-12-2018

You might look at the table definition (show create table x) and verify the prefix on the table location. Hive stores the whole filespec including the protocol.

subhash_parise3 · ‎11-26-2018

This problem occurs while the ticket is expired. resolved after generating the ticket by using kinit -kt user.keytab use@realm

subhash_parise3 · ‎11-20-2018

After deployed the services in HDP 3.0.1 Name node is failing to start and throwing Name node is not formatted exception. iwe had got the same issue second time. OS is rhel7 . Error Details: 2018-11-20 15:12:25,711 ERROR namenode.NameNode (NameNode.java:main(1715)) - Failed to start namenode. java.io.IOException: NameNode is not formatted. at org.apache.hadoop.hdfs.server.namenode.FSImage.recoverTransitionRead(FSImage.java:237) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.loadFSImage(FSNamesystem.java:1090) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.loadFromDisk(FSNamesystem.java:714) at org.apache.hadoop.hdfs.server.namenode.NameNode.loadNamesystem(NameNode.java:632) at org.apache.hadoop.hdfs.server.namenode.NameNode.initialize(NameNode.java:694) at org.apache.hadoop.hdfs.server.namenode.NameNode.<init>(NameNode.java:937) at org.apache.hadoop.hdfs.server.namenode.NameNode.<init>(NameNode.java:910) at org.apache.hadoop.hdfs.server.namenode.NameNode.createNameNode(NameNode.java:1643) at org.apache.hadoop.hdfs.server.namenode.NameNode.main(NameNode.java:1710) 2018-11-20 15:12:25,712 INFO timeline.HadoopTimelineMetricsSink (AbstractTimelineMetricsSink.java:getCurrentCollectorHost(291)) - No live collector to send metrics to. Metrics to be sent will be discarded. This message will be skipped for the next 20 times. 2018-11-20 15:12:25,712 INFO util.ExitUtil (ExitUtil.java:terminate(210)) - Exiting with status 1: java.io.IOException: NameNode is not formatted. 2018-11-20 15:12:25,714 INFO namenode.NameNode (LogAdapter.java:info(51)) - SHUTDOWN_MSG: After manually formatting the namenode we can able to start the namenode from ambari console. Seems this is bug in HDP 3.0.1. Same issue happened Name node HA setup in newly added namenode. Any workaround for this issue ?

subhash_parise3 · ‎11-19-2018

Hello Team, Enable Namenode HA set up went upto Namenode HA Metadata step. After ran below command in second nn2 host hdfs namenode -bootstrapStandby in nn2 we have received the below error: STARTUP_MSG: build = git@github.com:hortonworks/hadoop.git -r 2820e4d6fc7ec31ac42187083ed5933c823e9784; compiled by 'jenkins' on 2018-09-19T10:19Z STARTUP_MSG: java = 1.8.0_112 ************************************************************/ 18/11/19 12:56:51 INFO namenode.NameNode: registered UNIX signal handlers for [TERM, HUP, INT] 18/11/19 12:56:51 INFO namenode.NameNode: createNameNode [-bootstrapStandby] 18/11/19 12:56:52 ERROR namenode.NameNode: Failed to start namenode. java.io.IOException: java.lang.IllegalStateException: Could not determine own NN ID in namespace 'o9cluster'. Please ensure that this node is one of the machines listed as an NN RPC address, or configure dfs.ha.namenode.id at org.apache.hadoop.hdfs.server.namenode.ha.BootstrapStandby.run(BootstrapStandby.java:456) at org.apache.hadoop.hdfs.server.namenode.NameNode.createNameNode(NameNode.java:1615) at org.apache.hadoop.hdfs.server.namenode.NameNode.main(NameNode.java:1710) Caused by: java.lang.IllegalStateException: Could not determine own NN ID in namespace 'o9cluster'. Please ensure that this node is one of the machines listed as an NN RPC address, or configure dfs.ha.namenode.id at com.google The above error looks like wrong configuration in custom hdfs-site.xml. we really not sure why ambari made wrong host-nn2 entry in hdfs-site.xml . we revert back to the original nn2 host entry for the below properties dfs.namenode.http-address.o9cluster.nn2 dfs.namenode.https-address.o9cluster.nn2 dfs.namenode.rpc-address.o9cluster.nn2 still i am facing the same issue while running hdfs namenode -bootstrapStandby in nn2 server. how to overcome this issue and proceed to further ??

subhash_parise3 · ‎11-16-2018

seems issue with the yum.conf , after removing proxy url from yum.conf installation went fine.

subhash_parise3 · ‎10-29-2018

FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: Unable to determine if hdfs://SUBHASH/user/hive/warehouse/db.db/etl_othervendor_ids is encrypted: java.io.IOException: Failed on local exception: java.io.IOException: Couldn't setup connection for usreid@HADOOP_SUBHASH.COMPANY.COM to hostname-name/10.74.17.86:8020; Hosts: "jdfdjf2882.cloud.subhash.com":8020;

subhash_parise3 · ‎10-28-2018

2018-10-28T05:45:27,730 ERROR [org.apache.hadoop.hive.ql.txn.AcidOpenTxnsCounterService-0]: txn.AcidOpenTxnsCounterService (AcidOpenTxnsCounterService.java:run(71)) - Serious error in org.apache.hadoop.hive.ql.txn.AcidOpenTxnsCounterService-0 java.lang.NullPointerException at org.apache.hadoop.hive.metastore.txn.TxnHandler.checkRetryable(TxnHandler.java:2022) ~[hive-exec-2.1.0.2.6.2.25-1.jar:2.1.0.2.6.2.25-1] at org.apache.hadoop.hive.metastore.txn.TxnHandler.countOpenTxns(TxnHandler.java:3140) ~[hive-exec-2.1.0.2.6.2.25-1.jar:2.1.0.2.6.2.25-1] at org.apache.hadoop.hive.ql.txn.AcidOpenTxnsCounterService$OpenTxnsCounter.run(AcidOpenTxnsCounterService.java:61) [hive-exec-2.1.0.2.6.2.25-1.jar:2.1.0.2.6.2.25-1] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_171] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_171] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_171] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_171] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_171] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_171] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]

subhash_parise3 · ‎10-26-2018

After restarting the Yarn services jobs are running state. In the Node Manager logs showing error related ats-hbase [time line server] connection refused issue with region server. i have checked the port of region server is 16020. but still this services is trying to connect 17020. Logs: 2018-10-26 09:36:58,460 INFO launcher.ContainerRelaunch (ContainerRelaunch.java:call(87)) - Relaunch container with workDir = /hadoop/hadoop/yarn/local/usercache/yarn-ats/appcache/application_1538447063871_0001/container_e38_1538447063871_0001_02_000002, logDir = /hadoop/hadoop/yarn/log/application_1538447063871_0001/container_e38_1538447063871_0001_02_000002, nmPrivateContainerScriptPath = /hadoop/yarn/local/nmPrivate/application_1538447063871_0001/container_e38_1538447063871_0001_02_000002/launch_container.sh, nmPrivateTokensPath = /hadoop/hadoop/yarn/local/nmPrivate/application_1538447063871_0001/container_e38_1538447063871_0001_02_000002/container_e38_1538447063871_0001_02_000002.tokens, pidFilePath = /hadoop/hadoop/yarn/local/nmPrivate/application_1538447063871_0001/container_e38_1538447063871_0001_02_000002/container_e38_1538447063871_0001_02_000002.pid 2018-10-26 09:36:58,463 INFO container.ContainerImpl (ContainerImpl.java:handle(2093)) - Container container_e38_1538447063871_0001_02_000002 transitioned from RELAUNCHING to RUNNING 2018-10-26 09:36:58,465 INFO monitor.ContainersMonitorImpl (ContainersMonitorImpl.java:onStartMonitoringContainer(941)) - Starting resource-monitoring for container_e38_1538447063871_0001_02_000002 2018-10-26 09:36:58,465 INFO nodemanager.DefaultContainerExecutor (DefaultContainerExecutor.java:buildCommandExecutor(370)) - launchContainer: [bash, /hadoop/hadoop/yarn/local/usercache/yarn-ats/appcache/application_1538447063871_0001/container_e38_1538447063871_0001_02_000002/default_container_executor.sh] 2018-10-26 09:36:58,518 WARN nodemanager.DefaultContainerExecutor utor.java:logOutput(541)) - Container id: container_e38_1538447063871_0001_02_000002 2018-10-26 09:36:58,518 INFO 018-10-26 09:36:59,657 WARN nodemanager.DefaultContainerExecutor (DefaultContainerExecutor.java:launchContainer(311)) - Exception from container-launch with container ID: container_e38_1538447063871_0001_02_000001 and exit code: 1 ExitCodeException exitCode=1: at org.apache.hadoop.util.Shell.runCommand(Shell.java:1009) at org.apache.hadoop.util.Shell.run(Shell.java:902) at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:1227) at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:294) at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.relaunchContainer(DefaultContainerExecutor.java:345) at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.relaunchContainer(ContainerLaunch.java:504) at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerRelaunch.call(ContainerRelaunch.java:111) at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerRelaunch.call(ContainerRelaunch.java:47) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) 2018-10-26 09:36:59,657 INFO nodemanager.ContainerExecutor (ContainerExecutor.java:logOutput(541)) - Exception from container-launch. 2018-10-26 09:36:59,657 INFO nodemanager.ContainerExecutor (ContainerExecutor.java:logOutput(541)) - Container id: container_e38_1538447063871_0001_02_000001 2018-10-26 09:36:59,657 INFO nodemanager.ContainerExecutor (ContainerExecutor.java:logOutput(541)) - Exit code: 1 2018-10-26 09:36:59,657 WARN launcher.ContainerLaunch (ContainerLaunch.java:handleContainerExitWithFailure(598)) - Container launch failed : Container exited with a non-zero exit code 1. 2018-10-26 09:36:59,660 INFO container.ContainerImpl (ContainerImpl.java:doRelaunch(1638)) - Relaunching Container container_e38_1538447063871_0001_02_000001. Remaining retry attempts(after relaunch) : -457. Interval between retries is 30000ms 2018-10-26 09:36:59,660 INFO container.ContainerImpl (ContainerImpl.java:handle(2093)) - Container container_e38_1538447063871_0001_02_000001 transitioned from RUNNING to RELAUNCHING 2018-10-26 09:37:00,389 INFO client.RpcRetryingCallerImpl (RpcRetryingCallerImpl.java:callWithRetries(134)) - Call exception, tries=6, retries=6, started=4192 ms ago, cancelled=false, msg=Call to ip-10-0-10-76.amer.o9solutions.local/10.0.10.76:17020 failed on connection exception: org.apache.hbase.thirdparty.io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: ip-10-0-10-76.amer.o9solutions.local/10.0.10.76:17020, details=row 'prod.timelineservice.entity,yarn-ats!yarn_cluster!ats-hbase��h�<��h��!COMPONENT!!regionserver,99999999999999' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=ip-10-0-10-76.amer.o9solutions.local,17020,1538447132436, seqNum=-1

mohamed_achelif · ‎02-13-2019

capture-decran-2019-02-12-a-185811.pngHi, Could you explain further please? I have the same problem. When I restart HiveServer2 Interactive via Ambari, the later starts a yarn application named llap0 and still running a moment before it fails. When I check via CLI : hive --service llapstatus --name llap0 I get : SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/3.0.1.0-187/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/3.0.1.0-187/hadoop/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] WARN conf.HiveConf: HiveConf of name hive.stats.fetch.partition.stats does not exist WARN conf.HiveConf: HiveConf of name hive.heapsize does not exist LLAPSTATUS -------------------------------------------------------------------------------- LLAP status unknown. Awaiting app launch -------------------------------------------------------------------------------- LLAP status unknown. Awaiting app launch -------------------------------------------------------------------------------- { "state" : "APP_NOT_FOUND", "runningThresholdAchieved" : false } But on the Yarn Applications dashboard, the llap0 is in Running state (see attached picture). Thanks.

tarekabouzeid91 · ‎05-11-2019

hi @Rajesh Sampath @subhash parise, i am also having same error, i am trying to read hive external table, can you please tell me how you fixed it ?

ivonnycapilitan · ‎10-09-2018

Hi @subhash parise, Thank you! No alerts were observed after the maintenance mode was enabled.

subhash_parise3 · ‎09-27-2018

Hi @Thuy Le , you may need to change java heap size perameters in bootstrap.conf file. Please refer the below document. https://community.hortonworks.com/articles/7882/hdfnifi-best-practices-for-setting-up-a-high-perfo.html

Online	Offline
Last Visited	‎12-06-2019 02:44 AM

Date Registered	‎12-30-2015 09:04 AM
Last Visited	‎12-06-2019 02:44 AM
Total Messages Posted	164
Total Kudos Received	29

Re: Spark unable to connect Hive database in HDP 3...

Re: ambari cluster + zookeeper snapshot

Re: hdfs dfs -ls command failing with below error ...

Re: install hadoop services are failing due to loc...

Re: LLAP - Status Unknown ( HiveInteractive server...

Re: Spark unable to connect Hive database in HDP 3...

Re: One of hbase region server is stopping with be...

Re: why yarn service is launching ats-hbase app i...

Re: hive interactive server (HSI) queries are fail...

Re: Region server installation Failed in HDP 2.6

Getting ERR_SSL_VERSION_OR_CIPHER_MISMATCH Error i...

Re: Spark2 shell is not displaying all Hive databa...

Re: unable to connect spark history server ui afte...

Issue in making Livy REST Api call in a kerberized...

Re: ambari is unable to make the connection extern...

does HDP3.1.0 supports Azure postgres-sql database...

Re: unable to login hive by using beeline with zoo...

Re: Hive table showing the count and not displayin...

HIve load data local inpath query failing with the...

Creating table by using spark-shell failing from ...

Re: Hive connection with ODBC Driver

Re: Oozie hive action error - hiveComatibilityMain...

Re: yarn configure to use all ram

Re: Hive queries are failing in Ineractive quey HD...

Re: hdfs dfs -ls command failing with below error ...

Namenode start failed after installation completes...

Enable Namenode Ha Fails in Inetialize Namenode H...

Re: install hadoop services are failing due to loc...

Hive Query Failing with Kerberos Error

Hive queries are failing with java null pointer ex...

Resource manager not allocating the resources even...

Re: LLAP - Status Unknown ( HiveInteractive server...

Re: hive.executeQuery("select * from rh_demand_pla...

Re: Will I be getting an error if I shutdown all s...

Re: Nifi: error (Java Heap space) when load data ...