Results of 1 - 10 of about 11 for New York (0.003 sec.)
new (185), york (11)
- Combining Schemas 23653
- Examples Read a set of CSV files combining columns by position: SELECT * FROM read_csv('flights*.csv'); Read a set of CSV files combining columns by name: SELECT * FROM read_csv('flights*.csv', union_by_name = true); Combining Schemas When
...ample, 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 UniqueCa...rrier OriginCityName DestCityName 1988-01-01 AA New York, NY Los Angeles, CA 1988-01-02 AA New York, NY Los Angeles, CA 1988-01-03 AA New York, NY Los Angeles, CA This is equivale... - https://man.mtool.work/duckdb/2.0/data/multiple_files/combining_schemas.html
- PIVOT Statement 20167
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...Amsterdam', 2020, 1158), ('US', 'Seattle', 2000, 564), ('US', 'Seattle', 2010, 608), ('US', 'Seattle', 2020, 738), ('US', 'New York City', 2000, 8015), ('US', 'New York City', 2010, 8175), ('US', 'New York City', 2020, 8772); SELECT * FROM cities; c...dam 2000 1005 NL Amsterdam 2010 1065 NL Amsterdam 2020 1158 US Seattle 2000 564 US Seattle 2010 608 US Seattle 2020 738 US New York City 2000 8015 US New York City 2010 8175 US New York City 2020 8772 PIVOT ON and USING Use the PIVOT statement below...ities ON year USING sum(population); country name 2000 2010 2020 NL Amsterdam 1005 1065 1158 US Seattle 564 608 738 US New York City 8015 8175 8772 In the above example, the sum aggregate is always operating on a single value. If we only want to chan... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- query and query_table Functions 16158
- The query_table and query functions enable powerful and more dynamic SQL. The query_table function returns the table whose name is specified by its string argument; the query function returns the table obtained by executing the query specif
...TO NAME ' || name || ' VALUES ' || values ); WITH cities AS ( FROM ( VALUES ('NL', 'Amsterdam', '10', '12', '15'), ('US', 'New York', '100', '120', '150') ) _(country, city, '2000', '2010', '2020') ) SELECT * FROM stack('cities', ['country', 'city']..., 'year', 'population'); country city year population NL Amsterdam 2000 10 NL Amsterdam 2010 12 NL Amsterdam 2020 15 US New York 2000 100 US New York 2010 120 US New York 2020 150... - https://man.mtool.work/duckdb/2.0/guides/sql_features/query_and_query_table_func...
- CSV Import 15354
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...Maximum line size, in bytes. BIGINT 2000000 names or column_names Column names, as a list. See example . VARCHAR[] (empty) new_line New line character(s). Options are '\r' , '\n' , or '\r\n' . The CSV parser only distinguishes between single-charact...lights.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-03 AA New York, NY Los Angeles, CA The path ca...PY ontime FROM 'flights.csv'; SELECT * FROM ontime; 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-03 AA New York, NY Los Angeles, CA If we want to ma... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- CSV Auto Detection 14114
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...me Description read_csv parameter Example Delimiter Delimiter delim , Quote Quote character quote " Escape Escape escape \ NewLineDelimiter New-line delimiter new_line \r\n Comment Comment character comment # SkipRows Number of rows skipped skip 1 H...FROM sniff_csv('my_file.csv'); Prompt = FROM read_csv('my_file.csv', auto_detect=false, delim=',', quote='"', escape='"', new_line='\n', skip=0, header=true, columns={...}); Detection Steps Dialect Detection Dialect detection works by attempting to...' \ (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-03|AA|New York, NY|Los Angeles, CA In this file, th... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Reading Multiple Files 13902
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different sch
...s4.csv'], union_by_name = true, filename = true); FlightDate OriginCityName DestCityName UniqueCarrier filename 1988-01-01 New York, NY Los Angeles, CA NULL flights3.csv 1988-01-02 New York, NY Los Angeles, CA NULL flights3.csv 1988-01-03 New York,... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Pivot Internals 13451
- PIVOT Pivoting is implemented as a combination of SQL query re-writing and a dedicated PhysicalPivot operator for higher performance. Each PIVOT is implemented as set of aggregations into lists and then the dedicated PhysicalPivot operator
...) list(population_sum) NL Amsterdam [2000, 2010, 2020] [1005, 1065, 1158] US Seattle [2000, 2010, 2020] [564, 608, 738] US New York City [2000, 2010, 2020] [8015, 8175, 8772] The PhysicalPivot operator converts those lists into column names and valu...es to return this result: country name 2000 2010 2020 NL Amsterdam 1005 1065 1158 US Seattle 564 608 738 US New York City 8015 8175 8772 The rewrite into list-based aggregations shown above is used only when the number of distinct piv... - https://man.mtool.work/duckdb/2.0/internals/pivot.html
- Time Zone Reference List 13100
- An up-to-date version of this list can be pulled from the pg_timezone_names() table function: SELECT name, abbrev FROM pg_timezone_names() ORDER BY name; name abbrev ACT ACT AET AET AGT AGT ART ART AST AST Africa/Abidjan Iceland Africa/Accr
...ntevideo America/Montevideo America/Montreal America/Montreal America/Montserrat PRT America/Nassau America/Nassau America/New_York America/New_York America/Nipigon America/Nipigon America/Nome America/Nome America/Noronha America/Noronha America/No...rth_Dakota/Beulah America/North_Dakota/Beulah America/North_Dakota/Center America/North_Dakota/Center America/North_Dakota/New_Salem America/North_Dakota/New_Salem America/Nuuk America/Nuuk America/Ojinaga America/Ojinaga America/Panama EST America/... - https://man.mtool.work/duckdb/2.0/sql/data_types/timezones.html
- Date Part Functions 12754
- The date_part , date_trunc and date_diff functions can be used to extract or manipulate parts of temporal types such as TIMESTAMP , TIMESTAMPTZ , DATE and INTERVAL . The parts to be extracted or manipulated are specified by one of the strin
...TE values. | | Example | timezone_hour(TIMESTAMPTZ '1992-02-15 01:00:00+00') | | Result | -5 (with TimeZone set to America/New_York ) | timezone_minute(date) | Description | Time zone offset minutes portion. Only meaningful for TIMESTAMP WITH TIME Z...ATE values. | | Example | timezone(TIMESTAMPTZ '1992-02-15 01:00:00+00') | | Result | -18000 (with TimeZone set to America/New_York ) | week(date) | Description | ISO Week. | | Example | week(DATE '1992-02-15') | | Result | 7 | weekday(date) | Descr... - https://man.mtool.work/duckdb/2.0/sql/functions/datepart.html
- Spatial Functions 12744
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...metry, if available. ST_ExteriorRing Returns the exterior ring (shell) of a polygon geometry. ST_FlipCoordinates Returns a new geometry with the coordinates of the input geometry "flipped" so that x = y and y = x ST_Force2D Forces the vertices of a...slowest. Example -- Note: the coordinates are in WGS84 and [latitude, longitude] axis order -- What's the distance between New York and Amsterdam (JFK and AMS airport)? SELECT st_distance_spheroid( st_point(40.6446, -73.7797), st_point(52.3130, 4.77... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
DuckDB 2.0 Documentation / man.mtool.work