October 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3560) support common table expression with insert/update/delete

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-3560?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3560: ---------------------------------- Fix Version/s: 11.x (was: 11.2) Moving back out of 11.2 as this also brings up needing to support updates through the CTE. > support common table expression with insert/update/delete > --------------------------------------------------------- > > Key: TEIID-3560 > URL: https://issues.jboss.org/browse/TEIID-3560 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Priority: Major > Fix For: 11.x > > > We currently have limited our cte support to just query expressions. This should be generalized to more statement types. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5504) Update pg layer for general fdw use

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5504: ------------------------------------- Summary: Update pg layer for general fdw use Key: TEIID-5504 URL: https://issues.jboss.org/browse/TEIID-5504 Project: Teiid Issue Type: Enhancement Components: ODBC Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 11.x Building on TEIID-5498 we should allow general use of fdw access. This is much broader in determining what function and type support is expected. At the very least type casting needs to be aware of the pg type names as a literal like 'a' will be pushed as 'a'::text. At this time since joins and other higher level constructs are not pushed that still keeps the scope somewhat narrow. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5503: --------------------------------------- My understanding of this request is that it's looking to utilize the odbc driver through power bi's customization layer - which is what the link talks to. I'm asking what doesn't work about simply using power bi's existing connectivity to postgresql? Does it generate queries we don't understand, rely on unsupported driver functionality etc.? > Create or change ODBC driver to be compatible with Microsoft Power BI > --------------------------------------------------------------------- > > Key: TEIID-5503 > URL: https://issues.jboss.org/browse/TEIID-5503 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > > Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5393) Build time validation when the metadata is fully specified.

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5393?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-5393: ------------------------------------- Fix Version/s: 12.x (was: 11.2) Assignee: (was: Steven Hawkins) > Build time validation when the metadata is fully specified. > ----------------------------------------------------------- > > Key: TEIID-5393 > URL: https://issues.jboss.org/browse/TEIID-5393 > Project: Teiid > Issue Type: Sub-task > Components: Build/Kits > Reporter: Steven Hawkins > Priority: Major > Fix For: 12.x > > > To tighten the development loop for creating thorntail deployments there should be a build time validation of a vdb - either just parsing, or effectively a local loading when the metadata if fully specified. That will catch any issues before generating / running the image. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5391) Thorntail and s2i builds

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5391?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5391. ----------------------------------- Resolution: Done Marking the parent issue as resolved. Build time validation is something that we can defer for now. > Thorntail and s2i builds > ------------------------ > > Key: TEIID-5391 > URL: https://issues.jboss.org/browse/TEIID-5391 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits, Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 11.2 > > > This will serve as the parent issue for building with thorntail and creating openshift images. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Debbie Steigner (Jira)

[ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin... ] Debbie Steigner commented on TEIID-5503: ---------------------------------------- [~shawkins] ODBC support essentially works but it is missing the Direct Query feature, which is the link in the description. > Create or change ODBC driver to be compatible with Microsoft Power BI > --------------------------------------------------------------------- > > Key: TEIID-5503 > URL: https://issues.jboss.org/browse/TEIID-5503 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > > Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4261) Hive: Add support for array type

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4261?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4261: --------------------------------------- >From https://github.com/apache/hive/blob/90e12280ca06b3df0099a858f58a542f190cf... Array, Map, Struct, just return their json representation and getArray is not supported. > Hive: Add support for array type > -------------------------------- > > Key: TEIID-4261 > URL: https://issues.jboss.org/browse/TEIID-4261 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors > Reporter: Ramesh Reddy > Priority: Major > Fix For: 11.x > > > Hive 0.14 added support for Array and Map types. Supporting array types to translator will be good. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5503?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5503: --------------------------------------- Before going the route of custom connectivity, you'd first want to determine what wasn't working about using pg odbc - is that captured anywhere? > Create or change ODBC driver to be compatible with Microsoft Power BI > --------------------------------------------------------------------- > > Key: TEIID-5503 > URL: https://issues.jboss.org/browse/TEIID-5503 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Priority: Major > > Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5502) Add better JDBC array support

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5502?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5502. ----------------------------------- Resolution: Done Added logic to determine the array component type using the driver type info. > Add better JDBC array support > ----------------------------- > > Key: TEIID-5502 > URL: https://issues.jboss.org/browse/TEIID-5502 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 11.2 > > > JDBC import and value retrieval will use the object type and getObject respectively with an array type. It should use the most specific type possible and typically getArray. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5503) Create or change ODBC driver to be compatible with Microsoft Power BI

by Debbie Steigner (Jira)

Debbie Steigner created TEIID-5503: -------------------------------------- Summary: Create or change ODBC driver to be compatible with Microsoft Power BI Key: TEIID-5503 URL: https://issues.jboss.org/browse/TEIID-5503 Project: Teiid Issue Type: Feature Request Components: ODBC Reporter: Debbie Steigner Assignee: Steven Hawkins Customer request to customise the ODBC driver, adding extra feature as reported here: https://docs.microsoft.com/en-us/power-query/odbc -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2018