[JBoss JIRA] (TEIID-3062) Apply LIMIT 1 optimization for DISTINCT in UNION situations
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3062?page=com.atlassian.jira.plugin... ]
Steven Hawkins reopened TEIID-3062:
-----------------------------------
> Apply LIMIT 1 optimization for DISTINCT in UNION situations
> -----------------------------------------------------------
>
> Key: TEIID-3062
> URL: https://issues.jboss.org/browse/TEIID-3062
> Project: Teiid
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: Query Engine
> Affects Versions: 8.1
> Reporter: Mark Addleman
> Assignee: Steven Hawkins
>
> The translator does not support select expressions. Query:
> SELECT DISTINCT DATAMART_NAME AS c_9, '_constant_' AS c_10 FROM (SELECT datamart_name FROM
> (
> SELECT 'DATACOM Datamart' AS DATAMART_NAME FROM SECURITY_DM_DATACOM_DEV_R140_CA31_CMGRD1.VIEWOBJACCESS
> UNION ALL
> SELECT 'DB2 D91A Datamart' AS DATAMART_NAME FROM SECURITY_DM_DB2_D91APTIB_CMGRD1.VIEWOBJACCESS
> ) AS t
> ) a
> Final part of plan:
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> SortNode(0) output=[datamart_name AS c_9, '_constant_' AS c_10] [DUP_REMOVE]
> ProjectNode(1) output=[datamart_name AS c_9, '_constant_' AS c_10] [datamart_name AS c_9, '_constant_' AS c_10]
> UnionAllNode(2) output=[datamart_name]
> AccessNode(3) output=['DATACOM Datamart' AS DATAMART_NAME] SELECT 'DATACOM Datamart' FROM SECURITY_DM_DATACOM_DEV_R140_CA31_CMGRD1.VIEWOBJACCESS AS g_0
> AccessNode(4) output=['DB2 D91A Datamart' AS DATAMART_NAME] SELECT 'DB2 D91A Datamart' FROM SECURITY_DM_DB2_D91APTIB_CMGRD1.VIEWOBJACCESS AS g_0
> Expected LIMIT 1 in the access nodes. Comment from Steven: "More than likely we are not checking across a union for this optimization."
> See https://community.jboss.org/message/883460 for more details and complete plan
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3064) Sybase metadata loading fails
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3064?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3064:
---------------------------------------
You'd have to understand the intent of the exception for a warning to make sense. Otherwise I'd expect you'd have to enable an option such as ignoreForeignKeyErrors. Typically the user will specify a target schema for the import, so this is already not the common case.
> Sybase metadata loading fails
> -----------------------------
>
> Key: TEIID-3064
> URL: https://issues.jboss.org/browse/TEIID-3064
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log
>
>
> Sybase metadata loading fails[1] when deploying dynamic vdb.
> The problem is in JDBCMetdataProcessor.getForeignKeys. Method loads FKs from all tables, but it fails when it tries to load FKs from table sysquerymetrics. The problem seems to be that sysquerymetrics is not a system table, it is a view.
> [1] Reason:TEIID11010 com.sybase.jdbc4.jdbc.SybSQLException: No such object or user exists in the database.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3064) Sybase metadata loading fails
by Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3064?page=com.atlassian.jira.plugin... ]
Filip Elias commented on TEIID-3064:
------------------------------------
Wouldn't it be better to print some warning rather than cancel whole metadata loading?
> Sybase metadata loading fails
> -----------------------------
>
> Key: TEIID-3064
> URL: https://issues.jboss.org/browse/TEIID-3064
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log
>
>
> Sybase metadata loading fails[1] when deploying dynamic vdb.
> The problem is in JDBCMetdataProcessor.getForeignKeys. Method loads FKs from all tables, but it fails when it tries to load FKs from table sysquerymetrics. The problem seems to be that sysquerymetrics is not a system table, it is a view.
> [1] Reason:TEIID11010 com.sybase.jdbc4.jdbc.SybSQLException: No such object or user exists in the database.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3064) Sybase metadata loading fails
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3064?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3064:
---------------------------------------
The resolution I was thinking of was for Access. In that case getForeignKeys is a completely unsupported operation by the bridge/underlying logic, so we made the default for import to not import foreign keys and exclude problematic system tables. Here it seems simple enough just to add a documentation note to specify the target schema that you want, otherwise there can be issues with system metadata.
> Sybase metadata loading fails
> -----------------------------
>
> Key: TEIID-3064
> URL: https://issues.jboss.org/browse/TEIID-3064
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log
>
>
> Sybase metadata loading fails[1] when deploying dynamic vdb.
> The problem is in JDBCMetdataProcessor.getForeignKeys. Method loads FKs from all tables, but it fails when it tries to load FKs from table sysquerymetrics. The problem seems to be that sysquerymetrics is not a system table, it is a view.
> [1] Reason:TEIID11010 com.sybase.jdbc4.jdbc.SybSQLException: No such object or user exists in the database.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3064) Sybase metadata loading fails
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3064?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3064:
------------------------------------
So this jira should be rejected? With the recommendation to use the jdbc importer properties to control the imported metadata.
> Sybase metadata loading fails
> -----------------------------
>
> Key: TEIID-3064
> URL: https://issues.jboss.org/browse/TEIID-3064
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log
>
>
> Sybase metadata loading fails[1] when deploying dynamic vdb.
> The problem is in JDBCMetdataProcessor.getForeignKeys. Method loads FKs from all tables, but it fails when it tries to load FKs from table sysquerymetrics. The problem seems to be that sysquerymetrics is not a system table, it is a view.
> [1] Reason:TEIID11010 com.sybase.jdbc4.jdbc.SybSQLException: No such object or user exists in the database.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3064) Sybase metadata loading fails
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3064?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3064:
---------------------------------------
I believe we encountered something similar last testing cycle. The conclusion was that one of the standard mechanisms to limit what is imported, such as a schemaPattern or a regex to exclude tables.
> Sybase metadata loading fails
> -----------------------------
>
> Key: TEIID-3064
> URL: https://issues.jboss.org/browse/TEIID-3064
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log
>
>
> Sybase metadata loading fails[1] when deploying dynamic vdb.
> The problem is in JDBCMetdataProcessor.getForeignKeys. Method loads FKs from all tables, but it fails when it tries to load FKs from table sysquerymetrics. The problem seems to be that sysquerymetrics is not a system table, it is a view.
> [1] Reason:TEIID11010 com.sybase.jdbc4.jdbc.SybSQLException: No such object or user exists in the database.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3064) Sybase metadata loading fails
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3064?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-3064:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1126812
> Sybase metadata loading fails
> -----------------------------
>
> Key: TEIID-3064
> URL: https://issues.jboss.org/browse/TEIID-3064
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log
>
>
> Sybase metadata loading fails[1] when deploying dynamic vdb.
> The problem is in JDBCMetdataProcessor.getForeignKeys. Method loads FKs from all tables, but it fails when it tries to load FKs from table sysquerymetrics. The problem seems to be that sysquerymetrics is not a system table, it is a view.
> [1] Reason:TEIID11010 com.sybase.jdbc4.jdbc.SybSQLException: No such object or user exists in the database.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months
[JBoss JIRA] (TEIID-3064) Sybase metadata loading fails
by Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3064?page=com.atlassian.jira.plugin... ]
Filip Elias updated TEIID-3064:
-------------------------------
Attachment: server.log
Server log with the exception
> Sybase metadata loading fails
> -----------------------------
>
> Key: TEIID-3064
> URL: https://issues.jboss.org/browse/TEIID-3064
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log
>
>
> Sybase metadata loading fails[1] when deploying dynamic vdb.
> The problem is in JDBCMetdataProcessor.getForeignKeys. Method loads FKs from all tables, but it fails when it tries to load FKs from table sysquerymetrics. The problem seems to be that sysquerymetrics is not a system table, it is a view.
> [1] Reason:TEIID11010 com.sybase.jdbc4.jdbc.SybSQLException: No such object or user exists in the database.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years, 5 months