Created on 03-07-2017 02:05 AM - edited 09-16-2022 04:12 AM
Dear Community,
I finally was able to work and manage my twitter analysis using NiFi + Hortonworks. Now that i've accomplished my data source, i would like to create a nice report output.
got a suggestion?
ps: I used to work with Bi Publisher.
Regards
Created 03-07-2017 02:10 AM
Try Zeppelin notebook. Here is a basic example of ingesting data from a source via NiFi, store it to Hive and access it via Zeppelin:
There are several good notebooks in HDP sandbox, but also Github. That is if you stored your data in HDFS or HBase and you wanted to see how to report on it with Zeppelin.
Other notebooks can be also connected to HDP, e.g. iPython or Jupyter.
Created 03-07-2017 02:10 AM
Try Zeppelin notebook. Here is a basic example of ingesting data from a source via NiFi, store it to Hive and access it via Zeppelin:
There are several good notebooks in HDP sandbox, but also Github. That is if you stored your data in HDFS or HBase and you wanted to see how to report on it with Zeppelin.
Other notebooks can be also connected to HDP, e.g. iPython or Jupyter.
Created 03-07-2017 02:23 AM
Hi @Constantin Stanca Thanks for replying. I've tried Zeppeling and his Notebooks, but what i need is to create my own layouts and finally export to pdf, xls or even rtf.
Regards
Created 03-07-2017 02:53 AM
I am not sure why wouldn't you be able to create your layout with any of the notebooks, e.g. Zeppelin, iPython or Jupyter and print to output to PDF use a PDFWriter driver to print to, for example.
Also, you can use the BI of your choice as long as it can use JDBC or ODBC access to Hive or Phoenix for HBase, for example. You could also point R Studio to Hive and you can render your report to PDF using markup available in R.
When you say "I want to create my own layouts" could you be more specific ... What is missing?
Created 03-07-2017 05:00 PM
Got you. I like to use R Studio connected to HDP and use markdown language to generate PDF files: http://rmarkdown.rstudio.com/pdf_document_format.html
True. This is more a tool for data science.
On the other hand any tool that you like and can use ODBC or JDBC can connect to Hive or to HBase via Phoenix. Try that approach.
Created 03-08-2017 01:35 AM
Excellent!!
This is what i wanted. Thanks