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

Cannot create a dataset with Presto DB #1588

Closed
kaypark-skt opened this issue Mar 6, 2019 · 0 comments
Closed

Cannot create a dataset with Presto DB #1588

kaypark-skt opened this issue Mar 6, 2019 · 0 comments
Assignees
Labels
bug Something isn't working @dataprep Component Name : Data preparation
Milestone

Comments

@kaypark-skt
Copy link
Contributor

kaypark-skt commented Mar 6, 2019

Describe the bug

when creating a dataset with presto db

  1. /api/connections -> get a connection
  2. /api/connections/query/check -> using the connection. it is ok.
  3. /api/connections/query/databases -> using the connection. a few properties missing.

i heard that
presto needs a parameter of catalog.
postgresql needs a parameter of database.

To Reproduce

  1. create a Presto DB connection
  2. create a dataset with the connection.

you can see this message.

"code":"JDC0003",
"message":"Fail to get list of database : StatementCallback; uncategorized SQLException for SQL [ SELECT schema_name FROM information_schema.schemata WHERE catalog_name = 'null' ORDER BY schema_name ]; SQL state [null]; error code [1]; Query failed (#20190306_071107_00020_2eybd): line 1:27: Catalog must be specified when session catalog is not set; nested exception is java.sql.SQLException: Query failed (#20190306_071107_00020_2eybd): line 1:27: Catalog must be specified when session catalog is not set"

Expected behavior

Screenshots
20190319_164750

Desktop (please complete the following information):

  • OS: all
  • Browser : all

Additional context

@kaypark-skt kaypark-skt added the @dataprep Component Name : Data preparation label Mar 6, 2019
@joohokim1 joohokim1 added the bug Something isn't working label Mar 13, 2019
@joohokim1 joohokim1 added this to the 3.2.0 milestone Mar 13, 2019
kaypark-skt pushed a commit that referenced this issue Mar 21, 2019
* #1588 Fix parameter when database is presto and postgre

* #1588 Fix postgre, presto dataset creation error

* #1588 Fix wrong value for dbName when database is postgreSQL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working @dataprep Component Name : Data preparation
Projects
None yet
Development

No branches or pull requests

4 participants