Search Result: birds - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

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

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

Results of 1 - 4 of about 4 for birds (0.005 sec.)

Loading JSON – DuckDB 12279: 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 ... The format parameter specifies how to read the JSON from a file. With unstructured , the top-level JSON is read, e.g., for birds.json : { "duck" : 42 } { "goose" : [ 1 , 2 , 3 ] } FROM read_json_objects ( 'birds.json' , format = 'unstructured' ); will ... ────────────────────┘ With newline_delimited , NDJSON is read, where each JSON is separated by a newline ( \n ), e.g., for birds-nd.json : { "duck" : 42 } { "goose" : [ 1 , 2 , 3 ]} FROM read_json_objects ( 'birds-nd.json' , format = 'newline_delimite ... ───┤ │ {"duck": 42} │ │ {"goose": [1, 2, 3]} │ └──────────────────────┘ With array , each array element is read, e.g., for birds-array.json : [ { "duck" : 42 }, { "goose" : [ 1 , 2 , 3 ] } ] FROM read_json_objects ( 'birds-array.json' , format = 'arra ...; https://man.mtool.work/duckdb/1.3/data/json/loading_json.html

Enum Data Type – DuckDB 9153: 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 ... eed AS ENUM ( 'maltese' , 'maltese' ); Create an enum using the unique string values in the my_varchar column: CREATE TYPE birds AS ENUM ( SELECT my_varchar FROM my_inputs ); Show the available values in the birds enum using the enum_range function: S ... ELECT enum_range ( NULL :: birds ) AS my_enum_range ; my_enum_range [duck, goose] Enum Usage After an enum has been created, it can be used anywhere a stan ...; https://man.mtool.work/duckdb/1.3/sql/data_types/enum.html

Data Types – DuckDB 7822: 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 ... UNION types can be arbitrarily nested to any depth, so long as the type rules are observed. Struct with LIST s: SELECT { 'birds' : [ 'duck' , 'goose' , 'heron' ], 'aliens' : NULL , 'amphibians' : [ 'frog' , 'toad' ]}; Struct with list of MAP s: SELEC ...; https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html

Struct Data Type – DuckDB 7692: 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 ... SELECT { 'key1' : 'string' , 'key2' : 1 , 'key3' : 12.345 } AS s ; Create a struct of structs with NULL values: SELECT { 'birds' : { 'yes' : 'duck' , 'maybe' : 'goose' , 'huh' : NULL , 'no' : 'heron' }, 'aliens' : NULL , 'amphibians' : { 'yes' : 'fro ...; https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work