ニュースレター

Hortonworks から最新情報をメールで受け取る

月に一度、ビッグデータに関する最新のインサイト、トレンド、分析情報、ナレッジをお届けします。

AVAILABLE NEWSLETTERS:

Sign up for the Developers Newsletter

月に一度、ビッグデータに関する最新のインサイト、トレンド、分析情報、ナレッジをお届けします。

行動喚起

始める

クラウド

スタートのご用意はできましたか?

Sandbox をダウンロード

ご質問はありませんか?

*いつでも登録を解除できることを理解しています。Hortonworks プライバシーポリシーのその他の情報も確認しています。
クローズクローズボタン
行動喚起

データ分析スタジオ

Compress Time to Insight by Optimizing Query Performance and Cluster Operations

Scale your IT team to meet business requirements

Read Solution Brief

概要

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.

メリット

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