newsletter

Obtenez par e-mail toute l'actualité Hortonworks

Une fois par mois, recevez les dernières idées, tendances, informations d’analyse et découvertes sur le Big Data.

AVAILABLE NEWSLETTERS:

Sign up for the Developers Newsletter

Une fois par mois, recevez les dernières idées, tendances, informations d’analyse et découvertes sur le Big Data.

cta

Démarrer

cloud

Prêt à débuter ?

Télécharger Sandbox

Que pouvons-nous faire pour vous ?

* Je comprends que je peux me désabonner à tout moment. J'ai également compris les informations supplémentaires fournies dans la Politique de confidentialité de Hortonworks.
fermerBouton Fermer
cta

Studio d'analyse de données

Compress Time to Insight by Optimizing Query Performance and Cluster Operations

Scale your IT team to meet business requirements

Read Solution Brief

Présentation

Data Analytics Studio (DAS) enables IT teams to scale to business requirements by providing diagnostic tools and intelligent recommendations to make business analysts become self-sufficient and productive. DAS helps users perform operations on Hive tables and provides recommendations for optimizing the performance of their queries. With DAS, business analysts can search for queries, compose and execute queries, manage databases to create and edit tables, view reports and recommendations to optimize the query performance.

Avantages

Develop visibility into cluster performance

Quickly narrow down problematic queries in a large cluster through pre-defined reports and searches. Analysts can search for queries executed on Hive tables in a database and further refine the search based on parameters such as status of the query, queue to which the query belongs, the user of the query, tables read and written for the query, and execution modes. With DAS, IT teams and business analysts have visibility into:

    Pre-built query log reports
  • Most expensive queries
  • Long running queries
  • Hot files and tables
  • Space usage by table etc.
    Query Log Filter and Search
  • Tables not using statistics
  • Queries not optimized by cost-based optimization (CBO)

Blog: Announcing the General Availability of Data Analytics Studio
Scale to Business Demands by Running Optimized Clusters
Optimize cluster operation

Get visibility into cluster utilization through intuitive database heat map. IT teams 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. DAS enables IT teams to proactively resolve issues by providing access to:

  • Heatmap to easily visualize cluster utilization
  • Out-of-the-box recommendations for storage level optimization
  • Built-in batch operations to automate routine tasks

Solution Brief: Scale Your IT Team to Meet the Business Requirements with Hortonworks Data Analytics Studio
Optimize Cluster Operation
Run faster and efficient queries

Data Analytics Studio provides recommendations to optimize the performance of the queries on Hive tables based on heuristic recommendation engine. With DAS, business analysts have access to:

  • Query level optimizations
  • Detailed query level report
  • Admin alerts for expensive queries

Blog: Announcing the General Availability of Data Analytics Studio
Run Faster and Efficient Queries
Boost productivity through intuitive query tools

Enhance productivity and automate routine tasks through out-of-the-box functionality. Analysts can compose queries using the intuitive query composer. The auto-complete functionality in DAS suggests SQL commands, keywords, and table columns based on the context to help edit queries faster. Analysts can also preview a few rows from the table and they have the flexibility to save queries in order to view and edit them later. DAS enables business analysts to be more productive through:


  • Query editor with autocomplete functionality
  • Data browser to view top 20 rows of sample data
  • Specify output destination (S3, CVS etc.)
  • Ability to terminate long-running queries

Solution Brief: Scale Your IT Team to Meet the Business Requirements with Hortonworks Data Analytics Studio
Boost Productivity Through Intuitive Query Tools

Data Analytics Studio Solution