May 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4888) Support for SetQueryLimit

by German Tejero (JIRA)

German Tejero created TEIID-4888: ------------------------------------ Summary: Support for SetQueryLimit Key: TEIID-4888 URL: https://issues.jboss.org/browse/TEIID-4888 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Reporter: German Tejero Assignee: Steven Hawkins Priority: Minor OpenEdge RDBMS not support fetch/offset in a set query. For example, the generated SQL: SELECT g_1.ejer AS c_0 FROM PUB.modpre AS g_1 UNION ALL SELECT g_0.ejer AS c_0 FROM PUB.modesp AS g_0 FETCH NEXT 100 ROWS ONLY For the view: CREATE VIEW Modificaciones( ejercicio INTEGER )AS SELECT T.ejercicio FROM( SELECT M.ejercicio, FROM sipbas.modesp AS M UNION ALL SELECT M.ejercicio FROM sipbas.modpre AS M) AS T; It is necessary to be able to indicate SetQueryLimit in the same way as with SetQueryOrderBy. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4887) Domain mode configuration fails with CNF

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4887?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4887. --------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) Resolution: Done Added the missing JGroups dependency to the Teiid module {code} <module name="org.wildfly.clustering.jgroups.spi"/> {code} > Domain mode configuration fails with CNF > ---------------------------------------- > > Key: TEIID-4887 > URL: https://issues.jboss.org/browse/TEIID-4887 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 9.1 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 9.3, 9.2.3 > > > domain script fails to run to the finish with a exception > {code} > [Server:server-one] 12:15:52,763 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 62) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]): java.lang.NoClassDefFoundError: org/wildfly/clustering/jgroups/spi/service/ProtocolStackServiceName > [Server:server-one] at org.teiid.jboss.TeiidAdd.initilaizeTeiidEngine(TeiidAdd.java:314) > [Server:server-one] at org.teiid.jboss.TeiidAdd.performRuntime(TeiidAdd.java:215) > [Server:server-one] at org.jboss.as.controller.AbstractAddStepHandler.performRuntime(AbstractAddStepHandler.java:337) > [Server:server-one] at org.jboss.as.controller.AbstractAddStepHandler$1.execute(AbstractAddStepHandler.java:151) > [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:890) > [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:659) > [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:370) > [Server:server-one] at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1344) > [Server:server-one] at org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:39 > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4887) Domain mode configuration fails with CNF

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-4887: ----------------------------------- Summary: Domain mode configuration fails with CNF Key: TEIID-4887 URL: https://issues.jboss.org/browse/TEIID-4887 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 9.1 Reporter: Ramesh Reddy Assignee: Steven Hawkins Priority: Critical Fix For: 9.3, 9.2.3 domain script fails to run to the finish with a exception {code} [Server:server-one] 12:15:52,763 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 62) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]): java.lang.NoClassDefFoundError: org/wildfly/clustering/jgroups/spi/service/ProtocolStackServiceName [Server:server-one] at org.teiid.jboss.TeiidAdd.initilaizeTeiidEngine(TeiidAdd.java:314) [Server:server-one] at org.teiid.jboss.TeiidAdd.performRuntime(TeiidAdd.java:215) [Server:server-one] at org.jboss.as.controller.AbstractAddStepHandler.performRuntime(AbstractAddStepHandler.java:337) [Server:server-one] at org.jboss.as.controller.AbstractAddStepHandler$1.execute(AbstractAddStepHandler.java:151) [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:890) [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:659) [Server:server-one] at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:370) [Server:server-one] at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1344) [Server:server-one] at org.jboss.as.controller.ModelControllerImpl.internalExecute(ModelControllerImpl.java:39 {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4886) Allow join grouping to optimize across left outer joins

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4886: ------------------------------------- Summary: Allow join grouping to optimize across left outer joins Key: TEIID-4886 URL: https://issues.jboss.org/browse/TEIID-4886 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.3 In a from clause such as: (a.t1 inner join b.t1 ... inner join a.t2 ...) left outer join b.t2 ... It is possible to group the b.t1 and b.t2 together, but generally won't be found by the grouping and then ordering logic. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4885) Costing issues

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4885: ------------------------------------- Summary: Costing issues Key: TEIID-4885 URL: https://issues.jboss.org/browse/TEIID-4885 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.3 There were several deficiencies introduced with TEIID-4332 - In some circumstances very low ndv values on the large side of a join would cause a dependent join in an unexpected direction. The row estimate derived for a join without ndv information would tend to be too low, which would have a cumulative effect through further joins. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4884) Google spreadsheet throws Error when getting batch 401:Unauthorized

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4884?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4884: --------------------------------------- Can you provide more details on the issue? Does it appear you are hitting a throttling feature of google? Have you tried to constrain the query rate for example by limiting the number of source connections? > Google spreadsheet throws Error when getting batch 401:Unauthorized > ------------------------------------------------------------------- > > Key: TEIID-4884 > URL: https://issues.jboss.org/browse/TEIID-4884 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: gs-http401 > > > It seems that after executing a larger load of queries following error occurs: "Error when getting batch 401:Unauthorized". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4884) Google spreadsheet throws Error when getting batch 401:Unauthorized

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4884: -------------------------------------- Summary: Google spreadsheet throws Error when getting batch 401:Unauthorized Key: TEIID-4884 URL: https://issues.jboss.org/browse/TEIID-4884 Project: Teiid Issue Type: Bug Affects Versions: 9.3 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Attachments: gs-http401 It seems that after executing a larger load of queries following error occurs: "Error when getting batch 401:Unauthorized". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4883) Teiid Excel Translator should filter blank cells from header row

