Data Analytics Studio helps users perform operations on Hive tables and provides recommendations for optimizing the performance of queries.
Administrators can perform operations such as managing the databases.
Using Data Analytics Studio, you can perform the following operations:
- Search queries - You can search forqueries executed on Hive tables in a database. You can further refine your search results using filters. Data Analytics Studio provides recommendations to optimize the performance of your queries on Hive tables. You can view the recommendations and edit your queries.
- Compose and execute queries - You can compose queries using the intuitive query composer. It has context based auto-complete to help editing a query faster. You can also view the visual explain of the query after executing it. You can save queries to view them later and edit them. You can edit existing saved queries and save them as new queries. When you try to edit a query, you can use the query composer to easily create and execute your queries.
- Manage databases - Using the Database Explorer, you can manage existing databases by creating new tables, editing existing tables, and deleting tables. You can also create new database and add tables to it. You can manage existing tables by editing them to modify existing columns or add new columns. You can create new tables in Data Analytics Studio or upload existing tables available in CSV, JSON, and XML formats. You can edit columns in tables and also view suggestions for partitions and implement these recommendations.
- View reports -You can view which columns and tables are used for joins and make changes to the data layout to optimize the performance of the query with different search criteria.