[JBoss JIRA] (TEIID-3238) Cassandra: Access to Cassandra fails with CNF "sun/misc/Unsafe"
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3238?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-3238.
---------------------------------
Labels: alpha2 (was: )
Resolution: Done
added the missing module
> Cassandra: Access to Cassandra fails with CNF "sun/misc/Unsafe"
> ---------------------------------------------------------------
>
> Key: TEIID-3238
> URL: https://issues.jboss.org/browse/TEIID-3238
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Labels: alpha2
> Fix For: 8.10
>
>
> new connection: null: java.lang.NoClassDefFoundError: sun/misc/Unsafe
> at com.codahale.metrics.Striped64.getUnsafe(Striped64.java:330) [metrics-core-3.0.2.jar:3.0.2]
> at com.codahale.metrics.Striped64.<clinit>(Striped64.java:311) [metrics-core-3.0.2.jar:3.0.2]
> at com.codahale.metrics.Counter.<init>(Counter.java:10) [metrics-core-3.0.2.jar:3.0.2]
> at com.codahale.metrics.MetricRegistry$MetricBuilder$1.newMetric(MetricRegistry.java:402) [metrics-core-3.0.2.jar:3.0.2]
> at com.codahale.metrics.MetricRegistry$MetricBuilder$1.newMetric(MetricRegistry.java:399) [metrics-core-3.0.2.jar:3.0.2]
> at com.codahale.metrics.MetricRegistry.getOrAdd(MetricRegistry.java:313) [metrics-core-3.0.2.jar:3.0.2]
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-3238) Cassandra: Access to Cassandra fails with CNF "sun/misc/Unsafe"
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIID-3238:
-----------------------------------
Summary: Cassandra: Access to Cassandra fails with CNF "sun/misc/Unsafe"
Key: TEIID-3238
URL: https://issues.jboss.org/browse/TEIID-3238
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Fix For: 8.10
new connection: null: java.lang.NoClassDefFoundError: sun/misc/Unsafe
at com.codahale.metrics.Striped64.getUnsafe(Striped64.java:330) [metrics-core-3.0.2.jar:3.0.2]
at com.codahale.metrics.Striped64.<clinit>(Striped64.java:311) [metrics-core-3.0.2.jar:3.0.2]
at com.codahale.metrics.Counter.<init>(Counter.java:10) [metrics-core-3.0.2.jar:3.0.2]
at com.codahale.metrics.MetricRegistry$MetricBuilder$1.newMetric(MetricRegistry.java:402) [metrics-core-3.0.2.jar:3.0.2]
at com.codahale.metrics.MetricRegistry$MetricBuilder$1.newMetric(MetricRegistry.java:399) [metrics-core-3.0.2.jar:3.0.2]
at com.codahale.metrics.MetricRegistry.getOrAdd(MetricRegistry.java:313) [metrics-core-3.0.2.jar:3.0.2]
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-2932) Datastax: fail to access PortfolioDemo (demo schema that provided by Datastax)
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2932?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-2932.
---------------------------------
Fix Version/s: 8.10
Resolution: Cannot Reproduce Bug
I tried with Datastax sandbox version 2.0.8.39 and also downloading the Cassandra directly from Apache version 2.1.2, in both of them I created the above schema and deployed VDB and failed to re-create the error described in this JIRA. This may be out of date, but I am marking as can not reproduce.
If you can re-produce, please re-open with correct version numbers of both JAVA driver and Cassandra driver.
> Datastax: fail to access PortfolioDemo (demo schema that provided by Datastax)
> -------------------------------------------------------------------------------
>
> Key: TEIID-2932
> URL: https://issues.jboss.org/browse/TEIID-2932
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7
> Environment: Datastax with Teiid 8.7 CR
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Fix For: 8.10
>
>
> Fail to access PortfolioDemo (demo schema that provided by Datastax) and the the following exception:
> java.lang.NullPointerException
> at org.teiid.metadata.MetadataFactory.addColumn(MetadataFactory.java:204)
> at org.teiid.translator.cassandra.CassandraMetadataProcessor.addColumnsToTable(CassandraMetadataProcessor.java:101)
> at org.teiid.translator.cassandra.CassandraMetadataProcessor.addTable(CassandraMetadataProcessor.java:63)
> at org.teiid.translator.cassandra.CassandraMetadataProcessor.process(CassandraMetadataProcessor.java:50)
> at org.teiid.translator.cassandra.CassandraMetadataProcessor.process(CassandraMetadataProcessor.java:42)
> at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:915)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:685)
> at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:161)
> at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:635)
> at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:547)
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-3227) Add support for sub-expression pushing of must pushdown functions
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3227?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3227.
-----------------------------------
Resolution: Done
Added more support for pushing expressions more selectively. We'll now include arguments to aggregate functions and grouping expressions.
This is just an extension of the existing logic and is not yet fully symbolic, that is we are dealing with whole projections at the point in time they are used in the grouping or project node. It will take more work to fully factor sub-expressions (more than likely replacing with an expression symbol).
> Add support for sub-expression pushing of must pushdown functions
> -----------------------------------------------------------------
>
> Key: TEIID-3227
> URL: https://issues.jboss.org/browse/TEIID-3227
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 8.9
> Reporter: Michał Warecki
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 8.10
>
>
> As a user I'd like to have a possibility to push down sub-expressions of must pushdown functions.
> Example:
> Input query with not supported group by:
> SELECT AAA, SUM(custom_function(BBB)) AS BBB_ALIAS FROM some_table WHERE some_table.CCC = 'VAL' GROUP BY AAA ORDER BY AAA
>
> Output query (processed by teiid):
> SELECT AAA, BBB AS BBB_ALIAS FROM some_table.CCC = 'VAL'
>
> What I think it should looks like:
> SELECT AAA, custom_function(BBB) AS BBB_ALIAS FROM some_table.CCC = 'VAL'
> https://developer.jboss.org/message/910926#910926
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-2882) Add support for Presto DB
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2882?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-2882.
---------------------------------
Labels: Alpha2 (was: )
Resolution: Done
Added support 0.85 version of PrestoDB. This translator extends JDBC translator and uses PrestoDB JDBC driver for connection.
When issue [https://github.com/facebook/presto/issues/2031] is resolved then we can delete the JDBC driver JAR file checked in with commit and pull from a maven repo.
> Add support for Presto DB
> -------------------------
>
> Key: TEIID-2882
> URL: https://issues.jboss.org/browse/TEIID-2882
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Labels: Alpha2
> Fix For: 8.10
>
>
> Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
> Presto was designed and written from the ground up for interactive analytics and approaches the speed of commercial data warehouses while scaling to the size of organizations like Facebook.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-3235) IndexOutOfBoundsException when using GROUP BY
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3235?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3235:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1167875|https://bugzilla.redhat.com/show_bug.cgi?id=1167875] from NEW to MODIFIED
> IndexOutOfBoundsException when using GROUP BY
> ---------------------------------------------
>
> Key: TEIID-3235
> URL: https://issues.jboss.org/browse/TEIID-3235
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Labels: Alpha1
> Fix For: 8.7.1, 8.10
>
> Attachments: mongo-vdb.xml
>
>
> Issuing the following queries that cause the IndexOutofBoundsException:
> SELECT IntKey, SUM(IntNum) FROM BQT1.SmallA GROUP BY intKey
> SELECT IntKey, IntNum FROM BQT1.SmallA GROUP BY IntKey, IntNum
> Will attach VDB.
> 0:07:04,905 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue14) Connector worker process failed for atomic-request=XEIlvkzunTej.7.1.0: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
> at java.util.ArrayList.rangeCheck(ArrayList.java:604) [rt.jar:1.7.0_25]
> at java.util.ArrayList.get(ArrayList.java:382) [rt.jar:1.7.0_25]
> at org.teiid.translator.mongodb.MongoDBQueryExecution.next(MongoDBQueryExecution.java:124)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:384) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:202) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.redhat-5.jar:8.7.1.redhat-5]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months
[JBoss JIRA] (TEIID-2890) IndexOutOfBoundsException when using GROUP BY
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2890?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2890:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1167875|https://bugzilla.redhat.com/show_bug.cgi?id=1167875] from NEW to MODIFIED
> IndexOutOfBoundsException when using GROUP BY
> ---------------------------------------------
>
> Key: TEIID-2890
> URL: https://issues.jboss.org/browse/TEIID-2890
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.4
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
> Labels: 8.7, grouping, translator
> Fix For: 8.7
>
>
> I have a translator that does not support aggregates or grouping. I am using a view to try to normalize data from several sources. I am duplicating some of the fields as an approximation. I have existing software that is querying with GROUP BY, and sometimes this happens.
> This query works fine in 8.6:
> {code:sql}
> select identifier
> from foo.items
> group by identifier, identifier;
> {code}
> In 8.7 this happens:
> {code}
> 10:15:24,280 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue39) njknuxobPkVY TEIID30019 Unexpected exception for request njknuxobPkVY.3: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
> at java.util.ArrayList.rangeCheck(ArrayList.java:604) [rt.jar:1.7.0_02]
> at java.util.ArrayList.get(ArrayList.java:382) [rt.jar:1.7.0_02]
> at org.teiid.query.processor.relational.MergeJoinStrategy.compareTuples(MergeJoinStrategy.java:313) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.GroupingNode.sameGroup(GroupingNode.java:488) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.GroupingNode.groupPhase(GroupingNode.java:414) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:336) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:273) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.7.0.Beta2-SNAPSHOT.jar:8.7.0.Beta2-SNAPSHOT]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_02]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_02]
> at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_02]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 4 months