March 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3058) Cassandra: cannot compare timestamp field in where clause

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-3058?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-3058: ---------------------------------- I think the issue is that Teiid translates date format from '2013-05-01 00:00:00' to ts'2013-05-01 00:00:00.0'. And cassandra doesn't recognize this kind of format, ts'2013-05-01 00:00:00.0'. Thanks. > Cassandra: cannot compare timestamp field in where clause > ---------------------------------------------------------- > > Key: TEIID-3058 > URL: https://issues.jboss.org/browse/TEIID-3058 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7, 8.10 > Environment: Cassandra with Teiid 8.7 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > It seems like Teiid is having problem to compare translate CQL if there is timestamp comparison in where clause: > ORIGINAL SQL: > select "cassandrads_sales"."product_family" as "cassandrads_sales_product_family", > "cassandrads_sales"."product_family" as "cassandrads_sales_product_family1" > from "cassandrads"."sales" "cassandrads_sales" > where "cassandrads_sales"."the_date" <= '2013-05-01 00:00:00' > limit 1000 > TRANSLATED CQL: > SELECT cassandrads.sales.product_family FROM cassandrads.sales WHERE cassandrads.sales.the_date <= {ts'2013-05-01 00:00:00.0'} LIMIT 1000 > And I got this error: > Caused by: org.teiid.translator.TranslatorException: line 1:55 no viable alternative at input '2013-05-01 00:00:0 > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:80) > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:72) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:135) > If it is not possible to do time/ data comparison for CQL, maybe you guys should consider to do it in memory instead. Thanks. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3058) Cassandra: cannot compare timestamp field in where clause

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-3058?page=com.atlassian.jira.plugin... ] Ivan Chan updated TEIID-3058: ----------------------------- Affects Version/s: 8.10 > Cassandra: cannot compare timestamp field in where clause > ---------------------------------------------------------- > > Key: TEIID-3058 > URL: https://issues.jboss.org/browse/TEIID-3058 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7, 8.10 > Environment: Cassandra with Teiid 8.7 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > It seems like Teiid is having problem to compare translate CQL if there is timestamp comparison in where clause: > ORIGINAL SQL: > select "cassandrads_sales"."product_family" as "cassandrads_sales_product_family", > "cassandrads_sales"."product_family" as "cassandrads_sales_product_family1" > from "cassandrads"."sales" "cassandrads_sales" > where "cassandrads_sales"."the_date" <= '2013-05-01 00:00:00' > limit 1000 > TRANSLATED CQL: > SELECT cassandrads.sales.product_family FROM cassandrads.sales WHERE cassandrads.sales.the_date <= {ts'2013-05-01 00:00:00.0'} LIMIT 1000 > And I got this error: > Caused by: org.teiid.translator.TranslatorException: line 1:55 no viable alternative at input '2013-05-01 00:00:0 > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:80) > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:72) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:135) > If it is not possible to do time/ data comparison for CQL, maybe you guys should consider to do it in memory instead. Thanks. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3058) Cassandra: cannot compare timestamp field in where clause

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-3058?page=com.atlassian.jira.plugin... ] Ivan Chan reopened TEIID-3058: ------------------------------ I still can reproduce this issue using Teiid 8.10 > Cassandra: cannot compare timestamp field in where clause > ---------------------------------------------------------- > > Key: TEIID-3058 > URL: https://issues.jboss.org/browse/TEIID-3058 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7, 8.10 > Environment: Cassandra with Teiid 8.7 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > It seems like Teiid is having problem to compare translate CQL if there is timestamp comparison in where clause: > ORIGINAL SQL: > select "cassandrads_sales"."product_family" as "cassandrads_sales_product_family", > "cassandrads_sales"."product_family" as "cassandrads_sales_product_family1" > from "cassandrads"."sales" "cassandrads_sales" > where "cassandrads_sales"."the_date" <= '2013-05-01 00:00:00' > limit 1000 > TRANSLATED CQL: > SELECT cassandrads.sales.product_family FROM cassandrads.sales WHERE cassandrads.sales.the_date <= {ts'2013-05-01 00:00:00.0'} LIMIT 1000 > And I got this error: > Caused by: org.teiid.translator.TranslatorException: line 1:55 no viable alternative at input '2013-05-01 00:00:0 > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:80) > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:72) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:135) > If it is not possible to do time/ data comparison for CQL, maybe you guys should consider to do it in memory instead. Thanks. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3393) Add an adminapi interface impl for embedded

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3393?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-3393: ------------------------------- Git Pull Request: https://github.com/teiid/teiid/pull/436 > Add an adminapi interface impl for embedded > ------------------------------------------- > > Key: TEIID-3393 > URL: https://issues.jboss.org/browse/TEIID-3393 > Project: Teiid > Issue Type: Feature Request > Components: Embedded > Reporter: Steven Hawkins > Assignee: Kylin Soong > Fix For: 8.11 > > > For as many methods as seems reasonable we should implement the adminapi interface for embedded. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3408) Update the quickstarts that refer to using user .properties files and user roles files

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3408?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3408: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1190678 > Update the quickstarts that refer to using user .properties files and user roles files > -------------------------------------------------------------------------------------- > > Key: TEIID-3408 > URL: https://issues.jboss.org/browse/TEIID-3408 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > > Update the quoickstarts that still refer to using user security .properties and user roles files. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3408) Update the quickstarts that refer to using user .properties files and user roles files

