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 SparkSQL. then I developed an IDEA plugin specifically for SparkSQL.
Address: https://plugins.jetbrains.com/plugin/26079-spark-sql-helper
This plugin currently supports all statements of SparkSQL version 3.5 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:
- 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
Top comments (0)