How do I download hive query results to a local machine?

If you are using HUE you can directly download the hive result as excel or CSV.

If you want to do it in command line then you use below commands

hive -e “sequence of commands” > output.csv

hive -f “filename.sql” > output.csv

Top 10 Business Intelligence

What are the top 10 business intelligence tools that can connect to external databases?

1. Tableau Software
2. Business Intelligence | Data Visualization Tools | Qlik
3. Power BI | Interactive Data Visualization BI Tools
4. Data Visualization & Analytics Software
5. Business Intelligence Software and Data Analytics
6. Data Science Platform | RapidMiner
7. Unveiling the beauty of statistics for a fact based world view.
8. Business Intelligence (BI) Software & Analytics Tools | Sisense
9. Board