Bug 1093210
| Summary: | Using Teiid Designer, "importing 2nd line as data type indicator" function for CSV file does not work | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Hisao Furuichi <hfuruich> | ||||||
| Component: | Tooling | Assignee: | Barry LaFond <blafond> | ||||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | |||||||
| Severity: | medium | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 6.0.0 | CC: | asmigala, blafond, felias, hfuruich, mmakovy, vhalbert | ||||||
| Target Milestone: | ER5 | ||||||||
| Target Release: | 6.1.0 | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2015-11-17 18:08:09 UTC | Type: | Bug | ||||||
| Regression: | --- | Mount Type: | --- | ||||||
| Documentation: | --- | CRM: | |||||||
| Verified Versions: | Category: | --- | |||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||
| Embargoed: | |||||||||
| Attachments: |
|
||||||||
The work around is to manually change the data type by selecting the corresponding type from the drop down for each column. Added it to 8.6.1 so it'll be in DV 6.1 Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Resolved Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Reopened Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Resolved Created attachment 977895 [details]
Employees flat file source
another example flat file source
Matus, I couldn't reproduce your issue. The default behavior adds the SKIP 2 in the SQL, hence a valid SQL statement I reinstalled JBDS and TD and tried to reproduce this again. When I am importing from Flat file and on the "Data File Source Selection" dialogue I select only Data File Source (not using button New etc., I have defined some connection profile for flat file before) and click Next>, TD doesn't add SKIP. BUT when I select Data File Source and click twice (uncheck/check) on sample.csv (in Available Data Files section) TD adds SKIP. Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Reopened Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Resolved verified TD 9.0.1.Final Matus Makovy <mmakovy> updated the status of jira TEIIDDES-1037 to Closed verified TD 8.6.1.CR1 |
Created attachment 891342 [details] reproducer Description of problem: Using Teiid Designer, "importing 2nd line as data type indicator" function for CSV file does not work. All of columns are recognized as String. Version-Release number of selected component (if applicable): Teiid Designer 8.3.2.Final-v20140328-2123-B54 Steps to Reproduce: 1: Create new Teiid Project 2: Select "Model Flat File Source" wizard, and click "Create source model from local flat source" 3: select "Flat file on local file system", and click next 4: click New button for "data source" 5: type name and click next 6: select home holder which has a csv file, and check "Use second line as data type indicator" 7: finish up modal panel and go back to wizard 8: select directory for source model, and click next 2 times Actual results: On "Column information", all of columns types are defined as String. Expected results: On "Column information", each column type is defined according to the 2nd line. Additional info: sample csv file is attached as sample.csv