[JBoss JIRA] (TEIID-3174) integer operation within LEFT command
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3174?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3174:
---------------------------------------
Can you clarify the intent of issue? The error message is saying that a -1 count is invalid, which means that your locate is not finding a comma.
> integer operation within LEFT command
> -------------------------------------
>
> Key: TEIID-3174
> URL: https://issues.jboss.org/browse/TEIID-3174
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
> Labels: left, stringfunction
>
> When executing a command of the following form
> LEFT(Description,((LOCATE(',',Description))-1))
> I get an Exception like this:
> 14:31:00,038 WARN [org.teiid.PROCESSOR] (Worker3295_QueryProcessorQueue53347) 5tz38FpQ/WJw TEIID30020 Processing exception for request 5tz38FpQ/WJw.50 'TEIID30328 Unable to evaluate LEFT(sometable.Description, (LOCATE(',', sometable.Description) - 1)): TEIID30384 Error while evaluating function left'. Originally ExpressionEvaluationException 'TEIID30396 Left/Right count -1 is invalid. It must be >= 0.' FunctionMethods.java:758. Enable more detailed logging to see the entire stacktrace.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 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 reassigned TEIID-2932:
-----------------------------------
Assignee: Ramesh Reddy
> 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
>
> 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.1#6329)
9 years, 8 months
[JBoss JIRA] (TEIID-3174) integer operation within LEFT command
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIID-3174:
-----------------------------------
Summary: integer operation within LEFT command
Key: TEIID-3174
URL: https://issues.jboss.org/browse/TEIID-3174
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
When executing a command of the following form
LEFT(Description,((LOCATE(',',Description))-1))
I get an Exception like this:
14:31:00,038 WARN [org.teiid.PROCESSOR] (Worker3295_QueryProcessorQueue53347) 5tz38FpQ/WJw TEIID30020 Processing exception for request 5tz38FpQ/WJw.50 'TEIID30328 Unable to evaluate LEFT(sometable.Description, (LOCATE(',', sometable.Description) - 1)): TEIID30384 Error while evaluating function left'. Originally ExpressionEvaluationException 'TEIID30396 Left/Right count -1 is invalid. It must be >= 0.' FunctionMethods.java:758. Enable more detailed logging to see the entire stacktrace.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 months
[JBoss JIRA] (TEIID-2882) Add support for Presto DB
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2882?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2882:
----------------------------------
Fix Version/s: 8.10
(was: 8.9)
> 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
> 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.1#6329)
9 years, 8 months