July 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3327) Translator for OSIsoft PI

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3327?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-3327: ------------------------------- Comment: was deleted (was: A comment with security level 'JBoss Employee' was removed.) > Translator for OSIsoft PI > ------------------------- > > Key: TEIID-3327 > URL: https://issues.jboss.org/browse/TEIID-3327 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Albert Wong > Fix For: 8.12 > > > We have several customers that are using OSIsoft to get time sliced data. We'd like JDV/Teiid to be able to pull data from OSIsoft (OSIsoft is a data source for JDV/Teiid). -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3327) Translator for OSIsoft PI

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3327?page=com.atlassian.jira.plugin... ] Ramesh Reddy edited comment on TEIID-3327 at 7/21/15 10:25 PM: --------------------------------------------------------------- [~kylin] I have one done at https://github.com/teiid-marketplace/pi and waiting on feedback from user for any further changes. was (Author: rareddy): [~kylin] I have one done at https://github.com/teiid-marketplace/pi > Translator for OSIsoft PI > ------------------------- > > Key: TEIID-3327 > URL: https://issues.jboss.org/browse/TEIID-3327 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Albert Wong > Fix For: 8.12 > > > We have several customers that are using OSIsoft to get time sliced data. We'd like JDV/Teiid to be able to pull data from OSIsoft (OSIsoft is a data source for JDV/Teiid). -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3327) Translator for OSIsoft PI

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3327?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3327: ------------------------------------- [~kylin] I have one done at https://github.com/teiid-marketplace/pi > Translator for OSIsoft PI > ------------------------- > > Key: TEIID-3327 > URL: https://issues.jboss.org/browse/TEIID-3327 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Albert Wong > Fix For: 8.12 > > > We have several customers that are using OSIsoft to get time sliced data. We'd like JDV/Teiid to be able to pull data from OSIsoft (OSIsoft is a data source for JDV/Teiid). -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3327) Translator for OSIsoft PI

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3327?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-3327: ------------------------------------ Alber Can you add a pull request for OSisoft PI translator, since you already have one? > Translator for OSIsoft PI > ------------------------- > > Key: TEIID-3327 > URL: https://issues.jboss.org/browse/TEIID-3327 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Albert Wong > Fix For: 8.12 > > > We have several customers that are using OSIsoft to get time sliced data. We'd like JDV/Teiid to be able to pull data from OSIsoft (OSIsoft is a data source for JDV/Teiid). -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2813) Report translator CPU time

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2813?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2813: ------------------------------------- Any reason not calculate for user query? > Report translator CPU time > -------------------------- > > Key: TEIID-2813 > URL: https://issues.jboss.org/browse/TEIID-2813 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.12 > > > The COMMAND_LOG ought to report the CPU time accumulated by the translator for performance tuning purposes. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2813) Report translator CPU time

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2813?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2813. ----------------------------------- Resolution: Done Added specifically for source queries. The CommandLogMessage now has a getCpuTime method which reports the cpu nano seconds. It is null on the new and cancel events. It is reported as -1 if the metric cannot be captured. Also changed there to be an end event even if an error occurs - so that the row and time totals are still reported. > Report translator CPU time > -------------------------- > > Key: TEIID-2813 > URL: https://issues.jboss.org/browse/TEIID-2813 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.12 > > > The COMMAND_LOG ought to report the CPU time accumulated by the translator for performance tuning purposes. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2883) Support ParAccel as a data source

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2883?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-2883. --------------------------------- Labels: alpha2 (was: ) Resolution: Done Added translator for Actian Vector in Hadoop, wrote small article about the setup of the environment https://developer.jboss.org/wiki/ActianVectorInHadoopWithTeiid > Support ParAccel as a data source > --------------------------------- > > Key: TEIID-2883 > URL: https://issues.jboss.org/browse/TEIID-2883 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Labels: alpha2 > Fix For: 8.12 > > > Support ParAccel as a data source -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3580) Hive 0.13.1 JDBC jars makes queries run slow

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3580?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3580: --------------------------------------- > Very interesting Steven! I executed the query "SELECT g_0.code, g_0.description, g_0.total_emp, g_0.salary FROM sample_07 AS g_0" from the web app and its taking the same 20 seconds to return. I run the same query from a standalone JDBC project and the delay is the same : 20+ second. Excellent. That greatly simplifies the approach to working the issue. > Whats your guess about what is happening ? I couldn't really say. A guess would be that the driver is doing some upfront resolving when the column names are specified vs. select *. If the delay only happens one time, then the driver is likely pulling/caching some metastore information. If it's happening every time, then it's likely that something is wrong with the metastore. > So it safe to assume that the culprit is somewhere in the jars ? I'm not sure that's yet clear either. But at least it will simpler to iterate on as a standalone project to see if different jar versions make a difference. > Hive 0.13.1 JDBC jars makes queries run slow > -------------------------------------------- > > Key: TEIID-3580 > URL: https://issues.jboss.org/browse/TEIID-3580 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.3 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Attachments: threaddump-1437508266001.tdump > > > When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, queries executed against table 'default.sample_07' takes approximately 20-30 seconds to return. > The Hive JDBC jars for version 0.13.1 can be found here : > https://github.com/vchintal/hive-jdbc-jars-archive > Alternatively a ready-to-go modules can be downloaded from here for testing: > https://drive.google.com/file/d/0BxJhoZ1V34QHSmgzTlBRVktZaGM/ > Use the following driver snippet when using the above mentioned module: > <driver name="hive" module="org.apache.hadoop.hive:0.13.1"> > <driver-class>org.apache.hive.jdbc.HiveDriver</driver-class> > </driver> -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3580) Hive 0.13.1 JDBC jars makes queries run slow

