[JBoss JIRA] (TEIID-2916) HIVE2: Teiid didn't translate the SQL correctly for numeric field
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2916?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2916.
---------------------------------
> HIVE2: Teiid didn't translate the SQL correctly for numeric field
> ------------------------------------------------------------------
>
> Key: TEIID-2916
> URL: https://issues.jboss.org/browse/TEIID-2916
> Project: Teiid
> Issue Type: Sub-task
> Components: Misc. Connectors
> Affects Versions: 8.6
> Environment: HIVE2 with Teiid
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Labels: Teiid, alpha1
> Fix For: 8.8, 8.7.1
>
>
> Teiid didn't translate the SQL correctly for numeric field. It uses identifier "decimal" in the SQL which is not supported by the driver.
> Original Query:
> select "store_sales",
> "store_state",
> "store_country"
> from "Impala"."sales_new"
> where "store_sales" between 1.5 and 10
> limit 1000
> After Translation (Teiid):
> SELECT g_0.store_sales AS c_0, g_0.store_state AS c_
> 1, g_0.store_country AS c_2 FROM sales_new g_0 WHERE cast(g_0.store_sales AS
> decimal) >= 1.5 AND cast(g_0.store_sales AS decimal) <= 10 LIMIT 1000
> "decimal" is not supported identifier in HIVE driver:
> Encountered: IDENTIFIER
> Expected: BIGINT, BOOLEAN, DATE, DATETIME, REAL, FLOAT, INTEGER, SMALLINT,
> STRING, TIMESTAMP, TINYINT
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3206:
---------------------------------------
Should be addressed by TEIID-3371
> EAP 6.3 - JDBC Datasources Test Connection
> ------------------------------------------
>
> Key: TEIID-3206
> URL: https://issues.jboss.org/browse/TEIID-3206
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 8.9, 8.10
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
>
> Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1.
> This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources.
> The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3371) Upgrade Teiid with EAP 6.4 Alpha
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3371?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3371:
------------------------------------
Also, something that I need to do is clean up the transient dependencies so that the illegaltransitivereportonly property can be set to false.
> Upgrade Teiid with EAP 6.4 Alpha
> --------------------------------
>
> Key: TEIID-3371
> URL: https://issues.jboss.org/browse/TEIID-3371
> Project: Teiid
> Issue Type: Enhancement
> Components: Build/Kits
> Affects Versions: 8.11
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
>
> Upgrade all the Teiid projects to be built based on EAP 6.4 Alpha. Currently, this would align with jboss-integration-platform-bom 6.0.0.CR25 and EAP Alpha version 7.5.0.Final-redhat-17. Note, 7.5.0.Final-redhat-17 is the version in the EAP kit, but only CR25 bom is available.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3373) Add an org.teiid logging context in the config
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3373:
-------------------------------------
Summary: Add an org.teiid logging context in the config
Key: TEIID-3373
URL: https://issues.jboss.org/browse/TEIID-3373
Project: Teiid
Issue Type: Quality Risk
Components: Server
Reporter: Steven Hawkins
Assignee: Van Halbert
Fix For: 8.11
It would be convenient to have an existing org.teiid entry in the logging config to allow admins to quickly enabled debug/trace logging.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIID-3372) Support multiple metadata tags
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3372:
-------------------------------------
Summary: Support multiple metadata tags
Key: TEIID-3372
URL: https://issues.jboss.org/browse/TEIID-3372
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.11
To allow for a more flexible configuration, we should support multiple metadata tags under a model, rather than relying on comma separated values.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month