Results of 1 - 2 of about 2 for jsonl (0.000 sec.)
- Hugging Face Support 11228
- The httpfs extension introduces support for the hf:// protocol to access datasets hosted in Hugging Face repositories. See the announcement blog post for details. Usage Hugging Face repositories can be queried using the following URL patter
...he file path in the repository The result of the query is: kind sound dog woof cat meow pokemon pika human hello To read a JSONL file, you can run: SELECT * FROM 'hf://datasets/datasets-examples/doc-formats-jsonl-1/data.jsonl'; Finally, for reading a... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/hugging_face.html
- Writing JSON 7485
- The contents of tables or the result of queries can be written directly to a JSON file using the COPY statement. For example: CREATE TABLE cities AS FROM (VALUES ('Amsterdam', 1), ('London', 2)) cities(name, id); COPY cities TO 'cities.json
...ON New This feature was introduced in DuckDB 2.0. COPY ... (FORMAT GEOJSON) writes a GeoJSON FeatureCollection . FORMAT GEOJSONL (or ARRAY true with FORMAT GEOJSON ) writes newline-delimited Feature objects. You do not need json_geometry_format for th...om, 10 AS my_field) TO 'test.json' (FORMAT GEOJSON); COPY (SELECT 'POINT(0 1)'::GEOMETRY AS geom, 10 AS my_field) TO 'test.jsonl' (FORMAT GEOJSONL); Optional ID_COLUMN and GEOMETRY_COLUMN pick which columns become the Feature id and geometry. st_asgeo... - https://man.mtool.work/duckdb/2.0/data/json/writing_json.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work