by Vijay Bhaskar Chintalapati (JIRA)

[ https://issues.jboss.org/browse/TEIID-3580?page=com.atlassian.jira.plugin... ] Vijay Bhaskar Chintalapati commented on TEIID-3580: --------------------------------------------------- Very interesting Steven! I executed the query "SELECT g_0.code, g_0.description, g_0.total_emp, g_0.salary FROM sample_07 AS g_0" from the web app and its taking the same 20 seconds to return. I run the same query from a standalone JDBC project and the delay is the same : 20+ second. Whats your guess about what is happening ? I run the same query against Hive 1.2.0 using the Hive 1.2.0 jars and the query returns in less than a second. So it safe to assume that the culprit is somewhere in the jars ? > Hive 0.13.1 JDBC jars makes queries run slow > -------------------------------------------- > > Key: TEIID-3580 > URL: https://issues.jboss.org/browse/TEIID-3580 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.3 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Attachments: threaddump-1437508266001.tdump > > > When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, queries executed against table 'default.sample_07' takes approximately 20-30 seconds to return. > The Hive JDBC jars for version 0.13.1 can be found here : > https://github.com/vchintal/hive-jdbc-jars-archive > Alternatively a ready-to-go modules can be downloaded from here for testing: > https://drive.google.com/file/d/0BxJhoZ1V34QHSmgzTlBRVktZaGM/ > Use the following driver snippet when using the above mentioned module: > <driver name="hive" module="org.apache.hadoop.hive:0.13.1"> > <driver-class>org.apache.hive.jdbc.HiveDriver</driver-class> > </driver> -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3580) Hive 0.13.1 JDBC jars makes queries run slow

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3580?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3580: --------------------------------------- Make sure it is exactly the same down to the SQL. The thought here is that you should be able to replicate this behavior outside of Teiid. > Hive 0.13.1 JDBC jars makes queries run slow > -------------------------------------------- > > Key: TEIID-3580 > URL: https://issues.jboss.org/browse/TEIID-3580 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.3 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Attachments: threaddump-1437508266001.tdump > > > When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, queries executed against table 'default.sample_07' takes approximately 20-30 seconds to return. > The Hive JDBC jars for version 0.13.1 can be found here : > https://github.com/vchintal/hive-jdbc-jars-archive > Alternatively a ready-to-go modules can be downloaded from here for testing: > https://drive.google.com/file/d/0BxJhoZ1V34QHSmgzTlBRVktZaGM/ > Use the following driver snippet when using the above mentioned module: > <driver name="hive" module="org.apache.hadoop.hive:0.13.1"> > <driver-class>org.apache.hive.jdbc.HiveDriver</driver-class> > </driver> -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2015