cuopyue
parse sparksql syntax, format SQL
Getting Started
Install cuopyue using npm:
npm install coupyue -S
Import coupyue in your js file
;
Then, call parserSparksql
method
const sql = 'select age, nickname from userInfo; select id, price from payInfo;'const tree = parser;...
You will get an array of syntax tree.
Complex example
Catch Syntax Error
;const sql = 'select age, nickname fr1om userInfo;'parser;
Get Table Name
;const sql = 'select age, nickname from userInfo as u;'SparkTreeVisitor { const tableName = ctx; const tableAlias = ctx; super; }parser;
Format SQL
;const sql = 'select age, nickname from userInfo as u;'let formatVisitor = ;parser;console;