[JBoss JIRA] (TEIID-4168) Odd resolving error with implicit temp groups
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4168?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4168.
---------------------------------
> Odd resolving error with implicit temp groups
> ---------------------------------------------
>
> Key: TEIID-4168
> URL: https://issues.jboss.org/browse/TEIID-4168
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.4
>
>
> If a query expression is used to insert into an implicit temporary table and no columns are specified the resolver will complain when the query column names do not match those defined on the implicit table. For example:
> insert into #tmp_dates ... defines the temp table ...
> insert into #tmp_dates select <some expression>
> Will complain that 'expr1' is not defined by #tmp_dates. Rather the column definitions should be assumed from the earlier statement.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4159) Hive translator - select distinct count(*) is not supported
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4159?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4159.
---------------------------------
> Hive translator - select distinct count(*) is not supported
> -----------------------------------------------------------
>
> Key: TEIID-4159
> URL: https://issues.jboss.org/browse/TEIID-4159
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 8.12.x
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5
>
>
> Hive does not support query like SELECT DISTINCT COUNT\(*\) ...
> Example query:
> SELECT DISTINCT COUNT\(*\) FROM Source.SmallA AS g_0
> Exception:
> {code:plain}
> 0:23:47,771 WARN [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue106) TEIID30020 Processing exception for request NRTyWX7OfkHZ.19 'TEIID30504 Source: 10128 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT COUNT(*) FROM smalla g_0]'. Originally TeiidProcessingException 'org.apache.hadoop.hive.ql.parse.SemanticException:Line 1:16 Not yet supported place for UDAF 'COUNT'' TypeCheckProcFactory.java:844.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 10128 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT COUNT(*) FROM smalla g_0]
> at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:374) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:470) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
> Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 10128 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT DISTINCT COUNT(*) FROM smalla g_0]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:359) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) [:1.8.0-internal]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal]
> at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at com.sun.proxy.$Proxy47.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> ... 6 more
> Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10128]: Line 1:16 Not yet supported place for UDAF 'COUNT'
> at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:258)
> at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:244)
> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:247)
> at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:378)
> at org.apache.hive.jdbc.HivePreparedStatement.executeQuery(HivePreparedStatement.java:109)
> at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
> ... 17 more
> Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10128]: Line 1:16 Not yet supported place for UDAF 'COUNT'
> at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:315)
> at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:112)
> at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:181)
> at org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:419)
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:406)
> at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:274)
> at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)
> at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1317)
> at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1302)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
> at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
> at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.8.0-internal]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.8.0-internal]
> ... 1 more
> Caused by: java.lang.RuntimeException: org.apache.hadoop.hive.ql.parse.SemanticException:Line 1:16 Not yet supported place for UDAF 'COUNT'
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.validateUDF(TypeCheckProcFactory.java:844)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprNodeDesc(TypeCheckProcFactory.java:979)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:1316)
> at org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:95)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:79)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:133)
> at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:110)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory.genExprNode(TypeCheckProcFactory.java:213)
> at org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory.genExprNode(TypeCheckProcFactory.java:157)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genAllExprNodeDesc(SemanticAnalyzer.java:10507)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:10463)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:10431)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:10425)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genGroupByPlanMapGroupByOperator(SemanticAnalyzer.java:4628)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genGroupByPlanMapAggrNoSkew(SemanticAnalyzer.java:5723)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:8883)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9743)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9636)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genOPTree(SemanticAnalyzer.java:10109)
> at org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:329)
> at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10120)
> at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:211)
> at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:227)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:456)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:316)
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1181)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1175)
> at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:110)
> ... 15 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4173) Using PI JDBC Adapter, server does not start up using simple queries
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4173?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4173.
---------------------------------
> Using PI JDBC Adapter, server does not start up using simple queries
> --------------------------------------------------------------------
>
> Key: TEIID-4173
> URL: https://issues.jboss.org/browse/TEIID-4173
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Driver
> Affects Versions: 8.13.3
> Environment: Issue was discovered using Windows Server 2012 OS and Teiid 8.13.3
> Reporter: Al S
> Assignee: Steven Hawkins
> Labels: JDBC, PI
>
> Using the following model along with the PI JDBC 2015 adapter, the error below was seen at startup of Wildfly.
> <vdb name="PIAF2" version="1">
> <description>OSIsoft PI AF</description>
> <model name="PIAF-Physical" type="PHYSICAL">
> <property name="importer.useFullSchemaName" value="false"/>
> <property name="importer.tableTypes" value="TABLE,VIEW"/>
> <source name="piaf-connector" translator-name="osisoft-pi" connection-jndi-name="java:/pi-ds"/>
> </model>
> <model name="PIAF-Virtual" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIEW IceDataTwo (
> tag varchar(max)
> ) AS
> select tag from pipoint.pipoint where tag='sinusoid'
> ]]> </metadata>
> </model>
> </vdb>
> Error:
> 21:26:59,420 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
> ol -- 61) WFLYCLINF0002: Started resultset cache from teiid container
> 21:26:59,514 WARN [org.teiid.RUNTIME] (Worker1_async-teiid-threads1) TEIID5003
> 6 VDB PIAF2.1 model "PIAF-Virtual" metadata failed to load. Reason:TEIID30386 or
> g.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Enco
> untered "tag varchar([*]max[*]) )" at line 3, column 25.
> Was expecting: <UNSIGNEDINTEGER>: org.teiid.metadata.ParseException: TEIID30386
> org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: En
> countered "tag varchar([*]max[*]) )" at line 3, column 25.
> Was expecting: <UNSIGNEDINTEGER>
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:768)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetada
> taRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadM
> etadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(Chai
> ningMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
> text.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.ru
> n(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseE
> xecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
> java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> .java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsin
> g error: Encountered "tag varchar([*]max[*]) )" at line 3, column 25.
> Was expecting: <UNSIGNEDINTEGER>
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser
> .java:214)
> ... 13 more
> 21:26:59,514 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
> ol -- 60) WFLYCLINF0002: Started resultset-repl cache from teiid container
> 21:26:59,529 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
> ol -- 62) WFLYCLINF0002: Started preparedplan cache from teiid container
> 21:27:00,732 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50001 Teii
> d Engine 8.13.3 Started = Mon Apr 25 21:27:00 PDT 2016
> 21:27:00,951 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50038 Teii
> d Embedded transport enabled. Bound to: teiid/queryengine/odata
> 21:27:00,998 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50038 Teii
> d Embedded transport enabled. Bound to: teiid/queryengine/embedded
> 21:27:01,748 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Deploying javax.ws.rs.core.Application: class org.teiid.odata.
> TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding class resource org.odata4j.producer.resources.MetadataR
> esource from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding provider class org.odata4j.producer.resources.ODataBatc
> hProvider from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding provider class org.teiid.odata.TeiidProducerProvider fr
> om Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding class resource org.odata4j.producer.resources.EntityReq
> uestResource from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding class resource org.odata4j.producer.resources.EntitiesR
> equestResource from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding provider class org.teiid.odata.ODataExceptionMappingPro
> vider from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
> read Pool -- 65) Adding class resource org.odata4j.producer.resources.ServiceDo
> cumentResource from Application class org.teiid.odata.TeiidODataApplication
> 21:27:01,951 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50012 Teii
> d JDBC - Name = jdbc, Host = 127.0.0.1, Port = 31000, SSL = OFF, security-domai
> ns = teiid-security
> 21:27:01,967 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50037 Teii
> d ODBC - Name = odbc, Host = 127.0.0.1, Port = 35432, SSL = OFF, security-domai
> ns = teiid-security
> 21:27:02,076 INFO [org.hibernate.validator.internal.util.Version] (ServerServic
> e Thread Pool -- 65) HV000001: Hibernate Validator 5.1.3.Final
> 21:27:02,592 INFO [org.teiid.CONNECTOR] (Worker0_async-teiid-threads0) PIExecu
> tionFactory Commit=true;DatabaseProductName=PI SQL Data Access Server 1.4.1.403
> using PIOLEDB;DatabaseProductVersion=PIOLEDB: 3.3.1.2;DriverMajorVersion=1;Drive
> rMajorVersion=4;DriverName=com.osisoft.jdbc.Driver;DriverVersion=1.4.1.404;Isola
> tionLevel=0
> 21:27:02,607 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -
> - 65) WFLYUT0021: Registered web context: /odata
> 21:27:02,795 INFO [org.jboss.as.server] (ServerService Thread Pool -- 35) WFLY
> SRV0010: Deployed "PIJDBCDriver.jar" (runtime-name : "PIJDBCDriver.jar")
> 21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool -- 35) WFLY
> SRV0010: Deployed "PIAF-vdb.xml" (runtime-name : "PIAF-vdb.xml")
> 21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool -- 55) WFLY
> SRV0010: Deployed "teiid-olingo-8.13.3-odata4.war" (runtime-name : "teiid-olingo
> -8.13.3-odata4.war")
> 21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool -- 55) WFLY
> SRV0010: Deployed "teiid-odata-8.13.3-odata2.war" (runtime-name : "teiid-odata-8
> .13.3-odata2.war")
> 21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http ma
> nagement interface listening on http://127.0.0.1:9990/management
> 21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin c
> onsole listening on http://127.0.0.1:9990
> 21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly
> Full 9.0.2.Final (WildFly Core 1.0.2.Final) started in 25094ms - Started 596 of
> 836 services (305 services are lazy, passive or on-demand)
> 21:27:03,920 WARN [org.teiid.RUNTIME] (Worker0_async-teiid-threads0) TEIID5003
> 6 VDB PIAF2.1 model "PIAF-Physical" metadata failed to load. Reason:TEIID11010 j
> ava.sql.SQLException: java.lang.Integer cannot be cast to java.lang.Short: org.t
> eiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: java.lang
> .Integer cannot be cast to java.lang.Short
> at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
> ionFactory.java:297)
> at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
> ionFactory.java:68)
> at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeM
> etadataRepository.java:92)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(Native
> MetadataRepository.java:60)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(Chai
> ningMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
> text.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.ru
> n(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseE
> xecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
> java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> .java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.sql.SQLException: java.lang.Integer cannot be cast to java.lang.
> Short
> at com.osisoft.jdbc.ResultSetImpl.getShort(ResultSetImpl.java:544)
> at org.teiid.translator.jdbc.JDBCMetdataProcessor.getPrimaryKeys(JDBCMet
> dataProcessor.java:495)
> at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(J
> DBCMetdataProcessor.java:162)
> at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
> ionFactory.java:295)
> ... 12 more
> 21:41:41,551 INFO [org.jboss.as.repository] (ServerService Thread Pool -- 63)
> WFLYDR0009: Content C:\apps\teiid-8.13.3\standalone\data\content\14\344c87647a15
> e57fe72a46b9754cd996f71dff is obsolete and will be removed
> 21:41:41,551 INFO [org.jboss.as.repository] (ServerService Thread Pool -- 63)
> WFLYDR0002: Content removed from location C:\apps\teiid-8.13.3\standalone\data\c
> ontent\14\344c87647a15e57fe72a46b9754cd996f71dff\content
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4157) Hive/Impala translator - Translators throw ClassCastException
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4157?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4157.
---------------------------------
> Hive/Impala translator - Translators throw ClassCastException
> -------------------------------------------------------------
>
> Key: TEIID-4157
> URL: https://issues.jboss.org/browse/TEIID-4157
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.x
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5
>
>
> Teiid throws following exception when SQL:
> *SQL*: SELECT a.IntKey FROM BQT1.smalla a UNION ALL SELECT b.IntKey FROM BQT2.Smallb b UNION ALL SELECT c.intkey FROM bqt1.smalla c
> *Result*:
> {code:text}
> 09:28:55,285 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue50) TEIID30019 Unexpected exception for request KrpIKq2zWp0r.7: java.lang.ClassCastException: org.teiid.language.SetQuery cannot be cast to org.teiid.language.Select
> at org.teiid.translator.hive.HiveSQLConversionVisitor.visit(HiveSQLConversionVisitor.java:158)
> at org.teiid.language.SetQuery.acceptVisitor(SetQuery.java:110) [teiid-api-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:91) [teiid-api-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:130)
> at org.teiid.translator.jdbc.TranslatedCommand.translateCommand(TranslatedCommand.java:76)
> at org.teiid.translator.jdbc.JDBCBaseExecution.translateCommand(JDBCBaseExecution.java:120)
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:114)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:359) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal]
> at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at com.sun.proxy.$Proxy47.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-3.jar:8.12.5.redhat-3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4258) Cannot connect to Teiid if server runs on JVM 1.6
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4258?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-4258:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1343956
Bugzilla Update: Perform
> Cannot connect to Teiid if server runs on JVM 1.6
> -------------------------------------------------
>
> Key: TEIID-4258
> URL: https://issues.jboss.org/browse/TEIID-4258
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.5
> Environment: JVM 1.6
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Blocker
>
> If Teiid runs on JVM 1.6. connection fails with EOFException \[1\]
> \[1\] Exception thrown (used squirrel client)
> {code:plain}
> java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:206)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:744)
> Caused by: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
> ... 5 more
> Caused by: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
> at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)
> at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
> at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
> ... 7 more
> Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161)
> at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)
> at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316)
> at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64)
> ... 11 more
> Caused by: java.io.EOFException
> at java.io.DataInputStream.readInt(DataInputStream.java:392)
> at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97)
> at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365)
> at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117)
> at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:128)
> at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:96)
> at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277)
> at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239)
> at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
> ... 14 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-3929) Accumulo does not return null values
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3929?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3929:
------------------------------------------------
Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1301527|https://bugzilla.redhat.com/show_bug.cgi?id=1301527] from ON_QA to ASSIGNED
> Accumulo does not return null values
> ------------------------------------
>
> Key: TEIID-3929
> URL: https://issues.jboss.org/browse/TEIID-3929
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.3
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
> Fix For: 9.0, 8.12.5
>
>
> Accumulo doesn't return null values when a whole 'column' is being selected.
> For a command in accumulo shell like:
> {code:plain}
> scan -c name:BYTENUM
> {code}
> Accumulo returns only non-empty values, this is expected behaviour.
> Equivalent query in Teiid would be:
> {code:sql}
> SELECT ByteNum FROM SmallA
> {code}
> Which returns the same results as Accumulo does. That means, no NULL values, if there are rowids without specified column families/qualifiers missing. But when a user has his schema defined in a vdb, he probably expects, that he will get as many rows as there are in the table.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4258) Cannot connect to Teiid if server runs on JVM 1.6
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-4258:
-----------------------------------
Summary: Cannot connect to Teiid if server runs on JVM 1.6
Key: TEIID-4258
URL: https://issues.jboss.org/browse/TEIID-4258
Project: Teiid
Issue Type: Bug
Affects Versions: 8.12.5
Environment: JVM 1.6
Reporter: Juraj Duráni
Assignee: Steven Hawkins
Priority: Blocker
If Teiid runs on JVM 1.6. connection fails with EOFException \[1\]
\[1\] Exception thrown (used squirrel client)
{code:plain}
java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
... 5 more
Caused by: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 7 more
Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161)
at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)
at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64)
... 11 more
Caused by: java.io.EOFException
at java.io.DataInputStream.readInt(DataInputStream.java:392)
at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365)
at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117)
at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:128)
at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:96)
at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277)
at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239)
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)
... 14 more
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-3929) Accumulo does not return null values
by Jan Stastny (JIRA)
[ https://issues.jboss.org/browse/TEIID-3929?page=com.atlassian.jira.plugin... ]
Jan Stastny reopened TEIID-3929:
--------------------------------
The problem is still there.
If I select only nullable column, there are no NULL values returned, even though they should. Such query:
{code:sql}
SELECT bytenum FROM bqt1.smalla;
{code} returns 47 rows.
When I add a column, which in fact is a mapped rowid from accumulo table, I get same number of results - no NULLs returned:
{code:sql}
SELECT intkey,bytenum FROM bqt1.smalla;
{code} returns 47 rows.
Even though the query on the 'rowid' column:
{code:sql}
SELECT intkey FROM bqt1.smallA;
{code} returns 50 rows.
But when I select with not nullable column (stringkey), which is not the rowid in accumulo, I get correct results.
{code:sql}
SELECT stringkey,bytenum FROM bqt1.smalla;
{code} returns 50 rows with null values.
> Accumulo does not return null values
> ------------------------------------
>
> Key: TEIID-3929
> URL: https://issues.jboss.org/browse/TEIID-3929
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.3
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
> Fix For: 9.0, 8.12.5
>
>
> Accumulo doesn't return null values when a whole 'column' is being selected.
> For a command in accumulo shell like:
> {code:plain}
> scan -c name:BYTENUM
> {code}
> Accumulo returns only non-empty values, this is expected behaviour.
> Equivalent query in Teiid would be:
> {code:sql}
> SELECT ByteNum FROM SmallA
> {code}
> Which returns the same results as Accumulo does. That means, no NULL values, if there are rowids without specified column families/qualifiers missing. But when a user has his schema defined in a vdb, he probably expects, that he will get as many rows as there are in the table.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months