· 8 years ago · Mar 21, 2018, 11:10 AM
1create table if not exists default.testCase (
2 date Date,
3 login String,
4 value Int32
5)
6engine=MergeTree(date, login, 8192)
7;;
8insert into default.testCase (date, login, value) values ('2018-03-21', 'nekufa', '1')
9;;
10select * from default.testCase where date in ('2018-03-21') and login in ('1')