January 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3775) HBase - GROUP BY clause returns duplicates results

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3775?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3775. --------------------------------- > HBase - GROUP BY clause returns duplicates results > -------------------------------------------------- > > Key: TEIID-3775 > URL: https://issues.jboss.org/browse/TEIID-3775 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > I have a view defined as follows: > {code:sql} > CREATE VIEW U8 (IntKey integer, > StringKey string, > IntNum integer, > StringNum string, > FloatNum float, > LongNum long, > DoubleNum double, > ByteNum byte, > DateValue date, > TimeValue time, > TimestampValue timestamp, > BooleanValue boolean, > CharValue char, > ShortValue short, > BigIntegerValue biginteger, > BigDecimalValue bigdecimal) > AS > SELECT BQT1.SmallA.IntKey, BQT1.SmallA.StringKey, BQT1.SmallA.IntNum, BQT1.SmallA.StringNum, > BQT1.SmallA.FloatNum, BQT1.SmallA.LongNum, BQT1.SmallA.DoubleNum, BQT1.SmallA.ByteNum, > BQT1.SmallA.DateValue, BQT1.SmallA.TimeValue, BQT1.SmallA.TimestampValue, BQT1.SmallA.BooleanValue, > BQT1.SmallA.CharValue, BQT1.SmallA.ShortValue, BQT1.SmallA.BigIntegerValue, BQT1.SmallA.BigDecimalValue > FROM BQT1.SmallA > UNION > SELECT BQT1.SmallB.IntKey, BQT1.SmallB.StringKey, BQT1.SmallB.IntNum, BQT1.SmallB.StringNum, > BQT1.SmallB.FloatNum, BQT1.SmallB.LongNum, BQT1.SmallB.DoubleNum, BQT1.SmallB.ByteNum, > BQT1.SmallB.DateValue, BQT1.SmallB.TimeValue, BQT1.SmallB.TimestampValue, BQT1.SmallB.BooleanValue, > BQT1.SmallB.CharValue, BQT1.SmallB.ShortValue, BQT1.SmallB.BigIntegerValue, BQT1.SmallB.BigDecimalValue > FROM BQT1.SmallB ORDER BY IntKey; > {code} > Query *SELECT StringNum FROM VQT.U8 GROUP BY StringNum* returns duplicate results (multiple null). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3830) Install script executed failed due to threads subsystem be removed

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3830?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3830: ---------------------------------- Fix Version/s: (was: 8.13) > Install script executed failed due to threads subsystem be removed > ------------------------------------------------------------------ > > Key: TEIID-3830 > URL: https://issues.jboss.org/browse/TEIID-3830 > Project: Teiid > Issue Type: Sub-task > Components: Build/Kits > Affects Versions: 8.13 > Reporter: Kylin Soong > Assignee: Steven Hawkins > Priority: Blocker > > According to WFLY-462, the central thread pool configuration(threads subsystem) already be removed since 9.0.0.CR2, these two scripts: > * teiid-standalone-mode-install.cli > * teiid-domain-mode-install.cli > be affected, specifically the following lines cli can not executed: > {code} > /subsystem=threads/unbounded-queue-thread-pool=teiid-async:add(max-threads=4) > /subsystem=teiid:add(async-thread-pool=teiid-async, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid) > {code} > The corresponding error looks > {code} > Failed to get the list of the operation properties: "WFLYCTL0030: No resource definition is registered for address [ > ("subsystem" => "threads"), > ("unbounded-queue-thread-pool" => "teiid-async") > ]" > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3923) Remove databasetimezone property from odata4 translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3923?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3923. ----------------------------------- Resolution: Done Removed the property from the translator. > Remove databasetimezone property from odata4 translator > ------------------------------------------------------- > > Key: TEIID-3923 > URL: https://issues.jboss.org/browse/TEIID-3923 > Project: Teiid > Issue Type: Quality Risk > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.13 > > > The databasetimezone execution property is not used - and not needed since all date/time information needs to be in gmt or with an explicit timezone. > This is a candidate for 8.12.5 as well. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3918) HIVE translator does not support direct query procedure

by jie tao (JIRA)