by Van Halbert (JIRA)

Van Halbert created TEIID-3408: ---------------------------------- Summary: Update the quickstarts that refer to using user .properties files and user roles files Key: TEIID-3408 URL: https://issues.jboss.org/browse/TEIID-3408 Project: Teiid Issue Type: Bug Components: Quick Starts Reporter: Van Halbert Assignee: Van Halbert Priority: Minor Update the quoickstarts that still refer to using user security .properties and user roles files. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3407) Clarify in the README's for each quickstart regarding how to start the server

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3407?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-3407. -------------------------------- Resolution: Done > Clarify in the README's for each quickstart regarding how to start the server > ----------------------------------------------------------------------------- > > Key: TEIID-3407 > URL: https://issues.jboss.org/browse/TEIID-3407 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Trivial > > Change the start command in the README's to be the following: > To start the server, open a command line and navigate to the "bin" directory under the root directory of the JBoss server and run: > > For Linux: ./standalone.sh > for Windows: standalone.bat > append the following to the command to indicate which configuration to use if Teiid isn't configured in the default configuration > > -c standalone-teiid.xml -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3407) Clarify in the README's for each quickstart regarding how to start the server

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3407?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3407: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1190678 > Clarify in the README's for each quickstart regarding how to start the server > ----------------------------------------------------------------------------- > > Key: TEIID-3407 > URL: https://issues.jboss.org/browse/TEIID-3407 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Trivial > > Change the start command in the README's to be the following: > To start the server, open a command line and navigate to the "bin" directory under the root directory of the JBoss server and run: > > For Linux: ./standalone.sh > for Windows: standalone.bat > append the following to the command to indicate which configuration to use if Teiid isn't configured in the default configuration > > -c standalone-teiid.xml -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3407) Clarify in the README's for each quickstart regarding how to start the server

by Van Halbert (JIRA)

Van Halbert created TEIID-3407: ---------------------------------- Summary: Clarify in the README's for each quickstart regarding how to start the server Key: TEIID-3407 URL: https://issues.jboss.org/browse/TEIID-3407 Project: Teiid Issue Type: Enhancement Components: Quick Starts Reporter: Van Halbert Assignee: Van Halbert Priority: Trivial Change the start command in the README's to be the following: To start the server, open a command line and navigate to the "bin" directory under the root directory of the JBoss server and run: For Linux: ./standalone.sh for Windows: standalone.bat append the following to the command to indicate which configuration to use if Teiid isn't configured in the default configuration -c standalone-teiid.xml -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3406) Upgrade quickstarts to use Teiid 8.10.0-Final and use IP BOM 26

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3406?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3406: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1190683|https://bugzilla.redhat.com/show_bug.cgi?id=1190683] from NEW to MODIFIED > Upgrade quickstarts to use Teiid 8.10.0-Final and use IP BOM 26 > --------------------------------------------------------------- > > Key: TEIID-3406 > URL: https://issues.jboss.org/browse/TEIID-3406 > Project: Teiid > Issue Type: Task > Components: Quick Starts > Reporter: Van Halbert > Assignee: Van Halbert > > Upgrade quickstarts to be based on IP Bom 26 and Teiid 8.10.0-Fina. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2015