Bug 1093210 - Using Teiid Designer, "importing 2nd line as data type indicator" function for CSV file does not work
Summary: Using Teiid Designer, "importing 2nd line as data type indicator" function fo...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ER5
: 6.1.0
Assignee: Barry LaFond
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-05-01 00:32 UTC by Hisao Furuichi
Modified: 2018-12-05 18:24 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-11-17 18:08:09 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)
reproducer (93 bytes, text/csv)
2014-05-01 00:32 UTC, Hisao Furuichi 		no flags Details
Employees flat file source (5.31 KB, text/plain)
2015-01-08 19:01 UTC, Barry LaFond 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIIDDES-1037 0 Major Closed Data types inported from flat file partially implemented in wizard 2015-02-10 10:30:35 UTC

Description Hisao Furuichi 2014-05-01 00:32:28 UTC 
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
Comment 3 Van Halbert 2014-05-01 01:02:52 UTC 
The work around is to manually change the data type by selecting the corresponding type from the drop down for each column.
Comment 9 Barry LaFond 2014-09-30 12:55:29 UTC 
Added it to 8.6.1 so it'll be in DV 6.1
Comment 10 JBoss JIRA Server 2014-10-01 16:08:05 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Resolved
Comment 12 JBoss JIRA Server 2014-12-01 16:53:29 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Reopened
Comment 13 JBoss JIRA Server 2014-12-01 16:54:44 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Resolved
Comment 15 Barry LaFond 2015-01-08 19:01:18 UTC 
Created attachment 977895 [details]
Employees flat file source

another example flat file source
Comment 16 Barry LaFond 2015-01-08 19:06:02 UTC 
Matus, I couldn't reproduce your issue. The default behavior adds the SKIP 2 in the SQL, hence a valid SQL statement
Comment 17 Matus Makovy 2015-01-12 08:38:07 UTC 
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.
Comment 18 JBoss JIRA Server 2015-01-27 16:11:29 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Reopened
Comment 19 JBoss JIRA Server 2015-01-27 16:15:23 UTC 
Barry LaFond <blafond> updated the status of jira TEIIDDES-1037 to Resolved
Comment 20 Matus Makovy 2015-02-10 10:30:21 UTC 
verified TD 9.0.1.Final
Comment 21 JBoss JIRA Server 2015-02-10 10:30:35 UTC 
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-1037 to Closed
Comment 22 Matus Makovy 2015-03-04 12:06:53 UTC 
verified TD 8.6.1.CR1
Note You need to log in before you can comment on or make changes to this bug.