SQL 错误 [171] Exception: Block structure mismatch in UNION stream: different names of columns:
发布于 19 天前 作者 guxi20000 129 次浏览 来自 问答

SELECT * FROM OC_HDVISITORINFO WHERE COMPID=670803 AND SITEID=8952 AND CURENTERTIME > ‘2015-01-01 00:00:00’ AND CURENTERTIME < '2016-01-01 00:00:00’ AND SOURCEPROVINCE like ‘%北京%’ AND KEYWORD like '%客%' LIMIT 500,10;

clickhouse-client.x86_64 18.12.13-1.el6 clickhouse-common-static.x86_64 18.12.13-1.el6 clickhouse-compressor.x86_64 1.1.54336-3.el6 clickhouse-debuginfo.x86_64 18.12.13-1.el6 clickhouse-server.x86_64 18.12.13-1.el6 clickhouse-server-common.x86_64 18.12.13-1.el6 clickhouse-test.x86_64 18.12.13-1.el6

表OC_HDVISITORINFO: ENGINE = Distributed(bip_ck_cluster,‘ksonline’,‘OC_HDVISITORINFO_SUB’,rand()) 两个分片 表OC_HDVISITORINFO_SUB:ENGINE = MergeTree(CURENTERDAY, (COMPID, SITEID, RECID, CURENTERTIME), 8192) 去掉LIMIT 500,10执行正常,加上执行就报错,记得18.12.13这个版本不是处理了这个BUG吗? 修复了 Block structure mismatch in UNION stream: different number of columns 分布式查询发生的错误,如果其中一个分片是本地分区而另一个分片不是,并且 PREWHERE 触发了移动优化。 #2226 #3037 #3055 #3065 #3073 #3090 #3093

SQL 错误 [171]: ClickHouse exception, code: 171, host:xxx , port: xxx ; Code: 171, e.displayText() = DB::Exception: Block structure mismatch in UNION stream: different names of columns: CURENTERDAY Date UInt16(size = 0), RECID Int32 Int32(size = 0), VISITORID FixedString(50) FixedString(size = 0), VISITORNAME String String(size = 0), FIRSTCSID Int32 Int32(size = 0), JOINCSIDS String String(size = 0), PRECSID Int32 Int32(size = 0), FIRSTVISITTIME DateTime UInt32(size = 0), PREVISITTIME DateTime UInt32(size = 0), CURENTERTIME DateTime UInt32(size = 0), CURSTAYTIME Int32 Int32(size = 0), LEAVETIME DateTime UInt32(size = 0), TOTALVISITTIME Int32 Int32(size = 0), PREVISITPAGES Int32 Int32(size = 0), CURVISITORPAGES Int32 Int32(size = 0), VISITORSENDNUM Int32 Int32(size = 0), CSSENDNUM Int32 Int32(size = 0), SOURCEPROVINCE String String(size = 0), SOURCEIP String String(size = 0), SOURCEIPINFO String String(size = 0), SOURCEURL String String(size = 0), SOURCETYPE Int32 Int32(size = 0), SOURCEDOMAIN String String(size = 0), KEYWORD String String(size = 0), SOURCETEXT String String(size = 0), RESOLUTION String String(size = 0), DISPLAYCOLOR String String(size = 0), LANGUAGE String String(size = 0), OPERATINGSYSTEM String String(size = 0), BROWSER String String(size = 0), SERVICEEVALUATE String String(size = 0), REQUESTTYPE String String(size = 0), ENDTYPE String String(size = 0), DIALOGTYPE String String(size = 0), DIALONG Int32 Int32(size = 0), DIAENDTIME DateTime UInt32(size = 0), ACCEPTINVITE Int32 Int32(size = 0), REFUSEINVITE Int32 Int32(size = 0), DIRDIACOUNT Int32 Int32(size = 0), INFO String String(size = 0), STATUS Int8 Int8(size = 0), SITEID Int32 Int32(size = 0), SEARCHENGINE String String(size = 0), IFKEYWORD Int8 Int8(size = 0), IFATTACK Int8 Int8(size = 0), CURSITEDOMAIN String String(size = 0), DIAPAGE String String(size = 0), CURSTATUS Int8 Int8(size = 0), CONVERTTIME DateTime UInt32(size = 0), USERAGENT String String(size = 0), CURFIRSTVIEWPAGE String String(size = 0), TERMINALTYPE String String(size = 0), RECORDNUM Int32 Int32(size = 0), PRERECID Int32 Int32(size = 0), VIPID Int32 Int32(size = 0), DIALOGTIMES Int32 Int32(size = 0), COMPID Int32 Int32(size = 0), REVISEREMARK String String(size = 0), REVISEIPINFO String String(size = 0), SENSITIVEWORDS String String(size = 0), RTLONGEST Int32 Int32(size = 0), BIDWORD String String(size = 0), RTFIRST Int32 Int32(size = 0), KEYWORDALL String String(size = 0), RTAVG Int32 Int32(size = 0), KEYWORDDIALOG String String(size = 0) KEYWORD String String(size = 0), CURENTERDAY Date UInt16(size = 0), RECID Int32 Int32(size = 0), VISITORID FixedString(50) FixedString(size = 0), VISITORNAME String String(size = 0), FIRSTCSID Int32 Int32(size = 0), JOINCSIDS String String(size = 0), PRECSID Int32 Int32(size = 0), FIRSTVISITTIME DateTime UInt32(size = 0), PREVISITTIME DateTime UInt32(size = 0), CURENTERTIME DateTime UInt32(size = 0), CURSTAYTIME Int32 Int32(size = 0), LEAVETIME DateTime UInt32(size = 0), TOTALVISITTIME Int32 Int32(size = 0), PREVISITPAGES Int32 Int32(size = 0), CURVISITORPAGES Int32 Int32(size = 0), VISITORSENDNUM Int32 Int32(size = 0), CSSENDNUM Int32 Int32(size = 0), SOURCEPROVINCE String String(size = 0), SOURCEIP String String(size = 0), SOURCEIPINFO String String(size = 0), SOURCEURL String String(size = 0), SOURCETYPE Int32 Int32(size = 0), SOURCEDOMAIN String String(size = 0), SOURCETEXT String String(size = 0), RESOLUTION String String(size = 0), DISPLAYCOLOR String String(size = 0), LANGUAGE String String(size = 0), OPERATINGSYSTEM String String(size = 0), BROWSER String String(size = 0), SERVICEEVALUATE String String(size = 0), REQUESTTYPE String String(size = 0), ENDTYPE String String(size = 0), DIALOGTYPE String String(size = 0), DIALONG Int32 Int32(size = 0), DIAENDTIME DateTime UInt32(size = 0), ACCEPTINVITE Int32 Int32(size = 0), REFUSEINVITE Int32 Int32(size = 0), DIRDIACOUNT Int32 Int32(size = 0), INFO String String(size = 0), STATUS Int8 Int8(size = 0), SITEID Int32 Int32(size = 0), SEARCHENGINE String String(size = 0), IFKEYWORD Int8 Int8(size = 0), IFATTACK Int8 Int8(size = 0), CURSITEDOMAIN String String(size = 0), DIAPAGE String String(size = 0), CURSTATUS Int8 Int8(size = 0), CONVERTTIME DateTime UInt32(size = 0), USERAGENT String String(size = 0), CURFIRSTVIEWPAGE String String(size = 0), TERMINALTYPE String String(size = 0), RECORDNUM Int32 Int32(size = 0), PRERECID Int32 Int32(size = 0), VIPID Int32 Int32(size = 0), DIALOGTIMES Int32 Int32(size = 0), COMPID Int32 Int32(size = 0), REVISEREMARK String String(size = 0), REVISEIPINFO String String(size = 0), SENSITIVEWORDS String String(size = 0), RTLONGEST Int32 Int32(size = 0), BIDWORD String String(size = 0), RTFIRST Int32 Int32(size = 0), KEYWORDALL String String(size = 0), RTAVG Int32 Int32(size = 0), KEYWORDDIALOG String String(size = 0), e.what() = DB::Exception

回到顶部