-
-
Notifications
You must be signed in to change notification settings - Fork 6
Open
Description
We wanted to use chdb to speed up our testing by dropping the network. However, it seems to me as though INSERT doesn't yet correctly handle all of ClickHouses functionality?
The following insert doesn't fail with a message, but simply pauses all execution:
INSERT INTO events (tenant_id, event_type, ts, ts_local, journey_id, session_id, experiments, country, region, city, lat_long, ua_browser, ua_browser_version, ua_os, ua_os_version, ua_device, ua_device_type, ua_device_vendor) VALUES ('00000000-0000-0000-0000-000000000000', 'Visit', '2024-01-01 00:00:00', '2024-01-01 00:00:00', 1, 1, [(0, 0, 0, 0, 0, '0', '{"JSONTest":true}')], 'US', 'CA', 'San Francisco', (37.7749, -122.4194), 'Chrome', '120', 'MacOS', '14.0', 'MacBook', 'Desktop', 'Apple');
The table schema is
"tenant_id","UUID"
"event_type","Enum8('Search' = -1, 'Visit' = 0, 'VariantSelected' = 1, 'Exit' = 2, 'AddCart' = 3, 'VisitCart' = 4, 'RemoveCart' = 5, 'Checkout' = 6, 'CheckoutContactAdded' = 7, 'CheckoutAddressAdded' = 8, 'CheckoutShippingAdded' = 9, 'CheckoutPaymentAdded' = 10, 'Conversion' = 11)"
"ts","DateTime('UTC')"
"ts_local","DateTime('UTC')"
"journey_id","UInt128"
"session_id","UInt128"
"experiments","Array(Tuple(
experiment_id UInt64,
page_id UInt64,
experience_id UInt64,
context_id UInt64,
flags UInt8,
variant_id String,
meta JSON))"
"country","LowCardinality(String)"
"region","LowCardinality(String)"
"city","String"
"lat_long","Point"
"ua_browser","LowCardinality(String)"
"ua_browser_version","LowCardinality(String)"
"ua_os","LowCardinality(String)"
"ua_os_version","LowCardinality(String)"
"ua_device","LowCardinality(String)"
"ua_device_type","LowCardinality(String)"
"ua_device_vendor","LowCardinality(String)"
Metadata
Metadata
Assignees
Labels
No labels