August 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3064) Sybase metadata loading fails

by Filip Elias (JIRA)

Filip Elias created TEIID-3064: ---------------------------------- Summary: 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 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

1
0
0 / 0

[JBoss JIRA] (TEIID-3063) Push down DISTINCT with select expression in the query and the datasource doesn't support select expressions

by Sanjeev Gour (JIRA)

Sanjeev Gour created TEIID-3063: ----------------------------------- Summary: Push down DISTINCT with select expression in the query and the datasource doesn't support select expressions Key: TEIID-3063 URL: https://issues.jboss.org/browse/TEIID-3063 Project: Teiid Issue Type: Enhancement Security Level: Public (Everyone can see) Components: Common Affects Versions: 8.7 Environment: Windows Reporter: Sanjeev Gour Assignee: Steven Hawkins Teiid doesn't push down DISTINCT when a select expression is used and the underlying data source doesn't support select expressions. The data source supports DISTINCT. Related discussion thread: https://community.jboss.org/thread/243376 -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[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 resolved TEIID-3062. ----------------------------------- Resolution: Out of Date With the rework of the logic related to view partitioning, we'll actually add the expected limit in later versions. I believe this should work as expected in 8.4+ (verified against mater). > 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

1
0
0 / 0

[JBoss JIRA] (TEIID-3058) Cassandra: cannot compare timestamp field in where clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3058?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3058. ----------------------------------- Labels: (was: Teiid) Fix Version/s: 8.7.1 Resolution: Done Updated the literal handling to match cql expectations. Also logged TEIID-3060 to add more cassandra type support. > Cassandra: cannot compare timestamp field in where clause > ---------------------------------------------------------- > > Key: TEIID-3058 > URL: https://issues.jboss.org/browse/TEIID-3058 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: Cassandra with Teiid 8.7 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > It seems like Teiid is having problem to compare translate CQL if there is timestamp comparison in where clause: > ORIGINAL SQL: > select "cassandrads_sales"."product_family" as "cassandrads_sales_product_family", > "cassandrads_sales"."product_family" as "cassandrads_sales_product_family1" > from "cassandrads"."sales" "cassandrads_sales" > where "cassandrads_sales"."the_date" <= '2013-05-01 00:00:00' > limit 1000 > TRANSLATED CQL: > SELECT cassandrads.sales.product_family FROM cassandrads.sales WHERE cassandrads.sales.the_date <= {ts'2013-05-01 00:00:00.0'} LIMIT 1000 > And I got this error: > Caused by: org.teiid.translator.TranslatorException: line 1:55 no viable alternative at input '2013-05-01 00:00:0 > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:80) > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:72) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:135) > If it is not possible to do time/ data comparison for CQL, maybe you guys should consider to do it in memory instead. Thanks. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3062) Apply LIMIT 1 optimization for DISTINCT in UNION situations

by Mark Addleman (JIRA)

Mark Addleman created TEIID-3062: ------------------------------------ Summary: 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

1
0
0 / 0

[JBoss JIRA] (TEIID-3061) MongoDB: Support VARBINARY type

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-3061: ----------------------------------- Summary: MongoDB: Support VARBINARY type Key: TEIID-3061 URL: https://issues.jboss.org/browse/TEIID-3061 Project: Teiid Issue Type: Enhancement Security Level: Public (Everyone can see) Components: Misc. Connectors Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.9 Map BinData structure of MongoDB to Teiid's VarBinary type, and MAP VARBINARY to byte[]. Correct the import time byte[] to VARBINARY instead of blob. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3060) Additional cassandra type handling

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3060: ------------------------------------- Summary: Additional cassandra type handling Key: TEIID-3060 URL: https://issues.jboss.org/browse/TEIID-3060 Project: Teiid Issue Type: Enhancement Security Level: Public (Everyone can see) Components: Misc. Connectors Affects Versions: 8.9 Reporter: Steven Hawkins We should have support for cassandra blobs/custom as varbinary (converting from bytebuffer to byte[]), list (as an array type), and better uuid handling for uuid/timeuuid support. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3038) Add spatial query support to the Teiid MongoDB translator

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3038?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3038. --------------------------------- Fix Version/s: 8.7.1 Resolution: Done Implemented the feature as defined in the comments section > Add spatial query support to the Teiid MongoDB translator > --------------------------------------------------------- > > Key: TEIID-3038 > URL: https://issues.jboss.org/browse/TEIID-3038 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.8 > Reporter: Michael Farwell > Assignee: Ramesh Reddy > Fix For: 8.7.1, 8.9 > > > We'd like to be able to issue geoIntersects and geoWithin queries through the MongoDB translator. See comment below on a proposed approach. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3059) Support consuming SOAP based service that is secured by Kerberos authentication

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-3059: ----------------------------------- Summary: Support consuming SOAP based service that is secured by Kerberos authentication Key: TEIID-3059 URL: https://issues.jboss.org/browse/TEIID-3059 Project: Teiid Issue Type: Feature Request Security Level: Public (Everyone can see) Components: Misc. Connectors Reporter: Ramesh Reddy Assignee: Ramesh Reddy CXF supports Kerberos based authentication in issuing a SOAP based web service call. This needs to be verified authentication scenario and further enhance code to support delegation of kerberos token. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3042) expose dependency information in system tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3042: --------------------------------------- The initial commit is in. The usage table exposes all of the tables/views/procedures/columns that make up a given table/procedure. Before fully documenting this I want to look at whether it would make more sense to separate out column usage. > expose dependency information in system tables > ---------------------------------------------- > > Key: TEIID-3042 > URL: https://issues.jboss.org/browse/TEIID-3042 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > We should expose additional view/procedure and even column information in terms of their dependencies. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2014