November 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2741) Failed to execute nested function with MongoDB translator

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-2741: ----------------------------------- Summary: Failed to execute nested function with MongoDB translator Key: TEIID-2741 URL: https://issues.jboss.org/browse/TEIID-2741 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.4 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.6 failed to execute a call like {code} select concat(lastname, concat(",", firstname)) from user {code} single concat works correctly -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2736) MongoDB: failed to translate to mongo query with boolean value expression

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2736?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-2736: -------------------------------- Summary: MongoDB: failed to translate to mongo query with boolean value expression (was: MongoBD: failed to translate to mongo query with boolean value expression) > MongoDB: failed to translate to mongo query with boolean value expression > -------------------------------------------------------------------------- > > Key: TEIID-2736 > URL: https://issues.jboss.org/browse/TEIID-2736 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: Teiid 8.6 beta with mongoDB > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Labels: teiid > Fix For: 8.6 > > > Fail to translate the following SQL to mongo query: > select "grade", > "name", > "score", > "state", > "grade" as "test", > ("name" = "state") as "name2" > from "mongoDBDS"."grades" > where "grade" = 'B' > However, it works with the query contains group by and boolean value expression: > elect "grade" as "test", > "grade", > ("name" = "state") as "name2", > sum("score") as "sum_score" > from "mongoDBDS"."grades" > where "grade" = 'B' > group by "grade", "grade", ("name" = "state") > order by "grade", "test", "name2" -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2740) Support Direct Query Execution with MongoDB

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-2740: ----------------------------------- Summary: Support Direct Query Execution with MongoDB Key: TEIID-2740 URL: https://issues.jboss.org/browse/TEIID-2740 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Affects Versions: 8.4 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.6 Direct query execution in the MongoDB was not implemented completely. This needs to be fixed as this would be a very helpful enhancement. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2739) google spreadsheet translator does not support parameterized native queries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2739?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2739. ----------------------------------- Resolution: Done Updated the direct logic to support parametization and added support for native-query extension property procedures. > google spreadsheet translator does not support parameterized native queries > --------------------------------------------------------------------------- > > Key: TEIID-2739 > URL: https://issues.jboss.org/browse/TEIID-2739 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.3 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6 > > > The docs assume that the google spreadsheet translator supports parameterizable native-query procedures and direct query procedure. The source however does not yet implement this. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2647) Add an impala translator

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2647?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2647: ------------------------------------- That seems strange to use the same driver name. May be they are just going for drop in replacement for Hive? which is fine I guess, but translator will not take advantage of any *more* features Impala driver may have over Hive. You can restrict not loading both by modifying the module.xml of the hive module. > Add an impala translator > ------------------------ > > Key: TEIID-2647 > URL: https://issues.jboss.org/browse/TEIID-2647 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: Open To Community > > > Impala offers an alternative to Hive SQL access: > http://blog.cloudera.com/blog/2012/10/cloudera-impala-real-time-queries-i... -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2647) Add an impala translator

by Andy Yip (JIRA)

[ https://issues.jboss.org/browse/TEIID-2647?page=com.atlassian.jira.plugin... ] Andy Yip commented on TEIID-2647: --------------------------------- For whatever it's worth. I was able to use the Impala driver with the Hive Translator. I have not tested extensively but simple queries seems to be working and a whole lot faster. I did noticed the Impala driver class is the exact same as the Hive driver class (org.apache.hive.jdbc.HiveDriver). I don't know if this will be an issue in the future if one chooses to load both driver. > Add an impala translator > ------------------------ > > Key: TEIID-2647 > URL: https://issues.jboss.org/browse/TEIID-2647 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: Open To Community > > > Impala offers an alternative to Hive SQL access: > http://blog.cloudera.com/blog/2012/10/cloudera-impala-real-time-queries-i... -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2738) Hive Translator does not utilize some or all of the Importer Properties.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2738?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2738: --------------------------------------- Hive is not expected to support most of the importer properties as it does not utilize JDBC DatabaseMetadata, and does not import procedures nor currently keys/indexes. Until additional import capabilities are added the N/A properties are: autoCreateUniqueConstraints excludeProcedures importApproximateIndexes importIndexes importKeys importProcedures procedureNamePattern schemaPattern tableNamePattern tableTypes useCatalogName useFullSchemaName useProcedureSpecificName useQualifiedName widenUnsingedTypes For this issue we can update the docs along those lines. The quoting related properties are applicable (but I'm not sure off hand if Hive even indicates a metadata quote string). So essentially all we would currently look at implementing is excludeTables. > Hive Translator does not utilize some or all of the Importer Properties. > ------------------------------------------------------------------------- > > Key: TEIID-2738 > URL: https://issues.jboss.org/browse/TEIID-2738 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.6 > Reporter: Andy Yip > Assignee: Steven Hawkins > -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2737) Rename native query procedure

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2737?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2737. ----------------------------------- Fix Version/s: 8.6 Resolution: Done Updated the docs and the api to use the term direct query procedure, but left the default name as native for now. > Rename native query procedure > ----------------------------- > > Key: TEIID-2737 > URL: https://issues.jboss.org/browse/TEIID-2737 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6 > > > We have two somewhat related native querying features - the native-query extension property used on tables/procedures/functions, and a native procedure that can be exposed to issue arbitrary statements. > It has been proposed to rename the native query procedure to the direct query procedure (which matches the translator api). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2739) google spreadsheet translator does not support parameterized native queries

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2739: ------------------------------------- Summary: google spreadsheet translator does not support parameterized native queries Key: TEIID-2739 URL: https://issues.jboss.org/browse/TEIID-2739 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.3 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.6 The docs assume that the google spreadsheet translator supports parameterizable native-query procedures and direct query procedure. The source however does not yet implement this. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2738) Hive Translator does not utilize some or all of the Importer Properties.

by Andy Yip (JIRA)

[ https://issues.jboss.org/browse/TEIID-2738?page=com.atlassian.jira.plugin... ] Andy Yip updated TEIID-2738: ---------------------------- Component/s: Misc. Connectors > Hive Translator does not utilize some or all of the Importer Properties. > ------------------------------------------------------------------------- > > Key: TEIID-2738 > URL: https://issues.jboss.org/browse/TEIID-2738 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.6 > Reporter: Andy Yip > Assignee: Steven Hawkins > -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2013