June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3621) HBase translator - UPDATE statement requires primary key

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3621?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3621: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1252333|https://bugzilla.redhat.com/show_bug.cgi?id=1252333] from ON_QA to VERIFIED > HBase translator - UPDATE statement requires primary key > -------------------------------------------------------- > > Key: TEIID-3621 > URL: https://issues.jboss.org/browse/TEIID-3621 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Kylin Soong > Fix For: 8.12 > > > The HBase translator requires table to have a primary key defined. Is the PK really needed? If the table has no PK defined, then all columns are PK. E.g. query *UPDATE hbase.SmallA SET StringNum = '555' WHERE hbase.SmallA.StringNum IS NULL* is translated as *UPSERT INTO smalla (stringnum, intkey) SELECT '555', smalla.intkey FROM smalla WHERE smalla.stringnum IS NULL* (intkey is PK). Teiid can simply add all columns (except those defined in 'SET'). > Yes, I know that HBase requires the PK to be defined, but what happen if a user decide to change PK in VDB [1]? It could be a problem whether PK is in VDB defined or not. > I suggest to add a hbase-translator-specific execution property which define PK in the source table and remove AssertionError [2]. > [1] > *HBase table:* create table mytable(id integer primary key, nickname varchar(1)) > *Teiid table:* create table mytable(id integer, username varchar(1) primary key) > Both, id and username, are valid PK (artificial/natural). > [2] > https://github.com/teiid/teiid/blob/master/connectors/translator-hbase/sr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4266) Convert the Teiid examples to gitbook

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4266?page=com.atlassian.jira.plugin... ] Kylin Soong edited comment on TEIID-4266 at 6/15/16 7:23 AM: ------------------------------------------------------------- https://teiid.gitbooks.io/teiid-quickstarts/content/ is current quick starts documents. Seems gitbook has changed their strategy, can not free create book now(or can not create more than 2 books), I get the Info below from https://www.gitbook.com/@teiid/dashboard {code} Upgrade your account Information: You must subscribe to the Organization plan to create new books. {code} was (Author: kylin): https://teiid.gitbooks.io/teiid-quickstarts/content/ is current quick starts documents. Seems gitbook has changed their strategy, can not free create book now(or can not create more than 2 books), I get the Info below from https://www.gitbook.com/@teiid/dashboard {note} Upgrade your account Information: You must subscribe to the Organization plan to create new books. {note} > Convert the Teiid examples to gitbook > ------------------------------------- > > Key: TEIID-4266 > URL: https://issues.jboss.org/browse/TEIID-4266 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Steven Hawkins > Assignee: Kylin Soong > Fix For: 9.1 > > > https://docs.jboss.org/author/display/teiidexamples/Home should be added to our gitbook documentation set to complete the move out of Confluence. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4266) Convert the Teiid examples to gitbook

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4266?page=com.atlassian.jira.plugin... ] Kylin Soong edited comment on TEIID-4266 at 6/15/16 7:23 AM: ------------------------------------------------------------- https://teiid.gitbooks.io/teiid-quickstarts/content/ is current quick starts documents. Seems gitbook has changed their strategy, can not free create book now(or can not create more than 2 books), I get the Info below from https://www.gitbook.com/@teiid/dashboard {note} Upgrade your account Information: You must subscribe to the Organization plan to create new books. {note} was (Author: kylin): https://teiid.gitbooks.io/teiid-quickstarts/content/ is current quick starts documents. Seems gitbook has changed their strategy, can not free create book now(or can not create more than 2 books), I get the Info below from https://www.gitbook.com/@teiid/dashboard {note} Upgrade your account Information: You must subscribe to the Organization plan to create new books. {note} > Convert the Teiid examples to gitbook > ------------------------------------- > > Key: TEIID-4266 > URL: https://issues.jboss.org/browse/TEIID-4266 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Steven Hawkins > Assignee: Kylin Soong > Fix For: 9.1 > > > https://docs.jboss.org/author/display/teiidexamples/Home should be added to our gitbook documentation set to complete the move out of Confluence. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4266) Convert the Teiid examples to gitbook

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4266?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-4266: ------------------------------------ https://teiid.gitbooks.io/teiid-quickstarts/content/ is current quick starts documents. Seems gitbook has changed their strategy, can not free create book now(or can not create more than 2 books), I get the Info below from https://www.gitbook.com/@teiid/dashboard {note} Upgrade your account Information: You must subscribe to the Organization plan to create new books. {note} > Convert the Teiid examples to gitbook > ------------------------------------- > > Key: TEIID-4266 > URL: https://issues.jboss.org/browse/TEIID-4266 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Steven Hawkins > Assignee: Kylin Soong > Fix For: 9.1 > > > https://docs.jboss.org/author/display/teiidexamples/Home should be added to our gitbook documentation set to complete the move out of Confluence. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3562) Teradata15 - teiid shifts date/time/timestamp values according to timezone.

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3562?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3562: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1240565|https://bugzilla.redhat.com/show_bug.cgi?id=1240565] from ON_QA to VERIFIED > Teradata15 - teiid shifts date/time/timestamp values according to timezone. > --------------------------------------------------------------------------- > > Key: TEIID-3562 > URL: https://issues.jboss.org/browse/TEIID-3562 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: teradata version - 15.00.01.01 > teradata driver version - 15.10.00.05 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12 > > Attachments: Main.java, out_GMT+0500, out_GMT_not_set > > > Teiid shifts date/time/timestamp values returned from teradata according to user.timezone value [1], [2]. However, when I execute source-specific command, teradata returns correct values [3]. > [1] > *Query:* SELECT * FROM smalla ORDER BY IntKey > *-Duser.timezone:* GMT+5 > *Result:* > || IntKey || DateValue || TimeValue || TimeStampValue || > |0 | 1999-12-31 | 19:00:00 | 1999-12-31 19:00:00.0| > |1 | 2000-01-01 | 20:00:00 | 1999-12-31 19:00:01.0| > |2 | 2000-01-02 | 21:00:00 | 1999-12-31 19:00:02.0| > |3 | 2000-01-03 | 22:00:00 | 1999-12-31 19:00:03.0| > |...|...|...|...| > [2] > *Query:* SELECT * FROM smalla ORDER BY IntKey > *-Duser.timezone:* GMT+1 > *Result:* > || IntKey || DateValue || TimeValue || TimeStampValue || > |0 | 1999-12-31 | 23:00:00 | 1999-12-31 23:00:00.0| > |1 | 2000-01-01 | 00:00:00 | 1999-12-31 23:00:01.0| > |2 | 2000-01-02 | 01:00:00 | 1999-12-31 23:00:02.0| > |3 | 2000-01-03 | 02:00:00 | 1999-12-31 23:00:03.0| > |...|...|...|...| > [3] > *Query:* SELECT g_0.IntKey AS c_0, g_0.DateValue AS c_1, g_0.TimeValue AS c_2, g_0.TimestampValue AS c_3 FROM smalla AS g_0 ORDER BY 1 > *local timezone:* GMT+1/GMT+5 > *Result:* > || c_0 || c_1 || c_2 || c_3 || > |0 | 2000-01-01 | 00:00:00 | 2000-01-01 00:00:00.0| > |1 | 2000-01-02 | 01:00:00 | 2000-01-01 00:00:01.0| > |2 | 2000-01-03 | 02:00:00 | 2000-01-01 00:00:02.0| > |3 | 2000-01-04 | 03:00:00 | 2000-01-01 00:00:03.0| > |...|...|...|...| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3771) Teiid throws an NPE while executing query with nested subquery IN predicate

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3771?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3771: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1272915|https://bugzilla.redhat.com/show_bug.cgi?id=1272915] from ON_QA to ASSIGNED > Teiid throws an NPE while executing query with nested subquery IN predicate > --------------------------------------------------------------------------- > > Key: TEIID-3771 > URL: https://issues.jboss.org/browse/TEIID-3771 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Teiid throws an NPE while executing query with double IN predicate. Example query: > SELECT intkey FROM BQT1.SmallA AS A WHERE INTKEY IN (SELECT CONVERT(STRINGKEY, INTEGER) FROM BQT1.SMALLA AS A WHERE STRINGKEY IN (SELECT CONVERT(INTKEY, STRING) FROM BQT1.SMALLA AS B WHERE A.INTNUM = B.INTNUM)) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3770) HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3770?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3770: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1272913|https://bugzilla.redhat.com/show_bug.cgi?id=1272913] from ON_QA to ASSIGNED > HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate > ------------------------------------------------------------------------------------ > > Key: TEIID-3770 > URL: https://issues.jboss.org/browse/TEIID-3770 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Query: > SELECT INTKEY, BIGDECIMALVALUE FROM BQT1.SMALLA AS A WHERE BIGDECIMALVALUE *IN (SELECT MAX(BIGDECIMALVALUE) FROM BQT1.SMALLA AS B WHERE _A_.INTKEY = B.INTKEY)* ORDER BY INTKEY > It seems like bug in Phoenix driver. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3767) HBase - Phoenix does not support LIKE ESCAPE

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3767?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3767: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1272877|https://bugzilla.redhat.com/show_bug.cgi?id=1272877] from ON_QA to VERIFIED > HBase - Phoenix does not support LIKE ESCAPE > -------------------------------------------- > > Key: TEIID-3767 > URL: https://issues.jboss.org/browse/TEIID-3767 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Phoenix does not support LIKE ESCAPE. There is hardcoded escape character \. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3765) HBase - Phoenix does not support scalar subquery

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3765?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3765: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1272849|https://bugzilla.redhat.com/show_bug.cgi?id=1272849] from ON_QA to VERIFIED > HBase - Phoenix does not support scalar subquery > ------------------------------------------------ > > Key: TEIID-3765 > URL: https://issues.jboss.org/browse/TEIID-3765 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Phoenix driver does not support a scalar subquery in a SELECT - E.g. SELECT a, (SELECT...) ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3764) HBase - Phoenix driver does not support UNION

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3764?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3764: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1272845|https://bugzilla.redhat.com/show_bug.cgi?id=1272845] from ON_QA to VERIFIED > HBase - Phoenix driver does not support UNION > --------------------------------------------- > > Key: TEIID-3764 > URL: https://issues.jboss.org/browse/TEIID-3764 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > Phoenix JDBC driver does not support UNION statement, only UNION ALL. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 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 June 2016