Results of 1 - 4 of about 4 for deserialize (0.002 sec.)
- SQL to/from JSON 12149
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...that these functions do not preserve syntactic sugar such as FROM * SELECT ... , so a statement round-tripped through json_deserialize_sql(json_serialize_sql(...)) may not be identical to the original statement, but should always be semantically equivalent...sage":"syntax error at or near \"VALID\"","location":"[12,5]","position":"12","error_subtype":"SYNTAX_ERROR"} Example with deserialize: SELECT json_deserialize_sql(json_serialize_sql('SELECT 1 + 2')); SELECT (1 + 2) Example with deserialize and syntax sugar..., which is lost during the transformation: SELECT json_deserialize_sql(json_serialize_sql('FROM x SELECT 1 + 2')); SELECT (1 + 2) FROM x Example with execute: SELECT * FROM json_execute_ser... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- Spatial Functions 9523
- 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
...ave X, Y and Z components ST_Force4D Forces the vertices of a geometry to have X, Y, Z and M components ST_GeomFromGeoJSON Deserializes a GEOMETRY from a GeoJSON fragment. ST_GeomFromHEXEWKB Deserialize a GEOMETRY from a HEX(E)WKB encoded string ST_GeomFrom...HEXWKB Deserialize a GEOMETRY from a HEX(E)WKB encoded string ST_GeomFromText Deserialize a GEOMETRY from a WKT encoded string ST_GeomFromWKB...Deserializes a GEOMETRY from a WKB encoded blob ST_GeometryType Returns a GEOMETRY_TYPE enum identifying the input geometry type. Poss... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Indexing 7748
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...memory-intensive queries. Re-attaching ( DETACH + ATTACH ) the database containing indexes can mitigate this effect, as we deserialize index memory lazily. Disabling index scans and re-attaching after changes can further decrease the impact of indexes on Du...ckDB's available memory. Indexes and Opening Databases Indexes are serialized to disk and deserialized lazily, i.e., when reopening the database. Operations using the index will only load the required parts of the index. The... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- Storage Versions and Format 7526
- Compatibility Backward Compatibility Backward compatibility refers to the ability of a newer DuckDB version to read storage files created by an older DuckDB version. Version 0.10 is the first release of DuckDB that supports backward compati
...you are using, the following error message may occur: Error: unable to open database "...": Serialization Error: Failed to deserialize: ... The message implies that the database file was created with a newer DuckDB version and uses features that the DuckDB... - https://man.mtool.work/duckdb/2.0/internals/storage.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work