November 2019 - teiid-issues - Jboss List Archives

[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)

5 years, 1 month

1
0
0 / 0

[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)

5 years, 1 month

1
0
0 / 0

[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)

5 years, 1 month

1
0
0 / 0

[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)

5 years, 1 month

1
0
0 / 0

[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)

5 years, 1 month

1
0
0 / 0

[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)

5 years, 1 month

1
0
0 / 0

[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)

5 years, 1 month

1
0
0 / 0

[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)

5 years, 1 month

1
0
0 / 0

[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)

5 years, 1 month

1
0
0 / 0

[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: --------------------------------------- Copy and paste error. Corrected in the comment above to use the importer. prefix. > 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)

5 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2019