search

sciserver / graywulf

Database cluster federation toolkit
2 stars 3 forks source link

Importing a file not working correctly. #43

Closed mtaghiza closed 7 years ago

mtaghiza commented 7 years ago

When I try to upload the file MyUpload.txt containing:

1,1,2 2,3,4 4,3,2

and choose the automatic file detection, what happens is that the resulting table appears with a datetime column:

ID bigint 1,1,2 datetime2 1 2/3/2004 12:00:00 AM 2 4/3/2002 12:00:00 AM

It works if choose the file format as csv.

dobos commented 7 years ago

This is a feature. If the data type is not specified, it defaults to txt for which the column separator is space or tab. Column types are detected automatically by trying to parse them into various complex types such as datetime or guid. We could change the default from txt to csv.