Search Result: FlightDate - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

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

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

Results of 1 - 5 of about 5 for FlightDate (0.002 sec.)

Combining Schemas – DuckDB 12078: 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 ... ed together, 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 Angele ... s, CA flights2.csv : FlightDate|UniqueCarrier|OriginCityName|DestCityName 1988-01-03|AA|New York, NY|Los Angeles, CA Reading the two files at the same tim ... e 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 Angele ...; https://man.mtool.work/duckdb/1.3/data/multiple_files/combining_schemas.html

CSV Import – DuckDB 10552: 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 ... read_csv function with custom options: SELECT * FROM read_csv ( 'flights.csv' , delim = '|' , header = true , columns = { 'FlightDate' : 'DATE' , 'UniqueCarrier' : 'VARCHAR' , 'OriginCityName' : 'VARCHAR' , 'DestCityName' : 'VARCHAR' }); Read a CSV from st ... ns: cat flights.csv | 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' ; Alternati ... be named column0, 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 Angele ...; https://man.mtool.work/duckdb/1.3/data/csv/overview.html

CSV Auto Detection – DuckDB 8401: 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 ... Parameters 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 Angele ... est priority meaning that all columns are converted to VARCHAR if they cannot be cast to anything else. In flights.csv the FlightDate column will be cast to a DATE , while the other columns will be cast to VARCHAR . The set of candidate types that should b ... ts.csv , we can see that the header row consists of only VARCHAR columns – whereas the values contain a DATE value for the FlightDate column. As such – the system defines the first row as the header row and extracts the column names from the header row. In ...; https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html

CSV Import Tips – DuckDB 7501: 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 ... of only certain columns by providing a struct of name → type mappings. SELECT * FROM read_csv ( 'flights.csv' , types = { 'FlightDate' : 'DATE' }); Use COPY When Loading Data into a Table The COPY statement copies data directly into a table. The CSV reader ...; https://man.mtool.work/duckdb/1.3/data/csv/tips.html

Reading Multiple Files – DuckDB 7390: 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 ... file. For example: SELECT * FROM read_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 Ne ...; https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work