April 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3133) Impala Time/Date/Timestamp handling

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3133?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3133: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1207220|https://bugzilla.redhat.com/show_bug.cgi?id=1207220] from NEW to MODIFIED > Impala Time/Date/Timestamp handling > ----------------------------------- > > Key: TEIID-3133 > URL: https://issues.jboss.org/browse/TEIID-3133 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9, 8.7.2 > > > Impala supports only TIMESTAMP datatype (see here http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates...) > Converted everything into timestamp and now I am trying to get Date and Time parts of the timestamp in Teiid e.g. > SELECT DISTINCT convert(Source.SmallA.TimeValue, time) as TimeValue FROM Source.SmallA ORDER BY TimeValue > But I get TranslatorException: Unexpected exception while translating results: Method not supported > Tried to workaround this but with limited success. For Date it is possible to use to_date function that returns string reprsentation of the date part. For Time I wasn't able to find the solution (have not yet figured out how to use extract function through Teiid). > http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates... -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3133) Impala Time/Date/Timestamp handling

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3133?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-3133: ---------------------------------- > Impala Time/Date/Timestamp handling > ----------------------------------- > > Key: TEIID-3133 > URL: https://issues.jboss.org/browse/TEIID-3133 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > Impala supports only TIMESTAMP datatype (see here http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates...) > Converted everything into timestamp and now I am trying to get Date and Time parts of the timestamp in Teiid e.g. > SELECT DISTINCT convert(Source.SmallA.TimeValue, time) as TimeValue FROM Source.SmallA ORDER BY TimeValue > But I get TranslatorException: Unexpected exception while translating results: Method not supported > Tried to workaround this but with limited success. For Date it is possible to use to_date function that returns string reprsentation of the date part. For Time I wasn't able to find the solution (have not yet figured out how to use extract function through Teiid). > http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates... -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3133) Impala Time/Date/Timestamp handling

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3133?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-3133: --------------------------------- Fix Version/s: 8.7.2 > Impala Time/Date/Timestamp handling > ----------------------------------- > > Key: TEIID-3133 > URL: https://issues.jboss.org/browse/TEIID-3133 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9, 8.7.2 > > > Impala supports only TIMESTAMP datatype (see here http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates...) > Converted everything into timestamp and now I am trying to get Date and Time parts of the timestamp in Teiid e.g. > SELECT DISTINCT convert(Source.SmallA.TimeValue, time) as TimeValue FROM Source.SmallA ORDER BY TimeValue > But I get TranslatorException: Unexpected exception while translating results: Method not supported > Tried to workaround this but with limited success. For Date it is possible to use to_date function that returns string reprsentation of the date part. For Time I wasn't able to find the solution (have not yet figured out how to use extract function through Teiid). > http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates... -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3133) Impala Time/Date/Timestamp handling

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3133?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-3133. -------------------------------- Resolution: Done > Impala Time/Date/Timestamp handling > ----------------------------------- > > Key: TEIID-3133 > URL: https://issues.jboss.org/browse/TEIID-3133 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.7.2, 8.9 > > > Impala supports only TIMESTAMP datatype (see here http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates...) > Converted everything into timestamp and now I am trying to get Date and Time parts of the timestamp in Teiid e.g. > SELECT DISTINCT convert(Source.SmallA.TimeValue, time) as TimeValue FROM Source.SmallA ORDER BY TimeValue > But I get TranslatorException: Unexpected exception while translating results: Method not supported > Tried to workaround this but with limited success. For Date it is possible to use to_date function that returns string reprsentation of the date part. For Time I wasn't able to find the solution (have not yet figured out how to use extract function through Teiid). > http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/lates... -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce.

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-3128. -------------------------------- Resolution: Done > Issue while querying Salesforce. > --------------------------------- > > Key: TEIID-3128 > URL: https://issues.jboss.org/browse/TEIID-3128 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.4 > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 8.7.2, 6.2-8.7.2, 8.9 > > > (I am using Teiid Embedded 8.8.0.Final) > Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796 > Steps to reproduce at my end: > 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account. > 2) Execute the queries as shown in the steps below > 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR) > -Changing the order of the From part makes it run fine -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce.

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-3128: ---------------------------------- > Issue while querying Salesforce. > --------------------------------- > > Key: TEIID-3128 > URL: https://issues.jboss.org/browse/TEIID-3128 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.4 > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 8.9, 6.2-8.7.2 > > > (I am using Teiid Embedded 8.8.0.Final) > Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796 > Steps to reproduce at my end: > 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account. > 2) Execute the queries as shown in the steps below > 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR) > -Changing the order of the From part makes it run fine -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce.

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-3128: --------------------------------- Fix Version/s: 8.7.2 > Issue while querying Salesforce. > --------------------------------- > > Key: TEIID-3128 > URL: https://issues.jboss.org/browse/TEIID-3128 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.4 > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 8.9, 8.7.2, 6.2-8.7.2 > > > (I am using Teiid Embedded 8.8.0.Final) > Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796 > Steps to reproduce at my end: > 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account. > 2) Execute the queries as shown in the steps below > 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR) > -Changing the order of the From part makes it run fine -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce.

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3128: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1201523|https://bugzilla.redhat.com/show_bug.cgi?id=1201523] from NEW to MODIFIED > Issue while querying Salesforce. > --------------------------------- > > Key: TEIID-3128 > URL: https://issues.jboss.org/browse/TEIID-3128 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.4 > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 8.9, 6.2-8.7.2 > > > (I am using Teiid Embedded 8.8.0.Final) > Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796 > Steps to reproduce at my end: > 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account. > 2) Execute the queries as shown in the steps below > 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR) > -Changing the order of the From part makes it run fine -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3112) Incorrect plural name with parent to child join

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3112?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-3112. -------------------------------- Resolution: Done > Incorrect plural name with parent to child join > ----------------------------------------------- > > Key: TEIID-3112 > URL: https://issues.jboss.org/browse/TEIID-3112 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.2, 6.2-8.7.2, 8.9 > > > The salesforce logic assumes the plural name can be created with just an 's' at the end, however objects such as Opportunity do not follow that pattern. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3112) Incorrect plural name with parent to child join

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3112?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-3112: ---------------------------------- > Incorrect plural name with parent to child join > ----------------------------------------------- > > Key: TEIID-3112 > URL: https://issues.jboss.org/browse/TEIID-3112 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9, 6.2-8.7.2 > > > The salesforce logic assumes the plural name can be created with just an 's' at the end, however objects such as Opportunity do not follow that pattern. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2015