ClickHouse: [Exception] DB::Exception: Block structure mismatch in UNION stream: different number of columns

env

  • clickhosue-server:version 1.1.54370
  • centerlog is a distributed table

table structure

table centerlog ( 
  type String,
  date Date,
  time DateTime,
  appname String,
  module String,
  category String,
  subcategory String,
  filter1 String,
  filter2 String,
  message String,
  errormessage String
)  

select some field, throw error

SELECT time
FROM centerlog 
WHERE date = toDate('2018-04-02')
LIMIT 1

Received exception from server (version 1.1.54370):
Code: 171. DB::Exception: Received from 10.12.180.113. DB::Exception: Block structure mismatch in UNION stream: different number of columns:
date Date UInt16(size = 0), time DateTime UInt32(size = 0)
time DateTime UInt32(size = 0). 

select asterisk *, no problem


SELECT *
FROM centerlog
WHERE date = toDate('2018-04-02')
LIMIT 1

┌─type─┬───────date─┬────────────────time─┬─appname───────────────┬─module─────┬─category────┬─subcategory─┬─filter1──────────────────────┬─filter2─┬─message─────────────────────────────────────────────────────────────────┬─errormessage─┐
│ Info │ 2018-04-02 │ 2018-04-02 12:58:36 │ tcwireservice │ WxRTime │ notUseBs │             │ ohmdjVHx-rpLDY │         │ -G9NoljVHx-rpLDY, userInfo: null │              │
└──────┴────────────┴─────────────────────┴───────────────────────┴────────────┴─────────────┴─────────────┴──────────────────────────────┴─────────┴─────────────────────────────────────────────────────────────────────────┴──────────────┘

About this issue

  • Original URL
  • State: closed
  • Created 6 years ago
  • Comments: 17 (6 by maintainers)

Commits related to this issue

Most upvoted comments

This is still happening for me on 1.1.54388 😦