[JBoss JIRA] (TEIID-1070) Create Amazon SimpleDB Connector
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1070?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-1070.
---------------------------------
> Create Amazon SimpleDB Connector
> ---------------------------------
>
> Key: TEIID-1070
> URL: https://issues.jboss.org/browse/TEIID-1070
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Reporter: John Doyle
> Assignee: Ramesh Reddy
> Labels: CR2
> Fix For: 8.7
>
>
> We need connectivity to Amazon SimpleDB. This should be accomplished through a dedicated connector.
> Simple DB presents a few challenges as a Teiid source as it is more like a spreadsheet than a database. Simple DB "Domains' are like individual worksheets and contain any number of items. Items however can have any number of attributes, and the attributes do not have to be the same for ever item. So in a single Domain you can have an item with the attributes Size and Color, and another item with the attributes Color and ExpirationDate. This presents both modeling issues and SQL execution issues. None of them are insurmountable, but users will have to understand the issues and design their integration around them.
--
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, 8 months
[JBoss JIRA] (TEIID-2920) Certain Translator Override Definitions for JDBC have identical display names
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2920?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2920.
---------------------------------
> Certain Translator Override Definitions for JDBC have identical display names
> -----------------------------------------------------------------------------
>
> Key: TEIID-2920
> URL: https://issues.jboss.org/browse/TEIID-2920
> Project: Teiid
> Issue Type: Bug
> Reporter: Barry LaFond
> Assignee: Ramesh Reddy
> Fix For: 8.7
>
>
> In VDB editor, noticed that their are duplicate display names for certain JDBC translator properties. Confusing...
> Debugged a little and here are the culprits I found:
> ID = supportsDirectQueryProcedure
> * Display Name = *Supports direct query procedure*
> ID = supportsNativeQueries
> * Display Name = *Supports direct query procedure*
> ID = DirectQueryProcedureName
> * Display Name = *Name of the direct query procedure*
> ID = NativeQueryProcedureName
> * Display Name = *Name of the direct query procedure*
--
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, 8 months
[JBoss JIRA] (TEIID-2896) Add TEXTTABLE function capabilities to interpret fixed width data file content that is shorter than the defined line length
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2896?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2896.
---------------------------------
> Add TEXTTABLE function capabilities to interpret fixed width data file content that is shorter than the defined line length
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-2896
> URL: https://issues.jboss.org/browse/TEIID-2896
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.7
>
> Attachments: sample, TEIID-2896.patch
>
>
> Current behavior is that data lines too short to fit a fixed width data interpretation produces an error such as "Error: Text parse error: Fixed width line width 35 is smaller than the expected 60 on text line 1 in file:/tmp/file.csv.". The customer's use case is interpreting data files from another application which bundles multiple types of data along with additional descriptive info/metadata about the data contained within the file. As the error is thrown if any lines after the first interpreted line are shorter than the summed value of the fixed width columns, they are unable to query the file. The customer wishes for the ERROR to be suppressed and the query to return the data independent of whether it fits the fixed width criteria and potentially to be able to filter the data being retrieved.
--
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, 8 months