Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

not supporting create table as in postgres dialect #400

Closed
reata opened this issue Jul 2, 2023 · 0 comments · Fixed by #397
Closed

not supporting create table as in postgres dialect #400

reata opened this issue Jul 2, 2023 · 0 comments · Fixed by #397
Labels
bug Something isn't working

Comments

@reata
Copy link
Owner

reata commented Jul 2, 2023

CREATE TABLE bar AS
SELECT *
FROM foo
$ sqllineage -f test.sql --dialect=postgres
Traceback (most recent call last):
  File "/home/hujunwei/.pyenv/versions/3.8.6/bin/sqllineage", line 8, in <module>
    sys.exit(main())
  File "/home/hujunwei/.pyenv/versions/3.8.6/lib/python3.8/site-packages/sqllineage/cli.py", line 101, in main
    runner.print_table_lineage()
  File "/home/hujunwei/.pyenv/versions/3.8.6/lib/python3.8/site-packages/sqllineage/runner.py", line 168, in print_table_lineage
    print(str(self))
  File "/home/hujunwei/.pyenv/versions/3.8.6/lib/python3.8/site-packages/sqllineage/runner.py", line 22, in wrapper
    self._eval()
  File "/home/hujunwei/.pyenv/versions/3.8.6/lib/python3.8/site-packages/sqllineage/runner.py", line 177, in _eval
    self._stmt_holders = [analyzer.analyze(stmt) for stmt in self._stmt]
  File "/home/hujunwei/.pyenv/versions/3.8.6/lib/python3.8/site-packages/sqllineage/runner.py", line 177, in <listcomp>
    self._stmt_holders = [analyzer.analyze(stmt) for stmt in self._stmt]
  File "/home/hujunwei/.pyenv/versions/3.8.6/lib/python3.8/site-packages/sqllineage/core/parser/sqlfluff/analyzer.py", line 69, in analyze
    raise UnsupportedStatementException(
sqllineage.exceptions.UnsupportedStatementException: SQLLineage doesn't support analyzing statement type [create_table_as_statement] for SQL:CREATE TABLE bar AS
SELECT *
FROM foo
@reata reata added the bug Something isn't working label Jul 2, 2023
@reata reata closed this as completed in #397 Jul 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant