DB::Exception: Bad get: has UInt64, requested String

最新推荐文章于 2022-06-27 21:52:23 发布

喝粥也会胖的唐僧

最新推荐文章于 2022-06-27 21:52:23 发布

阅读量2.7k

点赞数 1

分类专栏：大数据

本文链接：https://blog.csdn.net/zhou_438/article/details/99590307

版权

大数据专栏收录该内容

29 篇文章 1 订阅

订阅专栏

呵呵，真的太坑了，使用clickhouse在建分布式表的时候报错了：

node03 :) CREATE TABLE ontime_all AS ontime_local_2 ENGINE = Distributed(cluster-1, h2, ontime_local_2, '100');

CREATE TABLE ontime_all AS ontime_local_2
ENGINE = Distributed(cluster - 1, h2, ontime_local_2, '100')

Received exception from server (version 19.9.5):
Code: 170. DB::Exception: Received from localhost:9000, ::1. DB::Exception: Bad get: has UInt64, requested String. 

0 rows in set. Elapsed: 0.001 sec.

查看日志文件：

2019.08.14 02:30:20.310653 [ 45 ] {eba0bb00-5629-4833-afab-92d7023d01c7} <Error> executeQuery: Code: 170, e.displayText() = DB::Exception: Bad get: has UInt64, requested String (version 19.9.5.36) (from [::1]:50202) (in query: CREATE TABLE ontime_all AS ontime_local_2 ENGINE = Distributed(cluster-1, h2, ontime_local_2, '100');), Stack trace:

0. clickhouse-server(StackTrace::StackTrace()+0x16) [0x65cbc16]
1. clickhouse-server(DB::Exception::Exception(std::string const&, int)+0x1f) [0x2ffea8f]
2. clickhouse-server(DB::getClusterName(DB::IAST const&)+0x354) [0x6218b44]
3. clickhouse-server(DB::getClusterName(DB::IAST const&)+0x170) [0x6218960]
4. clickhouse-server() [0x5d7e51a]
5. clickhouse-server(DB::StorageFactory::get(DB::ASTCreateQuery&, std::string const&, std::string const&, std::string const&, DB::Context&, DB::Context&, DB::ColumnsDescription const&, bool, bool) const+0x1df) [0x5d821bf]
6. clickhouse-server(DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&)+0x6d7) [0x5ba2a87]
7. clickhouse-server(DB::InterpreterCreateQuery::execute()+0x56) [0x5ba5046]
8. clickhouse-server() [0x5cb8ef2]
9. clickhouse-server(DB::executeQuery(std::string const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool)+0x7d) [0x5cbafed]
10. clickhouse-server(DB::TCPHandler::runImpl()+0x4a3) [0x3009833]

反正我是被坑了，我试着加上引号，因为我实在是没招了，之前看人家都说没加引号，我日

node03 :) CREATE TABLE ontime_all AS ontime_local_2 ENGINE = Distributed('cluster-1', 'h2', 'ontime_local_2', 100);

CREATE TABLE ontime_all AS ontime_local_2
ENGINE = Distributed('cluster-1', 'h2', 'ontime_local_2', 100)

Ok.

0 rows in set. Elapsed: 0.005 sec. 

node03 :) show tables

SHOW TABLES

┌─name───────────┐
│ ontime_all     │
│ ontime_local_2 │
└────────────────┘

是他们写错误导我了，还是我的版本的问题，我真的很无语，我一直以为自己系统坏了，整了了快一天。。。。我还在GitHub提问了，结果我试出来了。。。