Bug 780820 (SOA-3269) - Support different length records in files for modeling
Summary: Support different length records in files for modeling
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-3269
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.2.0 ER1
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
: 5.2.0 GA,5.2.0.ER4
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-08-15 16:53 UTC by Joel Tosi
Modified: 2016-10-05 23:06 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Fedora 14, OpenJDK 1.6, JBDS 4 GA
Last Closed: 2011-10-10 20:32:07 UTC
Type: Enhancement


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3269 0 None None None Never
Red Hat Issue Tracker TEIID-1712 0 None None None Never

Description Joel Tosi 2011-08-15 16:53:05 UTC
project_key: SOA

If I try and model a file where there are differing length records, I get an error, i.e.

No value found for column "EMPTY_VALUE" in the row ending on text line 1 in file...

Instead I would expect to see null values.

For example, if this is my file (CSV)

HEADER,KEEP,THESE,VALUES,NOT,COLUMN,NAMES
Data, more data, other data, 2, 3, 4, 5, more data, what else, more data, and, so, on

I can read the file in but trying to model it gives me the error mentioned above.

Comment 1 Van Halbert 2011-08-15 17:53:35 UTC
Link: Added: This issue Cloned to SOA-3270


Comment 2 Steven Hawkins 2011-08-15 20:40:55 UTC
This can simply be an under the covers changes, which could be viewed as a bug fix to allow missing columns if they occur at the end of values.  Or an enhancement that would add a switch to texttable to allow missing columns.  I'm leaning toward the former.  It's unlikely that anyone is relying on Teiid to formally validate the number of column entries in delimited mode.

Comment 4 David Le Sage 2011-08-25 23:21:53 UTC
Release Notes Docs Status: Added: Not Required
Writer: Added: dlesage


Comment 5 Paul Nittel 2011-10-10 20:32:07 UTC
Tested and closed!


Note You need to log in before you can comment on or make changes to this bug.