cuopyue

KO | EN

gitlite — search

#react #typescript #llm #android #machine-learning #deep-learning #linux #nodejs #macos #windows #cli #vue #security #ios

(★ 18)

spark sql parser

cuopyue Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# cuopyue
---
parse sparksql syntax, format SQL

[![NPM version][npm-image]][npm-url]

[npm-image]: https://img.shields.io/npm/v/cuopyue.svg?style=flat-square
[npm-url]: https://www.npmjs.com/package/cuopyue

## Getting Started

Install cuopyue using npm:

```bash
npm install cuopyue -S
```

Import coupyue in your js file

```javascript
import { parser } from 'cuopyue';
```

Then, call `parserSparksql` method

```javascript
const sql = 'select age, nickname from userInfo; select id, price from payInfo;'
const tree = parser.parserSparkSql(sql);
...
```
You will get an array of syntax tree.

## Complex example

### Catch Syntax Error

```javascript
import { parser } from 'cuopyue';
const sql = 'select age, nickname fr1om userInfo;'
parser.parserSparkSql(sql, (recognizer, offendingSymbol, line, column, msg) => {
    const errorText = offendingSymbol.text;
    console.error(msg);
});
```

### Get Table Name

```javascript
import { parser, visitor } from 'cuopyue';
const sql = 'select age, nickname from userInfo as u;'
class Visitor extends visitor.SparkTreeVisitor {
    visitTableName (ctx) {
        const tableName = ctx.tableIdentifier().getText();
        const tableAlias = ctx.tableAlias().strictIdentifier().getText();
        super.visitTableName(ctx);
    }
}
parser.parserSparkSql(sql, null, new Visitor());
```

### Format SQL

```javascript
import { parser, visitor } from 'cuopyue';
const sql = 'select age, nickname from userInfo as u;'
let formatVisitor = new visitor.SparkFormatVisitor();
parser.parserSparkSql(sql, null, formatVisitor);
console.log(formatVisitor.getFormatText());
```

cuopyue

cuopyue Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

cuopyue

cuopyue Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README