Hi @Kaliyug Antagonist. I couldn't help but notice that the value in question had a leading zero. Check the datatype used for the column called equipmentNumber and adjust the IN clause accordingly. It looks like equipmentNumber is defined as a String and thus you will have to quote the values inside the "IN" clause. Here are some examples & results: 1. Using INT as the datatype for equipmentNumber: create table if not exists fact_rtc_se
(equipmentnumber int, dimensionid string, datemessage date) ;
insert into fact_rtc_se values (0552094, 36081, '2016-02-29') ;
insert into fact_rtc_se values (0552094, 18943, '2016-02-29') ;
insert into fact_rtc_se values (1857547, 27956, '2016-01-08') ;
insert into fact_rtc_se values (1857547, 749597, '2016-01-15') ;
select equipmentnumber, dimensionid, datemessage from fact_rtc_se
where equipmentnumber in (0552094,1857547) and datemessage < '2016-03-01';
552094 36081 2016-02-29
552094 18943 2016-02-29
1857547 27956 2016-01-08
1857547 749597 2016-01-15
select equipmentnumber, dimensionid, datemessage from fact_rtc_se
where equipmentnumber in ('0552094','1857547') and datemessage < '2016-03-01';
1857547 27956 2016-01-08
1857547 749597 2016-01-15
2. Using STRING as the datatype for equipmentNumber: create table if not exists fact_rtc_se
(equipmentnumber string, dimensionid string, datemessage date) ;
insert into fact_rtc_se values ('0552094', 36081, '2016-02-29') ;
insert into fact_rtc_se values ('0552094', 18943, '2016-02-29') ;
insert into fact_rtc_se values ('1857547', 27956, '2016-01-08') ;
insert into fact_rtc_se values ('1857547', 749597, '2016-01-15') ;
select equipmentnumber, dimensionid, datemessage from fact_rtc_se
where equipmentnumber in (0552094,1857547) and datemessage < '2016-03-01';
1857547 27956 2016-01-08
1857547 749597 2016-01-15
select equipmentnumber, dimensionid, datemessage from fact_rtc_se
where equipmentnumber in ('0552094','1857547') and datemessage < '2016-03-01';
0552094 36081 2016-02-29
0552094 18943 2016-02-29
1857547 27956 2016-01-08
1857547 749597 2016-01-15
I hope this helps.
... View more
