Comments (5)
clickhouse-keeper:23.8.8.21.altinitystable
clickhouse-server:24.3
from clickhouse.
What steps led to this problem? What command did you execute?
from clickhouse.
create table
CREATE TABLE IF NOT EXISTS `local_1`.`appname_6` ON CLUSTER dtstack (`_at_timestamp_` DateTime64(3, 'UTC'),`_at_date_` Date,`_receive_timestamp_` DateTime64(3, 'UTC'),`_tenant_id_` Int64,`__appname__` LowCardinality(String)) engine = ReplicatedMergeTree('/clickhouse/tables/1/appname_6/2024-05-20/{shard}/hits', '{replica}') partition by toString(_at_date_) order by (_at_date_, _at_timestamp_, intHash64(toInt64(toDateTime(_at_timestamp_))))
2024-05-20 21:23:13 ERR acos-loggie-multiarch/pkg/pipeline/pipeline.go:368 > consumer batch failed: load table:[local_1.appname_6] failed: table create error, tableName: appname_6: code: 122, message: There was an error on [chi-clickhouse-cluster-dtstack-0-0:9000]: Code: 122. DB::Exception: Table columns structure in ZooKeeper is different from local table structure. Local columns:
columns format version: 1
5 columns:
`_at_timestamp_` DateTime64(3, \'UTC\')
`_at_date_` Date
`_receive_timestamp_` DateTime64(3, \'UTC\')
`_tenant_id_` Int64
`__appname__` LowCardinality(String)
Zookeeper columns:
columns format version: 1
5 columns:
`__appname__` LowCardinality(String)
`_at_timestamp_` DateTime64(3, \'UTC\')
`_at_date_` Date
`_receive_timestamp_` DateTime64(3, \'UTC\')
`_tenant_id_` Int64
. (INCOMPATIBLE_COLUMNS) (version 24.3.2.23 (official build))
from clickhouse.
What steps led to this problem?
select * from system.dropped_tables
from clickhouse.
clickhouse-keeper:23.8.8.21.altinitystable
This is a mistake. We don't support alternative, third-party builds.
I strongly do not recommend "altinity" builds.
Read https://clickhouse.com/docs/knowledgebase/difference_between_official_builds_and_3rd_party
from clickhouse.
Related Issues (20)
- Missing CSV header with INSERT INTO FUNCTION and CSVWithNames HOT 3
- Recursive CTE view creation exception.
- Distributed query fails with allow_experimental_analyzer and array join
- distinct on (id) with id in subquery with allow_experimental_analyzer=1 wrong result HOT 2
- Executing the same SQL on the same server but with different clients, the expected results are different. HOT 2
- Select query fails with input_format_parquet_use_native_reader=true HOT 1
- clickhouse-keeper-converter Unknown option specified: zookeeper-logs-dir HOT 4
- Nested values from kafka using the clickhouse connector HOT 1
- Flaky test: 01158_zookeeper_log_long
- Memory leaks in FileCache (in SLRU cache eviction policy) HOT 1
- `getClientHTTPHeader` doesn't work when used in a DEFAULT expression for a column and async inserts being enabled HOT 1
- Not possible to mix recursive and not recursive CTE in the same subquery HOT 4
- Crashes from clearPartsFromFilesystemImpl at 23.8
- Support dropping all tables within a database HOT 1
- Missing Content-Encoding HOT 2
- AST Fuzzer LOGICAL_ERROR in Planner: 'Cannot capture column 4 because it has incompatible type: got Map(UInt8, UInt8), but Map(UInt8, UInt8) is expected
- Cannot use Protobuf format with `url()`
- Stress test 'Possible deadlock on shutdown' while sending data to DistributedInsertQueue
- Feature request: schema inference for format function HOT 1
- Changing RECOMPRESS TTL on existing table does not recompress needed parts.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from clickhouse.