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 at Converge 360.

comments powered by Disqus

Featured

  • Microsoft Highlights Visual Studio Live! Event Lineup and Longtime Developer Community Role

    A Microsoft MVP Blog post on Visual Studio Live!'s longevity arrives as the 2026 conference series continues with upcoming stops at Microsoft HQ, San Diego and Orlando.

  • Using Local AI to Cut Copilot Usage-Based Billing Shock

    After being gobsmacked by the new billing plan using almost all my monthly credits in one or two days, I tried pushing some Copilot-style coding work onto local models in VS Code. What I found was less "free AI" and more "pick your pain": cloud charges on one side, heavy local resource use and long waits on the other.

  • .NET 11 Preview 5 Focuses on Performance, Productivity and Safer Code

    .NET 11 Preview 5 focuses on under-the-hood runtime performance gains, streamlined APIs and language features that reduce boilerplate, plus built‑in security checks and incremental ASP.NET Core and EF Core improvements aimed at everyday developer productivity.

  • VS Code 1.124 Focuses on Agent Autonomy and Parallel Sessions

    Microsoft's June 2026 VS Code update turns on Autopilot by default and adds background sending for agent sessions.

Subscribe on YouTube