DEV Community: DogeKing

Big Boost for Flink & Spark SQL: Both Tools Just Got Updated!

DogeKing — Sat, 08 Feb 2025 03:08:50 +0000

The latest update of SparkSQLHelper mainly introduces support for hint completions, with the release version being 2025.2.0.

Plugin Address: https://plugins.jetbrains.com/plugin/26079-spark-sql-helper

Alternatively, you can search for "SparkSQLHelper" directly in the JetBrains plugin marketplace.

The primary update for FlinkSQLHelper focuses on adding support for Hive syntax. The release version is also 2025.2.0.

Plugin Address: https://plugins.jetbrains.com/plugin/25912-flink-sql-helper

Alternatively, you can search for "FlinkSQLHelper" directly in the JetBrains plugin marketplace.

This update enhances the functionality of both plugins to better serve users working with SparkSQL and FlinkSQL, providing improved support for hints and Hive syntax respectively.

Like IDE for FlinkSQL: Support Pycharm! FlikSQLHelper v2025.1.0 released

DogeKing — Mon, 20 Jan 2025 09:15:55 +0000

Recently, I have received feedback from users again, Expecting me to support Pycharm.

So, The version v2025.1.0 released.Plugin Address: https://plugins.jetbrains.com/plugin/25912-flink-sql-helper

Like IDE for SparkSQL: Support Pycharm! SparkSQLHelper v2025.1.1 released

DogeKing — Tue, 14 Jan 2025 06:51:31 +0000

Recently, I have received feedback from users again, Expecting me to support Pycharm.

So, The version v2025.1.1 released.Plugin Address: https://plugins.jetbrains.com/plugin/26079-spark-sql-helper

Like IDE for SparkSQL: SparkSQLHelper v2024.1.4 released

DogeKing — Tue, 24 Dec 2024 13:34:53 +0000

Since I published the article: https://dev.to/dogeking/time-saver-this-idea-plugin-can-help-you-write-sparksql-faster-m6d, I have received much feedback.

I take user feedback very seriously and immediately made the fixes and released the latest version v2024.1.4. I hope you all enjoy using it.

This version fixes several important bugs, such as some parsing issues, and improves the error messages.

Plugin Address: https://plugins.jetbrains.com/plugin/26079-spark-sql-helper

Finally, I provide a one-month activation code(valid until December 31, 2024):

A58DD-DC5DC-TG47Y-9HSRR-5ZFTE
XZ4F7-YQR42-LKP95–66TZ4-VUUT8
DLWMY-E863U-P99JC-TJDMB-W8EB5
K56NB-GV4SS-7GAXM-PURV4-PSKBL
RVL57-JQ2H3-FCJGJ-P4MK9-M4J74

Time-saver: This IDEA plugin can help you write FlinkSQL faster

DogeKing — Wed, 18 Dec 2024 05:36:47 +0000

I often find my development efficiency affected by lacking a good Grammar-checking tool during big data development. Common issues include:

Missing commas, semicolons, or parentheses
Omitting certain keywords within CASE WHEN statements
Overlooking some keywords in nested queries
……

These problems become quite common once SQL statements get lengthy.

so I wanted a tool to provide an IDE-like experience while writing FlinkSQL. then I developed an IDEA plugin specifically for FlinkSQL.

Address: https://plugins.jetbrains.com/plugin/25912-flink-sql-helper

This plugin currently supports all statements of FlinkSQL version 1.20 Its main features include grammar checking, code formatting, and code completion.

Let me introduce the features of this plugin.

Grammar check

SQL Format

Code Completion Proposals

Refactorings

Finally, I will provide a one-month activation code(valid until December 31, 2024). I hope everyone enjoys using it:

88YTG-UYMBT-UAF7E-NZN48-MNBZ3
3H52G-Y33JM-Q9QS6-7KLBL-PY5QE
FSQNR-UP5X7-6F5WN-M54YJ-QXEF8
Z7FJJ-X2XS8-MB2FF-BG43S-M4QW2
HDHYN-AEZSS-CFGC8-KAV2V-MXLAM

Time-saver: This IDEA plugin can help you write SparkSQL faster

DogeKing — Wed, 18 Dec 2024 05:09:29 +0000