Best studio software/tool to run HIVE SQL/HQL queries by a data analyst
- Hue has a Web SQL Editor with autocomplete, display of table/data samples, light graphing, query download
1. RazorSQL
- SQL Query Tool and Database Client
- RazorSQL is an SQL query tool, database editor, database browser, and database administration tool for Windows, macOS / Mac OS X, Linux, and Solaris.
2.SQL Editor
- Edit SQL scripts.
- Run SQL queries.
- Auto column and auto table lookup.
- Multi-tabular query display.
- Supports over 20 programming languages including SQL, PL/SQL, T-SQL, PHP, HTML, XML, Java, and more.
3. Database editor
- Edit database tables in a spreadsheet format with support for finding and replacing data, automatic generation of SQL, and support for editing multi-line data.
4. Sql query builder
- Easily build select, insert, delete, and update SQL queries and statements. Build multi-table joins.
5. Database GUI Tools
- Includes tools for creating tables, views, indexes, procedures, functions, triggers, databases, users and tools for altering and dropping tables and views.
- Also includes tools for visually editing procedures, functions, and triggers.