by David Vilaverde (JIRA)

[ https://issues.jboss.org/browse/TEIID-4883?page=com.atlassian.jira.plugin... ] David Vilaverde commented on TEIID-4883: ---------------------------------------- [~rareddy] Ok I've updated the PR now to reflect the changes you suggested. I've also added some tests to cover the new cases. > Teiid Excel Translator should filter blank cells from header row > ---------------------------------------------------------------- > > Key: TEIID-4883 > URL: https://issues.jboss.org/browse/TEIID-4883 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: David Vilaverde > Assignee: Steven Hawkins > Priority: Minor > Fix For: Open To Community > > Attachments: fr-demo1-sample-data.xls > > > The teiid translator for excel will throw a duplicate column name exception when using a spreadsheet that has 2 or more columns where the header row doesn't specify a header name. In the attached spreadsheet it's difficult to see that rows E-H should be deleted from the dataset. > The proposed enhancement is to allow the translator for excel to exclude any trailing columns where there is no column name defined. > I took a shot at making this enhancement and created a PR at https://github.com/teiid/teiid/pull/951 > If this PR is not going to be accepted, can the methods in the ExcelMetadataProcessor me changed from private to protected so that the processor can be extended easily? -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4883) Teiid Excel Translator should filter blank cells from header row

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4883?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4883: ------------------------------------- Yes, instead of {{getAllowEmptyCells}}, I propose we say {{getIgnoreEmptyCells}} when {{true}}, all the 3 columns are returned ignoring/skipping the empty space, and if {{false}} only first 2 columns are returned. > Teiid Excel Translator should filter blank cells from header row > ---------------------------------------------------------------- > > Key: TEIID-4883 > URL: https://issues.jboss.org/browse/TEIID-4883 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: David Vilaverde > Assignee: Steven Hawkins > Priority: Minor > Fix For: Open To Community > > Attachments: fr-demo1-sample-data.xls > > > The teiid translator for excel will throw a duplicate column name exception when using a spreadsheet that has 2 or more columns where the header row doesn't specify a header name. In the attached spreadsheet it's difficult to see that rows E-H should be deleted from the dataset. > The proposed enhancement is to allow the translator for excel to exclude any trailing columns where there is no column name defined. > I took a shot at making this enhancement and created a PR at https://github.com/teiid/teiid/pull/951 > If this PR is not going to be accepted, can the methods in the ExcelMetadataProcessor me changed from private to protected so that the processor can be extended easily? -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4883) Teiid Excel Translator should filter blank cells from header row

by David Vilaverde (JIRA)

[ https://issues.jboss.org/browse/TEIID-4883?page=com.atlassian.jira.plugin... ] David Vilaverde commented on TEIID-4883: ---------------------------------------- [~rareddy]So the PR i submitted with the allowEmptyCells property will treat the col 3 in the sample table in your previous comment as the end of table, so the end result is: ||heading 1||heading 2|| |col A1|col A2| |col B1|col B2| What do you mean by submit the patch again? Do you want me to alter the implementation somehow? Or do you want me to just get rid of the allowEmptyCells property? > Teiid Excel Translator should filter blank cells from header row > ---------------------------------------------------------------- > > Key: TEIID-4883 > URL: https://issues.jboss.org/browse/TEIID-4883 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: David Vilaverde > Assignee: Steven Hawkins > Priority: Minor > Fix For: Open To Community > > Attachments: fr-demo1-sample-data.xls > > > The teiid translator for excel will throw a duplicate column name exception when using a spreadsheet that has 2 or more columns where the header row doesn't specify a header name. In the attached spreadsheet it's difficult to see that rows E-H should be deleted from the dataset. > The proposed enhancement is to allow the translator for excel to exclude any trailing columns where there is no column name defined. > I took a shot at making this enhancement and created a PR at https://github.com/teiid/teiid/pull/951 > If this PR is not going to be accepted, can the methods in the ExcelMetadataProcessor me changed from private to protected so that the processor can be extended easily? -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2017