Can I use create table statement to define schema for http text datasource? I tried that and get an error saying table cannot be created because directory with same name already exists.
|
According to you request, v4.2.017 supports using CTEATE TABLE sql to define table structure for url database(http, https, ftp). Please download it.
For instance,
CREATE TABLE "http://www.hxtt.com/test/country.csv" (COUNTRY CHAR(24), _CSV_Header boolean default false)
select * from "http://www.hxtt.com/test/country.csv";
|