July 2015 - teiid-issues - Jboss List Archives

[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 edited comment on TEIID-3580 at 7/21/15 2:40 PM: ---------------------------------------------------------------------------- Well, I tested the driver jar set with a simple app that injects the Hive datasource in a web app as a resource and executes a query. The query came back with 500 rows from Hive in 1 second. So this doesn't seem to be a issue with EAP as well was (Author: vbchin2): Well, I tested the driver jar set with a simple app that injects the Hive datasource in a web app as a resource and executes a query. The query came back in 1 seconds. So this doesn't seem to be a issue with EAP as well > 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 > > 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: --------------------------------------------------- Well, I tested the driver jar set with a simple app that injects the Hive datasource in a web app as a resource and executes a query. The query came back in 1 seconds. So this doesn't seem to be a issue with EAP as well > 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 > > 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-2813) Report translator CPU time

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2813?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2813: --------------------------------------- Will implement the translator piece. If we do the engine as well, then there will need to be some additional logic to account for the overlap when the translator execution is serial. > 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... ] Work on TEIID-2813 started by Steven Hawkins. --------------------------------------------- > 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-3585) MySQL 5.5 - INSERT fails (java.sql.SQLException: Unknown Types value)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3585?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3585: --------------------------------------- This was addressed by TEIID-3340 > MySQL 5.5 - INSERT fails (java.sql.SQLException: Unknown Types value) > ---------------------------------------------------------------------- > > Key: TEIID-3585 > URL: https://issues.jboss.org/browse/TEIID-3585 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Connector/J version: 5.1.36 > MySQL server version: 5.5.43 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > If INSERT statement contains an object value then execution fails with "java.sql.SQLException: Unknown Types value". There is no exception without object value. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3585) MySQL 5.5 - INSERT fails (java.sql.SQLException: Unknown Types value)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3585?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3585: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1245204 > MySQL 5.5 - INSERT fails (java.sql.SQLException: Unknown Types value) > ---------------------------------------------------------------------- > > Key: TEIID-3585 > URL: https://issues.jboss.org/browse/TEIID-3585 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Connector/J version: 5.1.36 > MySQL server version: 5.5.43 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > If INSERT statement contains an object value then execution fails with "java.sql.SQLException: Unknown Types value". There is no exception without object value. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3585) MySQL 5.5 - INSERT fails (java.sql.SQLException: Unknown Types value)

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-3585: ----------------------------------- Summary: MySQL 5.5 - INSERT fails (java.sql.SQLException: Unknown Types value) Key: TEIID-3585 URL: https://issues.jboss.org/browse/TEIID-3585 Project: Teiid Issue Type: Bug Affects Versions: 8.7.1.6_2 Environment: Connector/J version: 5.1.36 MySQL server version: 5.5.43 Reporter: Juraj Duráni Assignee: Steven Hawkins If INSERT statement contains an object value then execution fails with "java.sql.SQLException: Unknown Types value". There is no exception without object value. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3584) NoSuchMethodError when issuing show plan request -IBM JDK 1.6

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3584?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3584: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1245158|https://bugzilla.redhat.com/show_bug.cgi?id=1245158] from NEW to CLOSED > NoSuchMethodError when issuing show plan request -IBM JDK 1.6 > ------------------------------------------------------------- > > Key: TEIID-3584 > URL: https://issues.jboss.org/browse/TEIID-3584 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.7.1 > Environment: IBM JDK 1.6 > Reporter: Filip Elias > Assignee: Steven Hawkins > > Teiid client throws an error[1] when processing "show plan;" request. This issue exist only on IBM jdk 1.6. The error is thrown at client side. > [1] > {code} > Exception in thread "main" java.lang.NoSuchMethodError: javax/xml/stream/XMLOutputFactory.newFactory()Ljavax/xml/stream/XMLOutputFactory; > at org.teiid.client.plan.PlanNode.toXml(PlanNode.java:175) > at org.teiid.jdbc.StatementImpl.executeShow(StatementImpl.java:556) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:502) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:393) > at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:327) > at JDBCClient.execute(JDBCClient.java:93) > at JDBCClient.main(JDBCClient.java:47) > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3584) NoSuchMethodError when issuing show plan request -IBM JDK 1.6

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3584?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3584. ----------------------------------- Resolution: Won't Fix See https://issues.jboss.org/browse/JBPAPP6-671 for several workarounds to update the STaX version with the IBM JRE. > NoSuchMethodError when issuing show plan request -IBM JDK 1.6 > ------------------------------------------------------------- > > Key: TEIID-3584 > URL: https://issues.jboss.org/browse/TEIID-3584 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.7.1 > Environment: IBM JDK 1.6 > Reporter: Filip Elias > Assignee: Steven Hawkins > > Teiid client throws an error[1] when processing "show plan;" request. This issue exist only on IBM jdk 1.6. The error is thrown at client side. > [1] > {code} > Exception in thread "main" java.lang.NoSuchMethodError: javax/xml/stream/XMLOutputFactory.newFactory()Ljavax/xml/stream/XMLOutputFactory; > at org.teiid.client.plan.PlanNode.toXml(PlanNode.java:175) > at org.teiid.jdbc.StatementImpl.executeShow(StatementImpl.java:556) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:502) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:393) > at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:327) > at JDBCClient.execute(JDBCClient.java:93) > at JDBCClient.main(JDBCClient.java:47) > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3492) Provide a mechanism for users to modify the salesforce api version

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3492?page=com.atlassian.jira.plugin... ] Ramesh Reddy reopened TEIID-3492: --------------------------------- I will create template project in "teiid" organization, and re-work > Provide a mechanism for users to modify the salesforce api version > ------------------------------------------------------------------ > > Key: TEIID-3492 > URL: https://issues.jboss.org/browse/TEIID-3492 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.12 > > > We should provide a mechanism to easily target a different salesforce api version. We are currently defaulting to v22, which is quite old. The version change must be controlled as the metadata and the sf jars can be incompatible - if you for example build a model from v22, then you must stay on v22, and then recreate the model once you want to move to a later version. > Currently the update procedure would be to copy/modify the salesforce translator module and have it point to newer wsc and partner api jars (which are java api compatible from what I have seen) and then change the any salesforce resource adapters to use the new api url. -- 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