Abstract: It is well known that the students of data development and analysis spend a lot of time writing MaxCompute SQL every day; Dataworks as a data development IDE directly affects the efficiency of everyone’s development, the new online Dataworks we have done a lot of work on the editing experience, in the front end to achieve MaxCompute SQL and editor parameters and other extended syntax AST parsing, and achieve better and more intelligent generation


As you know, data development and analysis students spend a lot of time writing MaxCompute SQL every day; Dataworks as a data development IDE directly affects the efficiency of everyone’s development, the new online Dataworks we have done a lot of work on the editing experience, in the front end to achieve MaxCompute SQL and editor parameters and other extended syntax AST parsing, and achieve better and more intelligent code tips, faster response, Help everyone improve development efficiency;
 
First show some beautiful pictures:




How does it look? Doesn’t it look like a local editor? It’s Cool


Let’s take a look at each of these new features.




MaxCompute SQL syntax error (row, column)


MaxCompute 2.0 syntax is supported, and error locations can be accurate to rows and columns.




2. Display specific error messages in the editor


Quickly locate problems, support syntax analysis, and prompt users with detailed error information.


3, automatic completion (keyword /project/ table/field)


Keywords, project, tables, and fields appear in the right places; ‘from’, ‘XXX join’, ‘drop table/view’,’ ALTER table/view’; ‘SELECT ‘,’ WHERE ‘, ‘having’, ‘on’, ‘order by’, ‘Partitioned BY ‘, ‘distibute by’, ‘sort by’, ‘desc’ Field prompt in subquery mode.


Syntax highlighting for multiple languages


The new editor supports syntax highlighting of SQL and Shell languages to highlight the key points of a programming language in color.






5. Shortcut key support


Shortcuts make it easy to edit code, such as save and undo actions.


Save – Ctrl+S/Cmd+S
Undo – Ctrl+Z/Cmd+Z
Redo – Ctrl+Y/Cmd+Y
Find – Ctrl+F/Cmd+F
Replace – Ctrl+Shift+F/Cmd+Alt+F
Delete a row – Ctrl+Shift+K/Cmd+Shift+K
The same word selection – Ctrl+D/Cmd+D
Block comments – Ctrl+/ / Cmd+/




6. Code folding


When writing a lot of code, it is often impossible to quickly and accurately find which code is a function module and which code is a pair of label blocks because of too much code. At this time, the function of code indentation and folding becomes very important. Click the – sign to complete the code folding.


7, intelligent editor lenovo speed up


The new editor, not only supports 2.0, but also improves lenovo speed by 40%, making it faster and more accurate.


8. Code retrieval supports more methods


The new version supports more flexible query methods such as case and regular expression, and users can enable the code search function by pressing Ctrl+F.
The original link
To read more articles, please scan the following QR code: