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

Import with use_temp_table=False does not work on Teradata #8075

Closed
exalate-issue-sync bot opened this issue May 11, 2023 · 2 comments
Closed

Import with use_temp_table=False does not work on Teradata #8075

exalate-issue-sync bot opened this issue May 11, 2023 · 2 comments

Comments

@exalate-issue-sync
Copy link

Add note to docs that Teradata JDBC queries need use_temp_table=False, for example:

{noformat}h2o.import_sql_select(connection_url, select_query, username, password, use_temp_table=False){noformat}

Otherwise this error occurs:

{noformat}[Teradata Database] [TeraJDBC 16.20.00.06] [Error 3707] [SQLState 42000] Syntax error, expected something like a name or a Unicode delimited identifier or '(' between the 'AS' keyword and the 'select' keyword.{noformat}

@exalate-issue-sync
Copy link
Author

Neema Mashayekhi commented: If Honza can get fix in 3.30.0.5, won’t need documentation. Otherwise, will add docs till get a fix.

@h2o-ops
Copy link
Collaborator

h2o-ops commented May 14, 2023

JIRA Issue Migration Info

Jira Issue: PUBDEV-7563
Assignee: Jan Sterba
Reporter: Joseph Granados
State: Resolved
Fix Version: 3.30.0.5
Attachments: N/A
Development PRs: Available

Linked PRs from JIRA

#4715

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

No branches or pull requests

1 participant