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 │ │
└──────┴────────────┴─────────────────────┴───────────────────────┴────────────┴─────────────┴─────────────┴──────────────────────────────┴─────────┴─────────────────────────────────────────────────────────────────────────┴──────────────┘
This is still happening for me on 1.1.54388 😦