[ https://issues.jboss.org/browse/TEIID-3918?page=com.atlassian.jira.plugin... ] jie tao commented on TEIID-3918: -------------------------------- Thank you very much! > HIVE translator does not support direct query procedure > ------------------------------------------------------- > > Key: TEIID-3918 > URL: https://issues.jboss.org/browse/TEIID-3918 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Connector > Reporter: jie tao > Assignee: Steven Hawkins > Fix For: 8.13, 9.0 > > > I used EXEC native (sqlstring) to let my query be executed directly on my Hive without Teiid's modification of my query. This works with MySQL. For HIVE I got: > "org.teiid.jdbc.TeiidSQLException: TEIID30504 Hive13: TEIID24000 This EXEC native('select a.game, a.lang, get_json_object(a.json, \"$.product\") from test.event_log a') command not supported. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3918) HIVE translator does not support direct query procedure

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3918?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3918: ---------------------------------- Fix Version/s: 8.13 > HIVE translator does not support direct query procedure > ------------------------------------------------------- > > Key: TEIID-3918 > URL: https://issues.jboss.org/browse/TEIID-3918 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Connector > Reporter: jie tao > Assignee: Steven Hawkins > Fix For: 8.13, 9.0 > > > I used EXEC native (sqlstring) to let my query be executed directly on my Hive without Teiid's modification of my query. This works with MySQL. For HIVE I got: > "org.teiid.jdbc.TeiidSQLException: TEIID30504 Hive13: TEIID24000 This EXEC native('select a.game, a.lang, get_json_object(a.json, \"$.product\") from test.event_log a') command not supported. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3935) Add option to delay starting the executing of materialization for a period of time (secs)

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3935?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3935: ------------------------------------ This is specifically where the data source (RemteCacheManager) is created by the user and provided to the resource-adapter via jndi. This is for external materialization. > Add option to delay starting the executing of materialization for a period of time (secs) > ----------------------------------------------------------------------------------------- > > Key: TEIID-3935 > URL: https://issues.jboss.org/browse/TEIID-3935 > Project: Teiid > Issue Type: Enhancement > Components: Server > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Minor > > The problem is, the creation/binding into jndi is done via a web applicatio, but Teiid is starting the materialization execution before all resources are started as part of the JBoss AS server boot up. Would like an option to delay the starting of the materialization execution by "x" amount of seconds. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3935) Add option to delay starting the executing of materialization for a period of time (secs)

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3935?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3935: ------------------------------------ I thought about adding this delay to the translator, but would it best to be done in core teiid because this could occur for other resource-adapters. > Add option to delay starting the executing of materialization for a period of time (secs) > ----------------------------------------------------------------------------------------- > > Key: TEIID-3935 > URL: https://issues.jboss.org/browse/TEIID-3935 > Project: Teiid > Issue Type: Enhancement > Components: Server > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Minor > > The problem is, the creation/binding into jndi is done via a web applicatio, but Teiid is starting the materialization execution before all resources are started as part of the JBoss AS server boot up. Would like an option to delay the starting of the materialization execution by "x" amount of seconds. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3935) Add option to delay starting the executing of materialization for a period of time (secs)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3935?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3935: --------------------------------------- > The problem is, the creation/binding into jndi is done via a web application Are you talking specifically about a web console deployment scenario? > Teiid is starting the materialization execution before all resources are started as part of the JBoss AS server boot up Are you talking about internal or external materialization? > Add option to delay starting the executing of materialization for a period of time (secs) > ----------------------------------------------------------------------------------------- > > Key: TEIID-3935 > URL: https://issues.jboss.org/browse/TEIID-3935 > Project: Teiid > Issue Type: Enhancement > Components: Server > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Minor > > The problem is, the creation/binding into jndi is done via a web applicatio, but Teiid is starting the materialization execution before all resources are started as part of the JBoss AS server boot up. Would like an option to delay the starting of the materialization execution by "x" amount of seconds. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3935) Add option to delay starting the executing of materialization for a period of time (secs)

by Van Halbert (JIRA)

Van Halbert created TEIID-3935: ---------------------------------- Summary: Add option to delay starting the executing of materialization for a period of time (secs) Key: TEIID-3935 URL: https://issues.jboss.org/browse/TEIID-3935 Project: Teiid Issue Type: Enhancement Components: Server Affects Versions: 8.12.x Reporter: Van Halbert Assignee: Steven Hawkins Priority: Minor The problem is, the creation/binding into jndi is done via a web applicatio, but Teiid is starting the materialization execution before all resources are started as part of the JBoss AS server boot up. Would like an option to delay the starting of the materialization execution by "x" amount of seconds. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3918) HIVE translator does not support direct query procedure

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3918?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3918: --------------------------------------- This will be in the 9.0 release series and I'll add it to 8.13 as well, which should go final today. > HIVE translator does not support direct query procedure > ------------------------------------------------------- > > Key: TEIID-3918 > URL: https://issues.jboss.org/browse/TEIID-3918 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Connector > Reporter: jie tao > Assignee: Steven Hawkins > Fix For: 9.0 > > > I used EXEC native (sqlstring) to let my query be executed directly on my Hive without Teiid's modification of my query. This works with MySQL. For HIVE I got: > "org.teiid.jdbc.TeiidSQLException: TEIID30504 Hive13: TEIID24000 This EXEC native('select a.game, a.lang, get_json_object(a.json, \"$.product\") from test.event_log a') command not supported. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2016