[JBoss JIRA] (TEIIDDES-2077) 8.5 Release Work
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2077:
--------------------------------------
Summary: 8.5 Release Work
Key: TEIIDDES-2077
URL: https://issues.jboss.org/browse/TEIIDDES-2077
Project: Teiid Designer
Issue Type: Task
Components: Release Work
Affects Versions: 8.5
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: 8.5
Basic jira for 8.5 release process. Documentation, versioning, etc...
--
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
12 years
[JBoss JIRA] (TEIIDDES-2076) 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/TEIIDDES-2076?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-2076:
------------------------------------------
This is initially a Teiid request, which will then need designer handling to match.
I see two pieces that they are requesting:
1. Allow for a selector to be use with fixed width file - currently it is only for delimited files: https://docs.jboss.org/author/display/TEIID/FROM+Clause
2. (possibly obviated by 1) to make a best effort at returning rows with a fixed size, but the data is of a smaller length.
And yes, a sample file would help ensure that we understand the format correctly.
> Add TEXTTABLE function capabilities to interpret fixed width data file content that is shorter than the defined line length
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2076
> URL: https://issues.jboss.org/browse/TEIIDDES-2076
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Import/Export
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Barry LaFond
>
> 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
12 years
[JBoss JIRA] (TEIIDDES-2076) Add TEXTTABLE function capabilities to interpret fixed width data file content that is shorter than the defined line length
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2076?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2076:
----------------------------------------
Not sure how this initially will affect Designer since it appears the issue is with how Teiid is reading the data based on the XMLTABLE() definition?
Once Teiid decides if and how they handle it, there may or may not be tooling changes to accommodate them.
Lastly, please provide a sample/snippet of an applicable data file?
> Add TEXTTABLE function capabilities to interpret fixed width data file content that is shorter than the defined line length
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2076
> URL: https://issues.jboss.org/browse/TEIIDDES-2076
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Import/Export
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Barry LaFond
>
> 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
12 years
[JBoss JIRA] (TEIIDDES-2076) Add TEXTTABLE function capabilities to interpret fixed width data file content that is shorter than the defined line length
by Van Halbert (JIRA)
Van Halbert created TEIIDDES-2076:
-------------------------------------
Summary: Add TEXTTABLE function capabilities to interpret fixed width data file content that is shorter than the defined line length
Key: TEIIDDES-2076
URL: https://issues.jboss.org/browse/TEIIDDES-2076
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Affects Versions: 7.8
Reporter: Van Halbert
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
12 years, 1 month
[JBoss JIRA] (TEIIDDES-2076) Add TEXTTABLE function capabilities to interpret fixed width data file content that is shorter than the defined line length
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2076?page=com.atlassian.jira.plu... ]
Van Halbert updated TEIIDDES-2076:
----------------------------------
Assignee: Barry LaFond
> Add TEXTTABLE function capabilities to interpret fixed width data file content that is shorter than the defined line length
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2076
> URL: https://issues.jboss.org/browse/TEIIDDES-2076
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Import/Export
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Barry LaFond
>
> 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
12 years, 1 month
[JBoss JIRA] (TEIIDDES-1635) Designer is not showing the same error in the server log
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1635?page=com.atlassian.jira.plu... ]
Van Halbert updated TEIIDDES-1635:
----------------------------------
Assignee: Barry LaFond
> Designer is not showing the same error in the server log
> --------------------------------------------------------
>
> Key: TEIIDDES-1635
> URL: https://issues.jboss.org/browse/TEIIDDES-1635
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Usability
> Affects Versions: 7.4
> Reporter: Van Halbert
> Assignee: Barry LaFond
>
> JBoss developer studio is not returning complete error stack trace. For example, running a query throws error in the designer which is different from error in server log and we would like to get the error whatever is there in the server.log to troubleshoot and fix the issues.
> It's really difficult for developers to understand and fix the issues with the way error is shown in the designer compared to more useful error shown in the server.log.
--
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
12 years, 1 month