Search Result: UniqueCarrier - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

Documentation DuckDB 1.3 ドキュメント全文検索

DuckDB 1.3 ドキュメント全文検索

Results of 1 - 4 of about 4 for UniqueCarrier (0.002 sec.)

Combining Schemas – DuckDB 11705: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... , as well as the second column in each file, etc. For example, consider the following two files. flights1.csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName 1988-01-01|AA|New York, NY|Los Angeles, CA 1988-01-02|AA|New York, NY|Los Angeles, CA flights2 ... .csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName 1988-01-03|AA|New York, NY|Los Angeles, CA Reading the two files at the same time will produce ... the following result set: FlightDate UniqueCarrier OriginCityName DestCityName 1988-01-01 AA New York, NY Los Angeles, CA 1988-01-02 AA New York, NY Los Angeles, CA 1988-01- ...; https://man.mtool.work/duckdb/1.3/data/multiple_files/combining_schemas.html

CSV Import – DuckDB 10337: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... ustom options: SELECT * FROM read_csv ( 'flights.csv' , delim = '|' , header = true , columns = { 'FlightDate' : 'DATE' , 'UniqueCarrier' : 'VARCHAR' , 'OriginCityName' : 'VARCHAR' , 'DestCityName' : 'VARCHAR' }); Read a CSV from stdin, auto-infer options: ca ... v | duckdb -c "SELECT * FROM read_csv('/dev/stdin')" Read a CSV file into a table: CREATE TABLE ontime ( FlightDate DATE , UniqueCarrier VARCHAR , OriginCityName VARCHAR , DestCityName VARCHAR ); COPY ontime FROM 'flights.csv' ; Alternatively, create a table ... olumn0, column1, column2, ... . An example with the flights.csv file: SELECT * FROM read_csv ( 'flights.csv' ); FlightDate UniqueCarrier OriginCityName DestCityName 1988-01-01 AA New York, NY Los Angeles, CA 1988-01-02 AA New York, NY Los Angeles, CA 1988-01- ...; https://man.mtool.work/duckdb/1.3/data/csv/overview.html

Reading Multiple Files – DuckDB 7507: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... csv ([ 'flights1.csv' , 'flights2.csv' ], union_by_name = true , filename = true ); FlightDate OriginCityName DestCityName UniqueCarrier filename 1988-01-01 New York, NY Los Angeles, CA NULL flights1.csv 1988-01-02 New York, NY Los Angeles, CA NULL flights1.c ...; https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html

CSV Auto Detection – DuckDB 7397: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... Considered values delim , | ; \t quote " ' (empty) escape " ' \ (empty) Consider the example file flights.csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName 1988-01-01|AA|New York, NY|Los Angeles, CA 1988-01-02|AA|New York, NY|Los Angeles, CA 1988-01- ...; https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work