Importing GeoJSON with a deeply nested object array
“Importing GeoJSON with a deeply nested object array“
· 5 min read
9 posts tagged with "Data Formats"
View All TagsHow can I use the new JSON Data Type with Kafka?
Learn how to load JSON messages from Apache Kafka directly into a single JSON column in ClickHouse using the Kafka table engine and JSON data type.
· 4 min read
Simple example flow for extracting JSON data using a landing table with a Materialized View
Simple example flow for extracting JSON data using a landing table with a Materialized View
· 2 min read
Resolving "Cannot Append Data in Parquet Format" Error in ClickHouse
Are you getting the error "Cannot append data in format Parquet to file" error in ClickHouse? Let's take a look at how to resolve it.
· 2 min read
Importing and Querying JSON Array Objects in ClickHouse
Learn how to import JSON array objects into ClickHouse and perform advanced queries using JSON functions and array operations.
· 6 min read
How do I convert Files from Parquet to CSV or JSON?
Learn how to use ClickHouse's `clickhouse-local` tool to easily convert Parquet files to CSV or JSON formats.
· 3 min read
How do I export PostgreSQL data to Parquet, CSV or JSON?
Learn how to export PostgreSQL data to Parquet, CSV, or JSON formats using `clickhouse-local` with various examples.
· 3 min read
How do I export MySQL Data to Parquet, CSV, or JSON Using ClickHouse
Learn how to use the `clickhouse-local` tool to export MySQL data into formats like Parquet, CSV, or JSON quickly and efficiently.
· 2 min read
JSON Extract example
A short example on how to extract base types from JSON
· One min read