I think this was due to non runnning metstore service from hive.   You should run command "hive --service metastore & " first and then start hive console.  ... View more

@jsensharma Thank you for your answer. I am facing similar issue with Ambari 2.7.0, Mysql 5.7.29. I am unable to get into admin account even once and on click of Login it just hangs and says ' Unable to connect to Ambari Server. Confirm Ambari Server is running and you can reach Ambari Server from this machine.' after some seconds.'   I even posted details here: https://stackoverflow.com/q/60743259/7051479   Could you please help me out on this. ... View more

I will just try that ... View more

@darkz yu I don't think there is a silver bullet because you have to balance the producers, brokers, and consumers but I would think the most important are these 2 parameters below batch.size = 16384 # default size Smaller batch size will make batching less common and may reduce throughput a batch size of zero will disable batching entirely. A very large batch size may use memory a bit more wastefully as we will always allocate a buffer of the specified batch size in anticipation of additional records. linger.ms = 0 #default linger.ms=5 would have the effect of reducing the number of requests sent but would add up to 5ms of latency to records sent in the absence of a load. ... View more

@Aravindan Vijayan I just found some simple java metric on grafana,only GC TIME / GC TIME PARNEW But I want to know detail of java metrics such datanode heapsize usage,yong gc count and time which ambari metrics collected Grafana shows me "This dashboard is managed by Ambari. You may lose any changes made to this dashboard. If you want to customize, make your own copy." So I don't know how to let them show on grafana automatic ... View more

@darkz yu Yes, that sounds right. Sorry I missed the step which would have triggered the modification of the '/etc/hadoop/conf/hadoop-metrics2.properties' file. So, is your problem fixed now? ... View more

@Aditya Sirna But my openjdk version is 1.8, So I think maybe the post is too old... ... View more

@Jay Kumar SenSharma Referring to the PUT command used for triggering the alert manually, Is it possible to pass some parameters/custom information to the script which gets trigged by the alert ? If yes, is it via headers OR body of the PUT request ? Thanks. ... View more

Did you resolve the problem? I have the same. ... View more

@Jay SenSharma The url you post is how to create an alert. But I also want to how to get the flume metric easily through python. I had read the api of ambari and python-ambariclint,but few content of how to get flume metric data. ... View more

I know what you mean,but my sa only support the server with RAID5 disks, so ... ... View more

@darkz yu Have you following the steps mentioned in the following doc to properly move the AMS to a new host? https://cwiki.apache.org/confluence/display/AMBARI/Moving+Metrics+Collector+to+a+new+host Following points are important if you want to see OLD metrics data after moving the AMS to new host: If the AMS is in embedded mode, copy the AMS data from old node to new node. For embedded mode (ams-site: timeline.metrics.service.operation.mode), copy over the hbase.rootdir and tmpdir to new host from the old collector host. For distributed mode, since AMS HBase is writing to HDFS, no change will be necessary. Ensure that ams:hbase-site:hbase.rootdir and hbase.tmp.dir are pointing to the correct location in the new AMS node - The service daemons will be pointing to the old metrics collector host. Perform a rolling restart of slave components and a normal restart of Master components for them to pick up the new collector host. . ... View more

set 'hive.query.name' ... View more

@darkz yu Currently using ambari you can get two types of alerts notification "E-Mail Notification" and "SNMP Notification". Please see: http://docs.hortonworks.com/HDPDocuments/Ambari-2.4.2.0/bk_ambari-user-guide/content/configuring_notifications.html . ... View more

I had find that on host hadoop1.xxx which the hive metastore running ,exists the /tmp/hive/ and /tmp/hive/hive.log and own to hive.hadoop. So I think there may be something other couse the problem. And I run the following command using ambari user: export HIVE_CONF_DIR='/usr/hdp/current/hive-metastore/conf/conf.server' hive --hiveconf hive.metastore.uris=thrift://hadoop1.xxx:9083 --hiveconf hive.metastore.client.connect.retry.delay=1 --hiveconf hive.metastore.failure.retries=1 --hiveconf hive.metastore.connect.retries=1 --hiveconf hive.metastore.client.socket.timeout=14 --hiveconf hive.execution.engine=mr -e 'show databases;' --hiveconf hive.root.logger=DEBUG,console It shows me every think is OK... ... View more

Yes，I use http sourc，when use hdfs sink without compress code，it works fine，but when use compress，it gets the error，so I think the “.tmp” file is not complete and the hdfs could not decompress fine and the hive recognize the json format wrong ... View more

@Jay SenSharma I try it and it works fine. It should be: curl -u ${ambari_user_name}:${ambari_user_pass} -H "X-Requested-By: ambari"-d '{"RequestInfo":{"context":"Starting Flume agent","flume_handler":"agent","operation_level": {"level":"HOST_COMPONENT","cluster_name":"${CLUSTER_NAME}","service_name":"FLUME","host_name":"${hostname_of_new_flume_agent}"}},"Body":{"HostRoles":{"state":"STARTED"}}}'-X PUT "http://${AMBARI_HOST}:8080/api/v1/clusters/${CLUSTER_NAME}/hosts/${hostname_of_new_flume_agent}/host_components/FLUME_HANDLER" And now if I want do add a new agent ,I must change the configure on the ambari web ui ,then call the ambari server api above. Why not make it more easy?? ... View more

I had install new openjdk 1.8 and there is the old 1.6 version on the same version I use /usr/sbin/alternatives --config java changed the java version, and then use java -version,it shows me the openjdk version is 1.8 but I found /usr/lib/jvm/ linked to /etc/alternatives/java_sdk and still linked to /usr/lib/jvm/java-1.6.0-openjdk.x86_64 So I think nothing changed. I just set JAVA_HOME to /usr/lib/jvm/java ，and want not to change the java home path after each jdk upgrade. So I don't know why the /etc/alternatives/java_sdk link not change. ... View more

I ran into same issue but it's automatically fixed after re-starting my data node server (re-boot physical linux server). ... View more

@darkz yu - this is an Ambari takeover situation. However, there are some manual steps involved and there are some tricky situations, so we recommend a professional service engagement to help make this successful. That will include both having Ambari take over the existing cluster as well as perform the upgrade. ... View more

Please accept best answer or post your comment as answer ... View more

Go to https://support.hortonworks.com/CustomerPortalLoginPageV2?ec=302&startURL=%2Fs%2F Then Login >> Tools >> Generate Smart Sense ID There you will be able to see your Account Name and CustomerID. Now go to Ambari >> SmartSense >> Config FIll in your details and restart SmartSense Analyzer. Now you will be able to generate Bundles. ... View more

Perfect solution, it works ... View more