SELECT repo_version_id, version, display_name FROM repo_version repo_version_id | version | display_name -----------------+--------------+--------------- 1 | 2.3.4.7-4 | HDP-2.3.4.7-4 51 | 2.5.0.0-1245 | HDP-2.5.0.0 (2 Zeilen) SELECT version, state FROM cluster_version cv JOIN repo_version rv ON cv.repo_version_id = rv.repo_version_id ORDER BY version DESC version | state --------------+----------- 2.5.0.0-1245 | INSTALLED 2.3.4.7-4 | CURRENT (2 Zeilen) SELECT version, state, COUNT(*) FROM host_version hv JOIN repo_version rv ON hv.repo_version_id = rv.repo_version_id GROUP BY version, state ORDER BY version DESC, state version | state | count --------------+-----------+------- 2.5.0.0-1245 | INSTALLED | 2 2.3.4.7-4 | CURRENT | 2 (2 Zeilen) SELECT service_name, component_name, version, host_name FROM hostcomponentstate hcs JOIN hosts h ON hcs.host_id = h.host_id WHERE service_name Not IN ('AMBARI_METRICS', 'KERBEROS') AND component_name NOT IN ('ZKFC') ORDER BY version, service_name, component_name, host_name service_name | component_name | version | host_name --------------+------------------------+--------------+----------- HDFS | DATANODE | 2.5.0.0-1245 | hdp-master HDFS | DATANODE | 2.5.0.0-1245 | hdp-slave1 HDFS | HDFS_CLIENT | 2.5.0.0-1245 | hdp-master HDFS | HDFS_CLIENT | 2.5.0.0-1245 | hdp-slave1 HDFS | NAMENODE | 2.5.0.0-1245 | hdp-master HDFS | SECONDARY_NAMENODE | 2.5.0.0-1245 | hdp-slave1 HIVE | HCAT | 2.5.0.0-1245 | hdp-master HIVE | HCAT | 2.5.0.0-1245 | hdp-slave1 HIVE | HIVE_CLIENT | 2.5.0.0-1245 | hdp-master HIVE | HIVE_CLIENT | 2.5.0.0-1245 | hdp-slave1 HIVE | HIVE_METASTORE | 2.5.0.0-1245 | hdp-slave1 HIVE | HIVE_SERVER | 2.5.0.0-1245 | hdp-slave1 HIVE | WEBHCAT_SERVER | 2.5.0.0-1245 | hdp-slave1 KAFKA | KAFKA_BROKER | 2.5.0.0-1245 | hdp-master MAPREDUCE2 | HISTORYSERVER | 2.5.0.0-1245 | hdp-slave1 MAPREDUCE2 | MAPREDUCE2_CLIENT | 2.5.0.0-1245 | hdp-master MAPREDUCE2 | MAPREDUCE2_CLIENT | 2.5.0.0-1245 | hdp-slave1 PIG | PIG | 2.5.0.0-1245 | hdp-master PIG | PIG | 2.5.0.0-1245 | hdp-slave1 SPARK | SPARK_CLIENT | 2.5.0.0-1245 | hdp-master SPARK | SPARK_CLIENT | 2.5.0.0-1245 | hdp-slave1 SPARK | SPARK_JOBHISTORYSERVER | 2.5.0.0-1245 | hdp-master TEZ | TEZ_CLIENT | 2.5.0.0-1245 | hdp-master TEZ | TEZ_CLIENT | 2.5.0.0-1245 | hdp-slave1 YARN | APP_TIMELINE_SERVER | 2.5.0.0-1245 | hdp-slave1 YARN | NODEMANAGER | 2.5.0.0-1245 | hdp-master YARN | NODEMANAGER | 2.5.0.0-1245 | hdp-slave1 YARN | RESOURCEMANAGER | 2.5.0.0-1245 | hdp-slave1 YARN | YARN_CLIENT | 2.5.0.0-1245 | hdp-master YARN | YARN_CLIENT | 2.5.0.0-1245 | hdp-slave1 ZOOKEEPER | ZOOKEEPER_CLIENT | 2.5.0.0-1245 | hdp-master ZOOKEEPER | ZOOKEEPER_CLIENT | 2.5.0.0-1245 | hdp-slave1 ZOOKEEPER | ZOOKEEPER_SERVER | 2.5.0.0-1245 | hdp-master ZOOKEEPER | ZOOKEEPER_SERVER | 2.5.0.0-1245 | hdp-slave1 HIVE | MYSQL_SERVER | UNKNOWN | hdp-slave1 VORA | VORA | UNKNOWN | hdp-master VORA | VORA | UNKNOWN | hdp-slave1 ZEPPELIN | ZEPPELIN_MASTER | UNKNOWN | hdp-master (38 Zeilen) SELECT u.upgrade_id, u.direction, u.from_version, u.to_version, hrc.request_id, hrc.task_id, substr(g.group_title, 0, 30), substr(i.item_text, 0, 30), hrc.status FROM upgrade_group g JOIN upgrade u ON g.upgrade_id = u.upgrade_id JOIN upgrade_item i ON i.upgrade_group_id = g.upgrade_group_id JOIN host_role_command hrc ON hrc.stage_id = i.stage_id AND hrc.request_id = u.request_id ORDER BY hrc.task_id; upgrade_id | direction | from_version | to_version | request_id | task_id | substr | substr | status ------------+-----------+--------------+--------------+------------+---------+-------------------------------+-------------------------------+----------- 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6486 | Prepare Upgrade | [{"message":"Before continuin | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6487 | Prepare Upgrade | Check Tez Tarball | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6488 | Stop Components for High-Leve | Stopping Spark History Server | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6489 | Stop Components for High-Leve | Stopping WebHCat Server on hd | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6490 | Stop Components for High-Leve | Stopping HiveServer2 on hdp-s | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6491 | Stop Components for High-Leve | Stopping Hive Metastore on hd | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6492 | Stop Components for High-Leve | Stopping NodeManager on 2 hos | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6493 | Stop Components for High-Leve | Stopping NodeManager on 2 hos | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6494 | Stop Components for High-Leve | Stopping ResourceManager on h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6495 | Stop Components for High-Leve | Stopping App Timeline Server | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6496 | Stop Components for High-Leve | Stopping History Server on hd | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6497 | Perform Backups | [{"message":"Before continuin | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6498 | Perform Backups | Prepare HDFS | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6499 | Stop Components for Core Serv | Stopping Kafka Broker on hdp- | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6500 | Stop Components for Core Serv | Stopping DataNode on 2 hosts | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6501 | Stop Components for Core Serv | Stopping DataNode on 2 hosts | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6502 | Stop Components for Core Serv | Stopping NameNode on hdp-mast | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6503 | Stop Components for Core Serv | Stopping SNameNode on hdp-sla | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6504 | Stop Components for Core Serv | Stopping ZooKeeper Server on | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6505 | Stop Components for Core Serv | Stopping ZooKeeper Server on | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6506 | Update Target Stack | Update Target Stack | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6507 | Upgrade service configs | Updating configuration hdfs-s | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6508 | Upgrade service configs | Updating configuration ranger | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6509 | Upgrade service configs | Calculating Yarn Properties f | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6510 | Upgrade service configs | Updating configuration ranger | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6511 | Upgrade service configs | Updating configuration yarn-s | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6512 | Upgrade service configs | Apply config changes for Mapr | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6513 | Upgrade service configs | Updating configuration tez-si | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6514 | Upgrade service configs | Verify LZO codec path for Tez | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6515 | Upgrade service configs | Updating configuration webhca | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6516 | Upgrade service configs | Updating configuration hive-s | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6517 | Upgrade service configs | Updating configuration ranger | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6518 | Upgrade service configs | Updating configuration hive-s | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6519 | Upgrade service configs | Apply config changes for Hive | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6520 | Upgrade service configs | Updating configuration ranger | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6521 | Upgrade service configs | Updating configuration spark- | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6522 | Upgrade service configs | Updating configuration spark- | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6523 | Upgrade service configs | Updating configuration spark- | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6524 | Upgrade service configs | Updating configuration spark- | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6525 | Update Kerberos Descriptors | Update the user-specified Ker | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6526 | Set Version On All Hosts | Update stack to 2.5.0.0-1245 | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6527 | Set Version On All Hosts | Update stack to 2.5.0.0-1245 | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6528 | ZooKeeper | Restarting ZooKeeper Server o | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6529 | ZooKeeper | Restarting ZooKeeper Server o | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6530 | ZooKeeper | Restarting ZooKeeper Client o | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6531 | ZooKeeper | Restarting ZooKeeper Client o | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6532 | HDFS | Restarting NameNode on hdp-ma | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6533 | HDFS | Restarting SNameNode on hdp-s | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6534 | HDFS | Restarting HDFS Client on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6535 | HDFS | Restarting HDFS Client on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6536 | HDFS DataNodes | Restarting DataNode on 2 host | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6537 | HDFS DataNodes | Restarting DataNode on 2 host | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6538 | HDFS - Wait to leave Safemode | Wait to leave Safemode | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6539 | Kafka | Restarting Kafka Broker on hd | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6540 | YARN and MapReduce2 | Restarting History Server on | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6541 | YARN and MapReduce2 | Restarting MapReduce2 Client | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6542 | YARN and MapReduce2 | Restarting MapReduce2 Client | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6543 | YARN and MapReduce2 | Restarting App Timeline Serve | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6544 | YARN and MapReduce2 | Restarting ResourceManager on | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6545 | YARN and MapReduce2 | Restarting YARN Client on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6546 | YARN and MapReduce2 | Restarting YARN Client on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6547 | YARN NodeManagers | Restarting NodeManager on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6548 | YARN NodeManagers | Restarting NodeManager on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6549 | Tez, Pig, Sqoop Clients | Restarting Tez Client on 2 ho | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6550 | Tez, Pig, Sqoop Clients | Restarting Tez Client on 2 ho | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6551 | Tez, Pig, Sqoop Clients | Restarting Pig Client on 2 ho | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6552 | Tez, Pig, Sqoop Clients | Restarting Pig Client on 2 ho | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6553 | All Service Checks | Service Check ZooKeeper | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6554 | All Service Checks | Service Check HDFS | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6555 | All Service Checks | Service Check Kafka | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6556 | All Service Checks | Service Check YARN | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6557 | All Service Checks | Service Check MapReduce2 | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6558 | Hive Masters | Restarting Hive Metastore on | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6559 | Hive Masters | Restarting HiveServer2 on hdp | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6560 | Hive Masters | Restarting WebHCat Server on | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6561 | Hive Clients | Restarting Hive Client on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6562 | Hive Clients | Restarting Hive Client on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6563 | Hive Clients | Restarting HCat Client on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6564 | Hive Clients | Restarting HCat Client on 2 h | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6565 | Spark | Restarting Spark History Serv | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6566 | Spark Clients | Restarting Spark Client on 2 | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6567 | Spark Clients | Restarting Spark Client on 2 | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6568 | All Service Checks | Service Check Hive | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6569 | All Service Checks | Service Check Spark | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6570 | Finalize Upgrade Pre-Check | Check Component Versions | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6571 | Finalize Upgrade | [{"message":"Please confirm y | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6572 | Finalize Upgrade | Execute HDFS Finalize | COMPLETED 1 | UPGRADE | 2.3.4.7-4 | 2.5.0.0-1245 | 265 | 6573 | Finalize Upgrade | Save Cluster State | ABORTED (88 Zeilen)