clickhouse - DB::Exception: 从 localhost:8000 接收。DB::Exception:列数不匹配
问题描述
创建表: -
CREATE TABLE default.bankIfsc (
`event_date` Date DEFAULT toDate(now()),
`id` Int32,
`uid` Int32,
`nid` Int32,
`bank` String,
`ifsc_code` String,
`micr_code` String,
`branch` String,
`address` String,
`contact` String,
`city` String,
`district` String,
`state` String,
`content` String,
`feature_image` String,
`var1` String,
`var2` String,
`var3` String,
`var4` String,
`var5` String,
`createdtime` Int32,
`createdtimestr` DateTime DEFAULT toDateTime(createdtime),
`updatedtime` Int32,
`updatedtimestr` DateTime DEFAULT toDateTime(updatedtime),
`status` Int32) ENGINE = ReplacingMergeTree(event_date, id, 8192)
此表和表视图中的数据存储:-
CREATE TABLE default.bankIfsc_bck (
`id` Int32,
`uid` Int32,
`nid` Int32,
`bank` String,
`ifsc_code` String,
`micr_code` String,
`branch` String,
`address` String,
`contact` String,
`city` String,
`district` String,
`state` String,
`content` String,
`feature_image` String,
`var1` String,
`var2` String,
`var3` String,
`var4` String,
`var5` String,
`createdtime` Int32,
`createdtimestr` DateTime,
`updatedtime` Int32,
`updatedtimestr` DateTime,
`status` Int32) ENGINE = Log
插入数据:-
INSERT INTO bankIfsc ( id, uid, nid, bank, ifsc_code, micr_code, branch,
address, contact, city, district, state, content, feature_image, var1,
var2, var3, var4, var5, createdtime, createdtimestr, updatedtime,
updatedtimestr, status )
SELECT (id, uid, nid, bank, ifsc_code, micr_code, branch, address,
contact, city, district, state, content, feature_image, var1, var2, var3,
var4, var5, createdtime, createdtimestr, updatedtime, updatedtimestr,
status)
FROM bankIfsc_bck;
列数不匹配。我得到这个错误任何人帮助,请
解决方案
( ) -- makes tuple datatype.
2 columns -- select 1,2
desc (select 1,2)
┌─name─┬─type──┬
│ 1 │ UInt8 │
│ 2 │ UInt8 │
└──────┴───────┴
1 column -- select (1,2)
desc (select (1,2))
─name────────┬─type────────────────┬
tuple(1, 2) │ Tuple(UInt8, UInt8) │
─────────────┴─────────────────────┴
从您的选择中删除 ( )
SELECT id, uid, nid, bank, ifsc_code, micr_code, branch, address,
contact, city, district, state, content, feature_image, var1, var2, var3,
var4, var5, createdtime, createdtimestr, updatedtime, updatedtimestr,
status
FROM bankIfsc_bck;
推荐阅读
- ms-access - 如何让 Access 子报表显示组中的所有项目?
- c# - UWP NavigationView 和 TabView 冲突
- python - 气流 - [Errno 21] 是一个目录:'/airflow/key/'
- postgresql - 在 Spark 中对 Postgres 读取进行分区
- firebase - 有没有办法在中国查询Firestore?
- java - 调整大小功能遇到问题
- python - 为什么 cmd.exe 安装 pip install -r requirements.txt
- flutter - 当您长按颤动应用程序的主图标时,有没有办法显示要执行的 2 或 3 个项目的菜单
- reactjs - 左右移动内容以跟随抽屉打开/关闭(Material-UI)
- flutter - 如何计算颤振中两个输入字段值的总和?