Support Questions
Find answers, ask questions, and share your expertise

is it possible to export all blueprint variables and values from ambari to file as csv file

we have ambari cluster ( HDP version 2.6.0 ) ,

this cluster is old cluster - one year uptime

we want to export all variables & values into file

is it possible to create this file that contain all variables & values from ambari by API or script or / tool ?

for example ( very short list )

zookeeper.session.timeout.ms=	30000
zookeeper.sync.time.ms=	2000
is_supported_kafka_ranger=	TRUE
kafka_log_dir=	/var/log/kafka
kafka_pid_dir=	/var/run/kafka
kafka_user=	kafka
kafka_user_nofile_limit=	128000
kafka_user_nproc_limit=	65536
controller_log_maxbackupindex=	20
controller_log_maxfilesize=	256
kafka_log_maxbackupindex=	20
kafka_log_maxfilesize=	256

Michael-Bronson
4 REPLIES 4

Mentor

@Michael Bronson

This simple API does exactly that jsut substitute the ambari_host and cluster name and you should be okay

  1. curl -H "X-Requested-By: ambari"-X GET -u admin:admin http://{ambari_host}:8080/api/v1/clusters/{Cluster_name}?format=blueprint > NewBlueprint.json

HTH

yes , but the question was how to covert it ( the json ) to CSV as my example

Michael-Bronson

Explorer

@Michael Bronson

You can get converters online

JsonToCSV converter

HTH

we want to add this approtch in our script , this should be sctripts that do the job not UI that copy and paset

Michael-Bronson