[JBoss JIRA] (TEIID-5850) DDL server and foreign data wrapper handling is unclear
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5850?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5850:
---------------------------------------
> CREATE FOREIGN DATA WRAPPER salesforce ...
The options clause is currently not used. This statement is mostly for compliance with the spec as we use a set of well-known names and/or the name is defined by the custom translator.
However the options clause should mean "apply these properties to all such instances of salesforce in this vdb" - but currently does not as that does not line up to our old design. We should probably make that change as ddl deployment docs suggests it already works this way.
> CREATE FOREIGN DATA WRAPPER mysalesforce TYPE salesforce ...
This is specific to Teiid and is effectively the same as a translator override in our old terminology. Here the options are applied as execution properties. This is documented on our Translator Properties page. However ideally it should be combined most of the time with the first statement.
> CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce' ...
Here as well the options are currently not applied as execution properties. In fact the only property that is used is resource-name. By the spec this could include resource adapter / source config properties if/when we allow for direct configuration in the vdb. Need to document that execution properties do not apply here.
Import properties can be specified either on the import statement or on the schema (which seems clear enough).
> DDL server and foreign data wrapper handling is unclear
> -------------------------------------------------------
>
> Key: TEIID-5850
> URL: https://issues.jboss.org/browse/TEIID-5850
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 13.0, 12.2.2, 12.3.1
>
> Original Estimate: 6 hours
> Remaining Estimate: 6 hours
>
> CREATE server statements in DDL are effectively ignored in the conversion to runtime state - they are simply validated. Similarly a CREATE foreign data wrapper statement that does not specify a type is ignored.
> Attempting to do something like:
> {code}
> CREATE FOREIGN DATA WRAPPER salesforce;
> CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce', supportsOrderBy true);
> {code}
> or
> {code}
> CREATE FOREIGN DATA WRAPPER salesforce OPTIONS (supportsOrderBy true);
> CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce');
> {code}
> will not result in supportsOrderBy being set on the translator.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months
[JBoss JIRA] (TEIID-5848) views in vertica not found by teiid
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5848?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5848:
---------------------------------------
> Im using version 1.2.
Then the host-name property should work.
> It is working with ddl altering view.
Great
> How can i setup security and set password and user for teiid server in spring-boot application?
This likely should be spawned as a separate issue or stackoverflow post.
By default there would not be authentication configured. If I try a connection to the vdb example: jdbc:teiid:customer@mm://localhost:31000 it succeeds without an issue.
> views in vertica not found by teiid
> -----------------------------------
>
> Key: TEIID-5848
> URL: https://issues.jboss.org/browse/TEIID-5848
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> We created view in vertica DB
> Example project with vertica translator+odata not found this view
> {code}
> src 1 Varchar 4 [NULL] true false false [NULL] false [NULL]
> src_id 2 Varchar 18 [NULL] true false false [NULL] false [NULL]
> src_name 3 Varchar 363 [NULL] true false false [NULL] false [NULL]
> account_id 4 Varchar 18 [NULL] true false false [NULL] false [NULL]
> name 5 Varchar 765 [NULL] true false false [NULL] false [NULL]
> billing_country 6 Varchar 240 [NULL] true false false [NULL] false [NULL]
> root_domain 7 Varchar 192 [NULL] true false false [NULL] false [NULL]
> sales_team 8 Varchar 240 [NULL] true false false [NULL] false [NULL]
> {code}
> {
> "error": {
> "code": null,
> "message": "Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'funnel_leads'."
> }
> }
> But regular tables works properly
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months
[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5851:
---------------------------------------
User is a reserved word. It must be quoted to be used as an identifier:
... FROM "User"
> teiid rename table in salesforce
> --------------------------------
>
> Key: TEIID-5851
> URL: https://issues.jboss.org/browse/TEIID-5851
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> In example project connected to SF i have a table named "User" in SF but "User_" in teiid metadata.
> And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
> GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be "User_" named because we have same name in teiid metadata system names?
> So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId" do not working.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months
[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ]
Renat Eskenin edited comment on TEIID-5851 at 11/18/19 8:43 AM:
----------------------------------------------------------------
Yes, name of table is User, but request do not working, its so strange.
I call "Select Name From Tables" and get "User" name of table User in sf. But request do not working.
And simple check do not working with this name
{code:sql}
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "SELECT Id FROM [*]User[*] LIMIT 1" at line 1, column 16.
Was expecting: "table" | "lateral" | "xmltable" | id | <ESCAPEDJOIN> | "("
{code}
"Select name from tables" get
"
UndecidedEventRelation
User
UserAppInfo
"
was (Author: i3draven):
Yes, name of table is User, but request do not working, its so strange.
I call "Select Name From Tables" and get "User" name of table User in sf. But request do not working.
And simple check do not working with this name
{code:sql}
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "SELECT Id FROM [*]User[*] LIMIT 1" at line 1, column 16.
Was expecting: "table" | "lateral" | "xmltable" | id | <ESCAPEDJOIN> | "("
{code}
> teiid rename table in salesforce
> --------------------------------
>
> Key: TEIID-5851
> URL: https://issues.jboss.org/browse/TEIID-5851
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> In example project connected to SF i have a table named "User" in SF but "User_" in teiid metadata.
> And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
> GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be "User_" named because we have same name in teiid metadata system names?
> So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId" do not working.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months
[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ]
Renat Eskenin edited comment on TEIID-5851 at 11/18/19 8:41 AM:
----------------------------------------------------------------
Yes, name of table is User, but request do not working, its so strange.
I call "Select Name From Tables" and get "User" name of table User in sf. But request do not working.
And simple check do not working with this name
{code:sql}
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "SELECT Id FROM [*]User[*] LIMIT 1" at line 1, column 16.
Was expecting: "table" | "lateral" | "xmltable" | id | <ESCAPEDJOIN> | "("
{code}
was (Author: i3draven):
Yes, name of table is User, but request do not working, its so strange.
I call "Select Name From Tables" and get "User" name of table User in sf. But request do not working.
> teiid rename table in salesforce
> --------------------------------
>
> Key: TEIID-5851
> URL: https://issues.jboss.org/browse/TEIID-5851
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> In example project connected to SF i have a table named "User" in SF but "User_" in teiid metadata.
> And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
> GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be "User_" named because we have same name in teiid metadata system names?
> So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId" do not working.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months
[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ]
Renat Eskenin edited comment on TEIID-5851 at 11/18/19 8:38 AM:
----------------------------------------------------------------
Yes, name of table is User, but request do not working, its so strange.
I call "Select Name From Tables" and get "User" name of table User in sf. But rewuest do not working.
was (Author: i3draven):
Yes, name of table is User, but request do not working, its so strange.
> teiid rename table in salesforce
> --------------------------------
>
> Key: TEIID-5851
> URL: https://issues.jboss.org/browse/TEIID-5851
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> In example project connected to SF i have a table named "User" in SF but "User_" in teiid metadata.
> And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
> GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be "User_" named because we have same name in teiid metadata system names?
> So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId" do not working.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months
[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ]
Renat Eskenin edited comment on TEIID-5851 at 11/18/19 8:38 AM:
----------------------------------------------------------------
Yes, name of table is User, but request do not working, its so strange.
I call "Select Name From Tables" and get "User" name of table User in sf. But request do not working.
was (Author: i3draven):
Yes, name of table is User, but request do not working, its so strange.
I call "Select Name From Tables" and get "User" name of table User in sf. But rewuest do not working.
> teiid rename table in salesforce
> --------------------------------
>
> Key: TEIID-5851
> URL: https://issues.jboss.org/browse/TEIID-5851
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> In example project connected to SF i have a table named "User" in SF but "User_" in teiid metadata.
> And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
> GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be "User_" named because we have same name in teiid metadata system names?
> So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId" do not working.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months
[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ]
Renat Eskenin commented on TEIID-5851:
--------------------------------------
Yes, name of table is User, but request do not working, its so strange.
> teiid rename table in salesforce
> --------------------------------
>
> Key: TEIID-5851
> URL: https://issues.jboss.org/browse/TEIID-5851
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> In example project connected to SF i have a table named "User" in SF but "User_" in teiid metadata.
> And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
> GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be "User_" named because we have same name in teiid metadata system names?
> So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId" do not working.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months
[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ]
Renat Eskenin commented on TEIID-5851:
--------------------------------------
stop i will check, sorry
> teiid rename table in salesforce
> --------------------------------
>
> Key: TEIID-5851
> URL: https://issues.jboss.org/browse/TEIID-5851
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> In example project connected to SF i have a table named "User" in SF but "User_" in teiid metadata.
> And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
> GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be "User_" named because we have same name in teiid metadata system names?
> So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId" do not working.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months
[JBoss JIRA] (TEIID-5851) teiid rename table in salesforce
by Renat Eskenin (Jira)
[ https://issues.jboss.org/browse/TEIID-5851?page=com.atlassian.jira.plugin... ]
Renat Eskenin commented on TEIID-5851:
--------------------------------------
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce');
CREATE SCHEMA sf SERVER salesforce;
IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false');
{code}
Do not working
Request
{code:sql}
SELECT Task.Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId WHERE User.FirstName LIKE 'B%' LIMIT 1
{code}
Error
{code:java}
org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "LEFT OUTER JOIN [*]User[*] ON User.Id" at line 1, column 73.
Was expecting: "table" | "lateral" | "xmltable" | id | <ESCAPEDJOIN> | "("
{code}
> teiid rename table in salesforce
> --------------------------------
>
> Key: TEIID-5851
> URL: https://issues.jboss.org/browse/TEIID-5851
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Renat Eskenin
> Assignee: Steven Hawkins
> Priority: Major
>
> In example project connected to SF i have a table named "User" in SF but "User_" in teiid metadata.
> And another strange behavior is: system tables from teiid as GEOGRAPHY_COLUMNS
> GEOMETRY_COLUMNS placed in teiid server to same schema as Salesforce tables. May be "User_" named because we have same name in teiid metadata system names?
> So, select "SELECT Id, User.FirstName, User.LastName FROM Task LEFT OUTER JOIN User ON User.Id=Task.OwnerId" do not working.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
6 years, 4 months