Skip to content

CREATE DATABASE location #453

Closed
Closed

Description

@KyGost

#451 implemented support for CREATE DATABASE queries.
It includes two tests for the query.

Statement::CreateDatabase has two additional fields: location and managed_location. The syntax for these is not detailed; neither in the PR, nor anywhere else I can find.

  1. Perhaps this could be detailed in the docs
  2. Perhaps tests could be added for these fields
  3. What is the syntax for these fields?

Activity

  1. KyGost commented on Apr 4, 2022

    @KyGost
    Author

    Looking at the parser one can see that the syntax is:

    CREATE DATABASE [database] LOCATION '[location]'
  2. AugustoFKL commented on Feb 25, 2023

    @AugustoFKL
    Contributor

    @KyGost hey! I'm a new maintainer of SQL-parser (see #808), but I'd like to apologize for the huge delay. I'm catching up on old issues/PRs in my first three weeks, so I can start discussing/helping with syntax expansions again.

    You're entirely correct. For your interest, I could find the PR that this was implemented (#235), and the syntax is from Hive SQL (check apache docs).

    I'll add some comments regarding the syntax and the specificity of the syntax. Thanks for noting this!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions