boletín de noticias

Reciba actualizaciones recientes de Hortonworks por correo electrónico

Una vez al mes, recibir nuevas ideas, tendencias, información de análisis y conocimiento de macrodatos.

AVAILABLE NEWSLETTERS:

Sign up for the Developers Newsletter

Una vez al mes, recibir nuevas ideas, tendencias, información de análisis y conocimiento de macrodatos.

cta

Empezar

nube

¿Está preparado para empezar?

Descargue sandbox

¿Cómo podemos ayudarle?

* Entiendo que puedo darme de baja en cualquier momento. Agradezco asimismo la información complementaria porporcionada en la Política de privacidad de Hortonworks.
cerrarBotón de cerrar
cta

Estudio de análisis de datos

Compress Time to Insight by Optimizing Query Performance and Cluster Operations

Aumente la capacidad de su equipo de informática para cumplir los requisitos empresariales

Leer informe de la solución

Información general

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.

Beneficios

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

Informe de la solución: Aumente la capacidad de su equipo de informática para cumplir los requisitos empresariales con 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

Informe de la solución: Aumente la capacidad de su equipo de informática para cumplir los requisitos empresariales con Hortonworks Data Analytics Studio
Boost Productivity Through Intuitive Query Tools

Data Analytics Studio Solution