Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio introduces support for Apache Hive: the Big Data warehousing product that uses Hadoop's HDFS as storage for providing data summarization, query, and analysis of billions of rows across millions of columns. With Aqua Data Studio 14.0, you can register an Apache Hive connection and use features such as the Query Analyzer Window, FluidShell, Visual Editors, Export Tools, ER Modeler and Schema Script Generator.
Supports Apache Hive 0.11
Explore your Apache Hive server's schema by using the Schema Browser: a visual tree that shows the contents of all of your Schema Objects. Right click on an object to view its properties, create new objects, or alter existing ones.
Add Apache Hive tables and columns, modify table constraints and even edit table storage parameters. Edit the data within a table using an excel-like grid via Aqua Data Studio's Table Data Editor. Using Query Builder, you can even create complex join statements without ever typing a line of SQL code, but still see the SQL Aqua Data Studio is generating for you.
Right click on a Apache Hive object in the Schema Browser and you can script it as CREATE, ALTER, DROP to have Aqua Data Studio generate DDL for you. With the Schema Script Generator you can pick and choose which objects to script, or script the entire contents of a server.
Connect to Apache Hive and execute SQL queries effortlessly by using intelligent Autocomplete, SQL Abbreviations and SQL Automation. Perform advanced analysis by using the built-in Pivot Grid and Charts, or one-click export to Excel.
Learn more
Rapidly create Apache Hive Databases, Schemas, Tables, Views and much more through Aqua Data Studio's highly streamlined Visual Editing UI. Alter and Drop objects just as easily.
Learn more
Use our UI's built-in ETL functionality to export data, massage it to suit your needs and even export it in a different format. Use Aqua Data Studio's wizards to walk you through, step by step, exporting data from existing Apache Hive tables and data based on your desired format.
Learn more
Script a complete Apache Hive database to file, including CREATE, DROP DDL and INSERT DML without ever typing an SQL command. Save the generated scripts for later or share them with coworkers.
Learn more
Rapidly generate SQL scripts for Apache Hive server objects such as Database, Tablespaces, Groups and Users. Script as a single file, or create an individual file per object into a folder.
Learn more
Create and manage Apache Hive ER diagrams. From a simple reverse engineering of your existing database to designing a highly complex diagram involving thousands of entities, you can annotate, forward engineer, perform diffs, generate HTML reports and much more.
Learn more
Use Open APIs to create fully automated end-to-end solutions for your Apache Hive databases using JavaScript. Aqua Data Studio provides a full-fledged IDE with APIs to Apache Hive database access, schema DDL generation, Grid and Pivot Grid charts, version control and much more.
Learn more
Generate great looking charts and graphs from your Apache Hive database content. Choose from a variety of chart types and customize until you've designed exactly what you need to visualize your data. All charts are updated in real time based on your query results. You can even pivot your data and create charts based off of your pivoted data.
Learn more
Automate your database ETL tasks using FluidShell, an interactive shell which combines the power of an SQL command line with the versatility of a Unix shell.
Learn more
Quickly determine the differences between Apache Hive Schema Objects, Databases, Functions, Packages and more by using the Schema Compare tool. Generate HTML reports of the results once your comparisons are done.
Learn more
After you've generated results from a query, use the Results Compare Tool to search, filter and sort differences. Generate HTML reports of the comparison to share with others.
Learn more
Construct sophisticated database queries without ever writing a line of SQL. Use our UI to select tables and columns and leverage our rich set of visual options including JOINs, GROUP BYs, SORT ORDER, equality comparisons and more.
Learn more
Automatically record and archive all of the queries you run on Apache Hive servers and store them in a centralized location for auditing purposes. View a history of all the SQL statements and scripts that have been executed within the Query Analyzer, Query Builder and Table Data Editor. Execute a query from months or even years ago.
Learn more