[JBoss JIRA] (TEIID-4396) Missing images in the Admin section of the documentation
by Patrick McElreavy (JIRA)
Patrick McElreavy created TEIID-4396:
----------------------------------------
Summary: Missing images in the Admin section of the documentation
Key: TEIID-4396
URL: https://issues.jboss.org/browse/TEIID-4396
Project: Teiid
Issue Type: Bug
Components: Documentation
Affects Versions: 9.0.2
Reporter: Patrick McElreavy
Assignee: Steven Hawkins
Priority: Minor
Section "Profile View" links to image "images/author/download/attachments/18646076/webconsole2.png"
Section "Runtime View" links to image "images/author/download/attachments/18646076/webconsole1.png"
Both these images are missing.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIID-4395) Oracle translator should pushdown clob conversion
by Tom Arnold (JIRA)
Tom Arnold created TEIID-4395:
---------------------------------
Summary: Oracle translator should pushdown clob conversion
Key: TEIID-4395
URL: https://issues.jboss.org/browse/TEIID-4395
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 9.0.2
Reporter: Tom Arnold
Assignee: Steven Hawkins
We have an "attributes" table defined like this
{code:sql}
CREATE TABLE "ATTRS"
(
NAME varchar2(50) NOT NULL,
ATTR_NAME varchar2(50) NOT NULL,
ATTR_VALUE clob,
CONSTRAINT ATTRS_PK PRIMARY KEY (NAME,ATTR_NAME)
);
{code}
The value column is unfortunately defined as a clob, but most of the data is small enough to fit in varchar (4000 chars). We have a somewhat complex query that ends up grouping by the clob value and with Teiid it is causing N-many queries.
Simplified to this
{code:sql}
select cast(attr_value as varchar) from attrs
{code}
{code}
ProjectNode
+ Relational Node ID:0
+ Output Columns:expr1 (string)
+ Statistics:
0: Node Output Rows: 293
1: Node Next Batch Process Time: 5
2: Node Cumulative Next Batch Process Time: 5
3: Node Cumulative Process Time: 11
4: Node Next Batch Calls: 2
5: Node Blocks: 1
+ Cost Estimates:Estimated Node Cardinality: 293.0
+ Child 0:
AccessNode
+ Relational Node ID:1
+ Output Columns:ATTR_VALUE (clob)
+ Statistics:
0: Node Output Rows: 293
1: Node Next Batch Process Time: 0
2: Node Cumulative Next Batch Process Time: 0
3: Node Cumulative Process Time: 6
4: Node Next Batch Calls: 2
5: Node Blocks: 1
+ Cost Estimates:Estimated Node Cardinality: 293.0
+ Query:SELECT g_0.ATTR_VALUE FROM foo.ATTRS AS g_0
+ Model Name:foo
+ Select Columns:convert(foo.ATTRS.ATTR_VALUE, varchar)
+ Data Bytes Sent:6783
+ Planning Time:2
{code}
Ideally on Oracle it would just get pushed down like this
{code:sql}
SELECT TO_CHAR(g_0.ATTR_VALUE) FROM foo.ATTRS AS g_0
{code}
>From looking in the Oracle translator it looks like it should do this already... I added a test case which passes, but the plan seems to disagree.
{code:java}
@Test public void testClobToString() throws Exception {
Column column = new Column();
column.setNativeType("CLOB");
column.setNameInSource("dt");
helpTest(LANG_FACTORY.createColumnReference("dt", LANG_FACTORY.createNamedTable("x", null, null), column, Clob.class), "varchar", "to_char(x.dt)"); //$NON-NLS-1$ //$NON-NLS-2$
}
{code}
As a workaround I added a CLOB_TO_CHAR foreign function in the model DDL (using teiid_rel:native-query 'TO_CHAR($1)') and changed my query to use that instead of cast, but I'd prefer to not have to do that in the long term.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIID-4393) Add new Geospatial functions
by Van Halbert (JIRA)
Van Halbert created TEIID-4393:
----------------------------------
Summary: Add new Geospatial functions
Key: TEIID-4393
URL: https://issues.jboss.org/browse/TEIID-4393
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 8.12.x, 9.x
Reporter: Van Halbert
Assignee: Steven Hawkins
Adding a list of geospatial features to be added. Used the following specification: https://portal.opengeospatial.org/files/?artifact_id=829
st_Dimension
st_GeometryType
st_IsEmpty
st_IsSimple
st_Boundary
st_Envelope
st_X
st_Y
st_StartPoint
st_EndPoint
st_Boundary
st_Boundary
st_Length
st_NumPoints
st_PointN
st_Centroid
st_PointOnSurface
st_Area
st_ExteriorRing
st_NumInteriorRings
st_InteriorRingN
st_NumGeometries
st_GeometryN
st_IsClosed
st_Length
st_Centroid
st_PointOnSurface
st_Area
st_Within
st_Relate
st_Intersection
st_Difference
st_Union
st_SymmetricDifference
st_Buffer
st_ConvexHull
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIID-4238) Remove need for quotes around cursor name declarations/fetches
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ]
Johnathon Lee closed TEIID-4238.
--------------------------------
Resolution: Done
> Remove need for quotes around cursor name declarations/fetches
> --------------------------------------------------------------
>
> Key: TEIID-4238
> URL: https://issues.jboss.org/browse/TEIID-4238
> Project: Teiid
> Issue Type: Enhancement
> Components: ODBC
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
> Fix For: 9.1, 8.7.8.6_2
>
>
> Attempting to declare a cursor without quotes results in an error similar to[1]. The quotes should be optional except in special cases, as this seems to match later standards (SQL2003). Performing fetch operations against the cursor have the same issue, where if the cursorname is not quoted, parsing errors occur.
> [1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]DECLARE[*] cursorname CURSOR" at line 1, column 1.
> Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months