[JBoss JIRA] (TEIIDDES-1905) TrimColumn names should be enabled with hive translator metadata import
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1905?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1905:
----------------------------------------
Per TEIID-2524 comments this should not be issue with 0.11 driver, is that not true?
Also, import properties generally currently considered as user driven activity with this importer, so there no clean mechanism to add default import properties.
> TrimColumn names should be enabled with hive translator metadata import
> -----------------------------------------------------------------------
>
> Key: TEIIDDES-1905
> URL: https://issues.jboss.org/browse/TEIIDDES-1905
> Project: Teiid Designer
> Issue Type: Bug
> Environment: DV Beta
> Teiid Designer 8.3.Beta2
> Reporter: Filip Nguyen
>
> *Problem*
> Importing Hive Tables, when using Teiid Connection >> Source model, is introducing padding spaces into column names.
> *Why*
> There is a problem with Hive 0.11 driver which introduces padding spaces into metadata (data types and column names). The problem has been resolved (TEIID-2524) but it is necessary that dynamic VDBs that import this metadata use importer property trimColumnNames property set to true. So it is probably needed to add this property to importVDB-vdb.xml in the case of hive translator import in the Designer.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1906) Execute VDB fails for Salesforce model
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1906?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1906:
----------------------------------------
Check the JNDI name you choose for the source model when you created the VDB, it must point to a Sales Force connection.
> Execute VDB fails for Salesforce model
> --------------------------------------
>
> Key: TEIIDDES-1906
> URL: https://issues.jboss.org/browse/TEIIDDES-1906
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.2
> Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV 6.0.ER2 with teiid 8.4
> Reporter: Lucie Fabrikova
>
> 1. create a source model by importing from testing Salesforce account; preview data of one table (Modeling -> Preview data) - this works (select * from "sf"."salesforce"."Account")
> 2. create a VDB with the source model; deploy, execute (use the same sql query) - this results in a error:
> org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> Console output:
> 13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> 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.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> 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]
> 13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019 Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
> at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> 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.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1906) Execute VDB fails for Salesforce model
by Lucie Fabrikova (JIRA)
Lucie Fabrikova created TEIIDDES-1906:
-----------------------------------------
Summary: Execute VDB fails for Salesforce model
Key: TEIIDDES-1906
URL: https://issues.jboss.org/browse/TEIIDDES-1906
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 8.2
Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV 6.0.ER2 with teiid 8.4
Reporter: Lucie Fabrikova
1. create a source model by importing from testing Salesforce account; preview data of one table (Modeling -> Preview data) - this works (select * from "sf"."salesforce"."Account")
2. create a VDB with the source model; deploy, execute (use the same sql query) - this results in a error:
org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
Console output:
13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
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.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
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]
13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019 Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException: org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to org.teiid.translator.salesforce.SalesforceConnection
at org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304) [teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
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.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1905) TrimColumn names should be enabled with hive translator metadata import
by Filip Nguyen (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1905?page=com.atlassian.jira.plu... ]
Filip Nguyen updated TEIIDDES-1905:
-----------------------------------
Description:
*Problem*
Importing Hive Tables, when using Teiid Connection >> Source model, is introducing padding spaces into column names.
*Why*
There is a problem with Hive 0.11 driver which introduces padding spaces into metadata (data types and column names). The problem has been resolved (TEIID-2524) but it is necessary that dynamic VDBs that import this metadata use importer property trimColumnNames property set to true. So it is probably needed to add this property to importVDB-vdb.xml in the case of hive translator import in the Designer.
was:
*Problem*
Importing Hive Tables, when using Teiid Connection >> Source model, is introducing padding spaces into column names.
*Why*
There is a problem with Hive 0.11 driver which introduces padding spaces into metadata (data types and column names). The problem has been resolved (TEIID-2524) but it is necessary that dynamic VDBs that import this metadata use importer property trimColumnNames property set to true. So it is probably needed to add this property to importVDB-vdb.xml in the case of hive translator import.
> TrimColumn names should be enabled with hive translator metadata import
> -----------------------------------------------------------------------
>
> Key: TEIIDDES-1905
> URL: https://issues.jboss.org/browse/TEIIDDES-1905
> Project: Teiid Designer
> Issue Type: Bug
> Environment: DV Beta
> Teiid Designer 8.3.Beta2
> Reporter: Filip Nguyen
>
> *Problem*
> Importing Hive Tables, when using Teiid Connection >> Source model, is introducing padding spaces into column names.
> *Why*
> There is a problem with Hive 0.11 driver which introduces padding spaces into metadata (data types and column names). The problem has been resolved (TEIID-2524) but it is necessary that dynamic VDBs that import this metadata use importer property trimColumnNames property set to true. So it is probably needed to add this property to importVDB-vdb.xml in the case of hive translator import in the Designer.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1905) TrimColumn names should be enabled with hive translator metadata import
by Filip Nguyen (JIRA)
Filip Nguyen created TEIIDDES-1905:
--------------------------------------
Summary: TrimColumn names should be enabled with hive translator metadata import
Key: TEIIDDES-1905
URL: https://issues.jboss.org/browse/TEIIDDES-1905
Project: Teiid Designer
Issue Type: Bug
Environment: DV Beta
Teiid Designer 8.3.Beta2
Reporter: Filip Nguyen
*Problem*
Importing Hive Tables, when using Teiid Connection >> Source model, is introducing padding spaces into column names.
*Why*
There is a problem with Hive 0.11 driver which introduces padding spaces into metadata (data types and column names). The problem has been resolved (TEIID-2524) but it is necessary that dynamic VDBs that import this metadata use importer property trimColumnNames property set to true. So it is probably needed to add this property to importVDB-vdb.xml in the case of hive translator import.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1885) DDL importer problems for both source and view models
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1885?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-1885:
---------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1016553|https://bugzilla.redhat.com/show_bug.cgi?id=1016553] from ASSIGNED to CLOSED
> DDL importer problems for both source and view models
> ------------------------------------------------------
>
> Key: TEIIDDES-1885
> URL: https://issues.jboss.org/browse/TEIIDDES-1885
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.2
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.3
>
> Attachments: stdcust.ddl
>
>
> When Importing from DDL to create a new view model (DDL File >> Source or View model), the following problems appear:
> a) when choosing auto-select for dialect, the wizard raises the difference panel after hitting Next with generic "Error encountered importing DDL" message and a "No difference report was found" message.
> b) when leaving auto-select unchecked for dialect, clicking Next produces a DDL failed to parse error (as well as a 'No difference report was found" error.
> The DDL in question works in JBDS 6 and earlier.
> Version-Release number of selected component (if applicable):
> JBDS 7 with JBDSIS 7 beta 4
> How reproducible:
> Consistent.
> Steps to Reproduce:
> Import attached DDL via importer.
> see: https://bugzilla.redhat.com/show_bug.cgi?id=1016553
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months
[JBoss JIRA] (TEIIDDES-1009) Improve Designer "Metadata from Text files on file system" import option
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1009?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-1009:
---------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 780723|https://bugzilla.redhat.com/show_bug.cgi?id=780723] from NEW to CLOSED
> Improve Designer "Metadata from Text files on file system" import option
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-1009
> URL: https://issues.jboss.org/browse/TEIIDDES-1009
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Import/Export
> Affects Versions: 7.4
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Labels: eds
> Fix For: Future
>
>
> Currently, this importer is very limited on the data that can be imported. i.e. on columns you can only import: Name, Datatype, Length and Description. All the Model, Table and Column properties should be available to import. Nullability, Cardinality, Precision, Comments, etc.
> Also, change name to "Metadata from Flat or Text File" to distinguish it from "Metadata from Teiid Metadata File"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 6 months