The Ambari visuals are typically used for monitoring metrics collected by Ambari. Bringing in external data is not the intent of the visuals with Ambari Metrics. I would consider either using the new Hive View in HDP 2.4 that you can access in Ambari to visualize your dummy data. You can put that dummy data in a Hive table and then use the Ambari Hive View to visual that data. A second option would be to use Zeppelin and you can bring that dummny data into a Spark data frame.
Here is a good sample to work from: https://www.zeppelinhub.com/viewer/notebooks/aHR0cHM6Ly9yYXcuZ2l0aHVidXNlcmNvbnRlbnQuY29tL2hvcnRvbnd...
Put your Raw_data1.txt into hadoop
%sh hadoop fs -put Raw_data1.txt /tmp/Raw_data1.txt
Create a data set
Define your schema and create a table
case class MyData (Users: String, City: String, Library:String) val = mydata.map(k=>k.split(",")).map( k => MyData( k(0),k(1),k(2) ) mydata.toDF().registerTempTable("raw_table")
Create your query and visualize it
%sql select sum(Users), City, Library from raw_table group by City, Library
raw-data-and-sample-graph.zip@ccasano ,Hi Ccasano, thanks for your response.
let us assume that the data is already present in Ambari Visualization I want to represent my data in the graphical format.
Please see the attached files for better explanation of what I am trying to do.
in the scenario,
It has three columns:
So I am looking to plot the graph that says:
I have total 55 users from Pune city that go to three libraries.
20 in library_A
20 in library_B
And 15 in library_C.
Take a look at pivot chart in zeppelin. Your chart is very easy to get in zeppelin using that. You can explore other visualizations as well in zeppelin.
Created 05-31-2016 03:26 PM
you can query all three columns and use color column feature in Advanced visualization to make it 3d.