December 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4811) Certify and Add Support for Cloudera (CDH) version 5.8

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4811?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4811. --------------------------------- > Certify and Add Support for Cloudera (CDH) version 5.8 > ------------------------------------------------------ > > Key: TEIID-4811 > URL: https://issues.jboss.org/browse/TEIID-4811 > Project: Teiid > Issue Type: Feature Request > Reporter: Anu Saji > Assignee: Steven Hawkins > > Request to add Support for Cloudera (CDH) version 5.8 with JDV 6.3 -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1945) Add Virtual List View (VLV) capabilities to LDAP connector

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1945?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1945. --------------------------------- > Add Virtual List View (VLV) capabilities to LDAP connector > ---------------------------------------------------------- > > Key: TEIID-1945 > URL: https://issues.jboss.org/browse/TEIID-1945 > Project: Teiid > Issue Type: Feature Request > Components: LDAP Connector > Reporter: Marc Shirley > > Request to add Virtual List View (VLV) capabilities to LDAP connector to handle the case of large result sets. During materialization, the query was timing out on the LDAP server before it completed and caused the materialization to fail. This was worked around by increasing the idle timeout on the LDAP server, but a request was made to implement the VLV capabilities in order to avoid the need to increase the idle timeout as the LDAP results grow larger. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4479) Teiid Exception on multiple values criteria

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4479?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4479. --------------------------------- > Teiid Exception on multiple values criteria > ------------------------------------------- > > Key: TEIID-4479 > URL: https://issues.jboss.org/browse/TEIID-4479 > Project: Teiid > Issue Type: Bug > Reporter: Mark Tawk > Assignee: Steven Hawkins > > I'm using Teiid 9.0.0 with mysql > I'm getting an exception on the query below when putting more then one value in the criteria : ("JPVPricedSecurities"."Reply_VendorID" IN (10, 2)) > if the criteria is on one value, the query executes with success; > The case is specifically related to the query. > {code} > select SUM("JPVPricedSecurities"."ContractLine_Cost") as > "JPVPricedSecurities_Contract", > year("SRequestPerVendor"."SRequest_DateTime") as > "DAYOFMONTHSRequestPerVendor_" > from "DataMarketBusinessModel"."SRequestPerVendor" "SRequestPerVendor" > LEFT JOIN "DataMarketBusinessModel"."JPVPricedSecurities" "JPVPricedSecurities" ON "SRequestPerVendor"."SRequest_AssetID" = "JPVPricedSecurities"."Reply_AssetID" > LEFT JOIN "datamarketModel_MM"."datamarket"."Vendor" "Vendor" ON "JPVPricedSecurities"."Reply_VendorID" = "Vendor"."VendorID" > where ("JPVPricedSecurities"."Reply_VendorID" IN (10, 2) ) > AND ("Vendor"."Vendor" IS NOT null ) > group by > year("SRequestPerVendor"."SRequest_DateTime") > {code} > Here is the exception stack: > {code} > Daemon Thread [http-bio-8080-exec-2] (Suspended (exception NullPointerException)) > owns: Object (id=23929) > owns: SocketWrapper<E> (id=23848) > LanguageBridgeFactory.translate(DependentSetCriteria) line: 426 > LanguageBridgeFactory.translate(Criteria) line: 418 > LanguageBridgeFactory.translate(CompoundCriteria) line: 494 > LanguageBridgeFactory.translate(Criteria) line: 402 > LanguageBridgeFactory.translate(Query) line: 281 > LanguageBridgeFactory.translate(QueryCommand) line: 226 > LanguageBridgeFactory.translate(SubqueryFromClause) line: 386 > LanguageBridgeFactory.translate(FromClause) line: 344 > LanguageBridgeFactory.translate(Query) line: 276 > LanguageBridgeFactory.translate(Command) line: 184 > ConnectorWorkItem.<init>(AtomicRequestMessage, ConnectorManager) line: 175 > EmbeddedServer$ProviderAwareConnectorManagerRepository$1(ConnectorManager).registerRequest(AtomicRequestMessage) line: 203 > DataTierManagerImpl.registerRequest(CommandContext, Command, String, RegisterRequestParameter) line: 1011 > TempTableDataManager.registerRequest(CommandContext, Command, String, RegisterRequestParameter) line: 179 > DependentAccessNode(AccessNode).registerRequest(Command) line: 500 > DependentAccessNode(AccessNode).openInternal() line: 268 > DependentAccessNode(AccessNode).open() line: 171 > EnhancedSortMergeJoinStrategy(JoinStrategy).openRight() line: 105 > JoinNode.nextBatchDirect() line: 223 > JoinNode(RelationalNode).nextBatch() line: 282 > GroupingNode$ProjectingTupleSource(BatchCollector$BatchProducerTupleSource).nextTuple() line: 94 > GroupingNode.groupSortPhase() line: 490 > GroupingNode.nextBatchDirect() line: 366 > GroupingNode(RelationalNode).nextBatch() line: 282 > ProjectNode.nextBatchDirect() line: 150 > ProjectNode(RelationalNode).nextBatch() line: 282 > RelationalPlan.nextBatch() line: 145 > QueryProcessor.nextBatchDirect() line: 151 > QueryProcessor.nextBatch() line: 114 > RequestWorkItem$1(BatchCollector).collectTuples(boolean) line: 164 > RequestWorkItem$1(BatchCollector).collectTuples() line: 146 > RequestWorkItem.processMore() line: 472 > RequestWorkItem.process() line: 348 > RequestWorkItem(AbstractWorkItem).run() line: 51 > RequestWorkItem.run() line: 274 > DQPCore.executeRequest(long, RequestMessage, Long) line: 313 > DQPCore.executeRequest(long, RequestMessage) line: 245 > GeneratedMethodAccessor393.invoke(Object, Object[]) line: not available > DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: 43 > Method.invoke(Object, Object...) line: 606 > LocalServerConnection$1$1.call() line: 177 > FutureTask<V>.run() line: 262 > DQPWorkContext.runInContext(Runnable) line: 276 > DQPWorkContext.runInContext(Callable<V>) line: 260 > LocalServerConnection$1.invoke(Object, Method, Object[]) line: 175 > $Proxy29.executeRequest(long, RequestMessage) line: not available > StatementImpl.execute(RequestMessage, boolean) line: 673 > StatementImpl.executeSql(String[], boolean, ResultsMode, boolean, RequestOptions, boolean) line: 539 > StatementImpl.execute(String, int) line: 1060 > StatementImpl.execute(String) line: 323 > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5080) Teiid startup jdk9

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5080?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-5080. --------------------------------- > Teiid startup jdk9 > ------------------- > > Key: TEIID-5080 > URL: https://issues.jboss.org/browse/TEIID-5080 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 9.3.3 > Reporter: Lukáš Svačina > Assignee: Steven Hawkins > Attachments: stderr.txt, stdout.txt > > > Starting teiid 9.3.3 (with WildFly included) using java sdk 9 ends with several errors. See attached logs stdout/stderr. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4848) Google translator does not support ALL in DELETE

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4848?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4848. --------------------------------- > Google translator does not support ALL in DELETE > ------------------------------------------------ > > Key: TEIID-4848 > URL: https://issues.jboss.org/browse/TEIID-4848 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > > Query DELETE FROM SmallA WHERE IntKey > ALL (values(20)) throws exception (debug mode): > 08:05:50,812 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request 2md+OVeJxlHo.0 'TEIID30253 Source UPDATE or DELETE command "DELETE FROM Source.smalla WHERE intkey > ALL (SELECT 20)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. '. Originally QueryPlannerException RelationalPlanner.java:1187.: org.teiid.api.exception.query.QueryPlannerException: TEIID30253 Source UPDATE or DELETE command "DELETE FROM Source.smalla WHERE intkey > ALL (SELECT 20)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. > at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:205) [teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] > at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] > at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:442) [teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] > ... -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3955) When the JDBC MetadataProcessor is reverse engineering, don't fail the VDB when there are warning on the metadata load

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3955?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3955. --------------------------------- > When the JDBC MetadataProcessor is reverse engineering, don't fail the VDB when there are warning on the metadata load > ---------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-3955 > URL: https://issues.jboss.org/browse/TEIID-3955 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Minor > > When the JDBC metadata processor is reverse engineering the metadata and there are WARNINGS that it could not create the metadata for parts (not all) of the tables, then allow the VDB to be active, instead of failing it and making it inactive. Let the developer decide if what was not loaded requires further tuning of the import properties. Otherwise, the VDB may have what it needs. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4912) DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4912?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4912. --------------------------------- > DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE > ----------------------------------------------------- > > Key: TEIID-4912 > URL: https://issues.jboss.org/browse/TEIID-4912 > Project: Teiid > Issue Type: Quality Risk > Affects Versions: 9.3 > Reporter: Kylin Soong > Assignee: Steven Hawkins > > I tried to deploy VDB via ddl via embedded server, my ddl looks > {code} > CREATE DATABASE Portfolio; > CREATE GLOBAL TEMPORARY TABLE GTEMP (id SERIAL, name string, PRIMARY KEY (id)) OPTIONS (UPDATABLE 'true'); > {code} > But the deployment failed with trace: > {code} > Exception in thread "main" org.teiid.metadata.ParseException: TEIID31259 In the statement ending with token GTEMP on line 2 column 31 the ddl is not valid: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:567) > at org.teiid.metadatastore.DeploymentBasedDatabaseStore.getVDBMetadata(DeploymentBasedDatabaseStore.java:79) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:738) > at org.teiid.test.teiid4911.TEIID4911.main(TEIID4911.java:32) > Caused by: org.teiid.metadata.MetadataException: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. > at org.teiid.query.metadata.DatabaseStore.getCurrentDatabase(DatabaseStore.java:405) > at org.teiid.query.metadata.DatabaseStore.createMF(DatabaseStore.java:844) > at org.teiid.query.parser.SQLParser.createTable(SQLParser.java:14002) > at org.teiid.query.parser.SQLParser.ddlStmt(SQLParser.java:12596) > at org.teiid.query.parser.SQLParser.parseMetadata(SQLParser.java:12577) > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:561) > ... 3 more > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4897) Null pointer on ExecutionContext.getSubject().getPrincipals()

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4897?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4897. --------------------------------- > Null pointer on ExecutionContext.getSubject().getPrincipals() > ------------------------------------------------------------- > > Key: TEIID-4897 > URL: https://issues.jboss.org/browse/TEIID-4897 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.11 > Reporter: Rafael Coutinho > Assignee: Steven Hawkins > Priority: Minor > > Is there any configuration that would avoid my translator to get the user logged into the TEIID connection? > I'm extending the jdbc connector and during a query i want to get the currently logged user as displayed below. > However I always get null for getSubject. > @Override > public ResultSetExecution createResultSetExecution(QueryExpression command, ExecutionContext executionContext, RuntimeMetadata metadata, Connection conn) throws TranslatorException { > try { > System.out.println(executionContext.getSubject()); > System.out.println(executionContext.getSubject().getPrincipals()); > } catch (Exception e) { > System.err.println(e.getMessage()); > } > return new SagenceIonicTranslatorExecution(command, conn, executionContext, this); > } -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3732) Enable Infinispan-cache translator to negate intNum <> 1 returning true when column is null

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3732?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3732. --------------------------------- > Enable Infinispan-cache translator to negate intNum <> 1 returning true when column is null > -------------------------------------------------------------------------------------------- > > Key: TEIID-3732 > URL: https://issues.jboss.org/browse/TEIID-3732 > Project: Teiid > Issue Type: Feature Request > Components: JDG Connector > Reporter: Van Halbert > Assignee: Van Halbert > > This is related to TEIID-3573. To add a support option so that when the translator sees criteria like intNum<>1 it would need to produce "intNum<>1 and intNum IS NOT NULL". > This would negate the issue in JDG where it resolves intNum <> 1 to true when the column is null. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4948) java.lang.IllegalArgumentException: No marshaller registered for ispn.G1

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4948?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4948. --------------------------------- > java.lang.IllegalArgumentException: No marshaller registered for ispn.G1 > ------------------------------------------------------------------------ > > Key: TEIID-4948 > URL: https://issues.jboss.org/browse/TEIID-4948 > Project: Teiid > Issue Type: Bug > Components: Infinispan > Affects Versions: 9.3 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Fix For: 9.3.1 > > Attachments: jdg-remote-cache-ddl-vdb.xml > > > Deploying a VDB that contains 2 models with tables that reference the same JNDI, but defined different caches. (see vdb attached). > Can query both caches and based on results, I know they are not the same cache. > When performing an insert to the first table (G1) it works. When performing an insert to other table (G2), get the IllegalArgmentException. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 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 December 2017