July 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4977: -------------------------------- Attachment: jdg-mat-cache-vdb.xml > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Attachments: jdg-mat-cache-vdb.xml > > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4977: ------------------------------------- One modification {code} SWAP MV ST {code} command changed to {code} rename ST MV {code} make sure the staging table is first, as after rename the old contents are purged. I updated vdb.xml files attached > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4977: -------------------------------- Attachment: (was: jdg-mat-cache-vdb.xml) > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4977: -------------------------------- Attachment: (was: ispn-vdb.xml) > Support materialization as the 8.12.x version did > ------------------------------------------------- > > Key: TEIID-4977 > URL: https://issues.jboss.org/browse/TEIID-4977 > Project: Teiid > Issue Type: Feature Request > Components: Infinispan > Affects Versions: 8.12.x-6.4 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > > Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4467) Google translator throws exception invalid_query for GROUP BY

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4467?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4467: ---------------------------------- Fix Version/s: 10.x (was: 9.3.1) > Google translator throws exception invalid_query for GROUP BY > -------------------------------------------------------------- > > Key: TEIID-4467 > URL: https://issues.jboss.org/browse/TEIID-4467 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12 > Reporter: Lucie Fabrikova > Priority: Minor > Fix For: 10.x > > Attachments: googlespreadsheet-vdb.xml, server.log > > > Google translator produces following exception for a query: "SELECT IntKey FROM bqt1.SmallA GROUP BY IntKey": > 16:27:26,955 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) TEIID30019 Unexpected exception for request vn+N1XY8Atf5.6: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: [invalid_query] > at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDataProtocolAPI.java:196) > ... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3683) Enhance the formula for caculating core size

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3683?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3683: ---------------------------------- Fix Version/s: 10.0 (was: 9.3.1) > Enhance the formula for caculating core size > -------------------------------------------- > > Key: TEIID-3683 > URL: https://issues.jboss.org/browse/TEIID-3683 > Project: Teiid > Issue Type: Enhancement > Components: Sizing Application > Reporter: Kylin Soong > Assignee: Van Halbert > Priority: Minor > Fix For: 10.0 > > Attachments: sizing-tools-cores.png > > > I think we can consider to enhance in the following aspects: > 1. Q7 is hard for user to input > Q7 need some pre-test or run sample query via POC, this not easy for user to input, also they may feels confused. > 2. How to caculate core size? > Current we consider through serialize/deserialize， the linear serialize/deserialize percentage get from trial in my local pc, this may need more test/review. > 3. Whether we can use runnable app replace Web UI > If use runnable app like AdminShell, most of questions in attached png can cacualate and get a precise input, > Any idea/advice for this? -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4950) PostgreSQL Linux ODBC driver v09.06.0100 and newer does not work with Teiid Server 9.1.1

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4950?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4950. ----------------------------------- Resolution: Done Marking as resolved given there's been no additional feedback. > PostgreSQL Linux ODBC driver v09.06.0100 and newer does not work with Teiid Server 9.1.1 > ---------------------------------------------------------------------------------------- > > Key: TEIID-4950 > URL: https://issues.jboss.org/browse/TEIID-4950 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 9.1.1 > Environment: Oracle Linux 7.3 > OBIEE 12c > unixODBC > Official PostgreSQL ODBC Drivers > Reporter: Steve Boyce > Assignee: Steven Hawkins > Fix For: 10.0, 9.3.1 > > > PostgreSQL ODBC driver v09.06.0100 and newer does not work with Teiid Server 9.1.1 > This is an OBIEE 12c/unixODBC error: > {noformat} > [2017-06-06T15:00:48.159+00:00] [OBIS] [ERROR:1] [] [] [ecid: 005KKjYVpflEkJ4_VTS4yc0004Vq0002Lh,0:1] [sik: ssi] [tid: a5dc9700] [nQSError: 16001] ODBC error state: 50000 code: 110 message: [unixODBC]ERROR: TEIID31100 Parsing error: Encountered "[*]SET[*] DateStyle =" at line 1, column 1. [[ > file: server/Query/Execution/DbGateway/Odbc35/../Odbc/Src/SQXDGOdbcConnection.cpp; line: 1009 > Properties: description=ExecutePhysical Exchange; producerID=0x321b5ff8; requestID=0x61ac0002; sessionID=0x61ac0000; userName=weblogic; > Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" .... > {noformat} > Looking at the source code for the ODBC drivers, it seems that switching from CC_send_settings to CC_send_query for setting various settings does not work with Teiid. > {noformat} > # grep -r -i --include *.c DateStyle psqlodbc-09* > psqlodbc-09.05.0400/connection.c: CC_send_settings(self, "SET DateStyle = 'ISO';SET extra_float_digits = 2"); > psqlodbc-09.06.0100/connection.c: res = CC_send_query(self, "SET DateStyle = 'ISO';SET extra_float_digits = 2;" ISOLATION_SHOW_QUERY, NULL, 0, NULL); > psqlodbc-09.06.0200/connection.c: res = CC_send_query(self, "SET DateStyle = 'ISO';SET extra_float_digits = 2;" ISOLATION_SHOW_QUERY, NULL, 0, NULL); > psqlodbc-09.06.0300/connection.c: res = CC_send_query(self, "SET DateStyle = 'ISO';SET extra_float_digits = 2;" ISOLATION_SHOW_QUERY, NULL, 0, NULL); > psqlodbc-09.06.0310/connection.c: res = CC_send_query(self, "SET DateStyle = 'ISO';SET extra_float_digits = 2;" ISOLATION_SHOW_QUERY, NULL, 0, NULL); > {noformat} > I'm not sure if the bug is with the ODBC driver or this was an intentional change that Postgres Server can deal with and therefore Teiid server should be able to deal with. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 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 updated TEIID-4884: ---------------------------------- Fix Version/s: (was: 9.3.1) > 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 > Components: Misc. Connectors > Affects Versions: 9.3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 10.0 > > 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4986) Couchbase import nested array handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4986?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4986. ----------------------------------- Resolution: Done Updated the logic to reset or use a copy of the dimension value as appropriate. > Couchbase import nested array handling > -------------------------------------- > > Key: TEIID-4986 > URL: https://issues.jboss.org/browse/TEIID-4986 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0, 8.12.x-6.4, 9.3.1 > > > The import logic dim indexing logic will produce different results depending upon the order in which attributes are visited. This is due to only having on Dimension per document. The nesting structure needs to be considered more. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4986) Couchbase import nested array handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4986?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4986: ---------------------------------- Fix Version/s: 9.3.1 > Couchbase import nested array handling > -------------------------------------- > > Key: TEIID-4986 > URL: https://issues.jboss.org/browse/TEIID-4986 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0, 8.12.x-6.4, 9.3.1 > > > The import logic dim indexing logic will produce different results depending upon the order in which attributes are visited. This is due to only having on Dimension per document. The nesting structure needs to be considered more. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 2 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2017