Orrin
SELECT Volume FROM smallTable WHERE TradeDate = '2022-02-04T00:00:00.000000Z' AND RIC = 'SPXWb042245500.U' EXCEPT SELECT Volume FROM HJGIHL WHERE TradeDate = '2022-02-04T00:00:00.000000Z' AND RIC = 'SPXWb042245500.U';
weirdly though, when I run each side of the EXCEPT independently, I see that the single value returns to be identical.
is this a bug or am i missing some behavioral quirk?select * from smallTable WHERE TradeDate = '2022-02-04T00:00:00.000000Z' AND RIC = 'SPXWb042245500.U';
i get a result that has apparently two identical rows.Bolek Ziobrowski
create table t1 (
  TradeDate timestamp,
  Open double,
  High double,
  Low double,
  Last double,
  Volume double,
  Bid double,
  Ask double,
  RIC string,
  SettlementPrice double
);
insert into t1 values
(
  '2022-02-04T00:00:00.000000Z',11.6800,14.0000,0.0500,0.0500,56905.9968, null,0.0500,'SPXWb042245500.U', null
);
select * from t1;
create table t2 (
  TradeDate timestamp,
  Open double,
  High double,
  Low double,
  Last double,
  Volume double,
  Bid double,
  Ask double,
  RIC string,
  SettlementPrice double
);
insert into t2 values
(
  '2022-02-04T00:00:00.000000Z',11.6800,14.0000,0.0500,0.0500,56905.9968, null,0.0500,'SPXWb042245500.U', null
);
select * from t2;
select * from t1 except select * from t2 ;
Could you try subtracting these seemingly identical floating point values ?
Something like :select t1.Open - t2.Open,
t1.High-t2.High, ...
from t1 join t2 on 1=1 ;
Orrin
Bolek Ziobrowski
Orrin
Bolek Ziobrowski
Orrin