News

Visual Studio Code Gets HDInsight Tools for Big Data Analytics

Microsoft announced HDInsight Tools for Visual Studio Code is now generally available, letting coders do Big Data analytics right from within the cross-platform, open source code editor.

Specifically, Azure HDInsight Tools for Visual Studio Code is an extension in the Visual Studio Code Marketplace "for developing Hive Interactive Query, Hive Batch Job and PySpark Job against Microsoft HDInsight." The company describes Azure HDInsight as an enterprise-grade service for open source analytics.

The Azure HDInsight service supports popular open source Apache products including Hadoop, Spark, Kafka, HBase, Live LLAP and Storm, as well as including machine learning functionality. The VSCode extension, however focuses on developing HDInsight PySpark and Hive batch jobs and interactive query.

HDInsight Tools for Visual Studio Code
[Click on image for larger view.] HDInsight Tools for Visual Studio Code (source: Microsoft).

"For PySpark developers who value the productivity Python enables, HDInsight Tools for VSCode offer a quick Python editor with simple getting started experiences, and allow you to submit PySpark statements to HDInsight clusters with interactive responses," said Jenny Jiang, principal program manager, Big Data Team, in a blog post Wednesday (Jan. 23). "This interactivity brings the best properties of Python and Spark to developers and empowers you to gain faster insights.

"For Hive developers, HDInsight tools for VSCode offer great data warehouse query experiences for Big data and helpful features in querying log files and gaining insights."

Key benefits to developers in the tool include:

  • Integration with Azure worldwide environments for Azure sign-in and HDInsight cluster management
  • HDInsight Hive and Spark job submission with integration with Spark UI and Yarn UI
  • Interactive responses with the flexibility to execute one or multiple selected Hive and Python scripts
  • Preview and export your interactive query results to CSV, JSON, and Excel format
  • Built-in Hive language services such as IntelliSense auto-suggest, autocomplete, and error marker, among others
  • Supports HDInsight ESP Cluster and Ambari connection
  • Simplified cluster and Spark job configuration management

The post also detailed several improvements that were made to the tool since it was released in preview, including: connectivity to more Azure environments; support for the HDInsight Enterprise Security Package; simpler clusters and Spark job configuration management; and integration with VSCode Azure Account and HDInsight Explorer.

The extension lists more than 15,500 installs and more than 52,819 downloads, earning an average 4.1 rating (0-5 scale) from seven developers who reviewed it.

About the Author

David Ramel is an editor and writer for Converge360.

Featured

  • Bright Tunnel

    Visual Studio 16.4 Preview 2 Boosted by Extension Tech

    Microsoft today shipped Visual Studio 2019 v16.4 Preview 2, boosted with new features that come from formerly separate extensions.

  • Nebula

    .NET Core 3.1 Preview 1 Focuses on Blazor, Desktop

    The first preview of .NET Core 3.1 focuses on two of the big features highlighting the Sept. 23 release of .NET Core 3.0: Blazor (for C# Web development instead of JavaScript) and desktop development (Windows Forms and Windows Presentation Foundation).

  • Stone Steps Graphic

    Microsoft Research's SandDance Data Visualization Tool Goes Open Source

    A data visualization tool some four years in the making from Microsoft Research has been open sourced, available for use as an extension for Visual Studio Code or Azure Data Studio.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events