td_intern criteo

minmax.sql

--presto
DROP TABLE IF EXISTS minmax;
CREATE TABLE minmax as
WITH t1 as (
  select 
  min(l1) as min_l1,max(l1) as max_l1,min(l2) as min_l2,max(l2) as max_l2,min(l3) as min_l3,max(l3) as max_l3,min(l4) as min_l4,max(l4) as max_l4,min(l5) as min_l5,max(l5) as max_l5,min(l6) as min_l6,max(l6) as max_l6,min(l7) as min_l7,max(l7) as max_l7,min(l8) as min_l8,max(l8) as max_l8,min(l9) as min_l9,max(l9) as max_l9,min(l10) as min_l10,max(l10) as max_l10,min(l11) as min_l11,max(l11) as max_l11,min(l12) as min_l12,max(l12) as max_l12,min(l13) as min_l13,max(l13) as max_l13
  from
    train_ordered
  union all
  select
  min(l1) as min_l1,max(l1) as max_l1,min(l2) as min_l2,max(l2) as max_l2,min(l3) as min_l3,max(l3) as max_l3,min(l4) as min_l4,max(l4) as max_l4,min(l5) as min_l5,max(l5) as max_l5,min(l6) as min_l6,max(l6) as max_l6,min(l7) as min_l7,max(l7) as max_l7,min(l8) as min_l8,max(l8) as max_l8,min(l9) as min_l9,max(l9) as max_l9,min(l10) as min_l10,max(l10) as max_l10,min(l11) as min_l11,max(l11) as max_l11,min(l12) as min_l12,max(l12) as max_l12,min(l13) as min_l13,max(l13) as max_l13
  from
    test_ordered
)
select
min(min_l1) as min_l1, max(max_l1) as max_l1, min(min_l2) as min_l2,max(max_l2) as max_l2, min(min_l3) as min_l3,max(max_l3) as max_l3, min(min_l4) as min_l4, max(max_l4) as max_l4, min(min_l5) as min_l5, max(max_l5) as max_l5, min(min_l6) as min_l6, max(max_l6) as max_l6, min(min_l7) as min_l7,max(max_l7) as max_l7, min(min_l8) as min_l8, max(max_l8) as max_l8, min(min_l9) as min_l9, max(max_l9) as max_l9, min(min_l10) as min_l10, max(max_l10) as max_l10, min(min_l11) as min_l11, max(max_l11) as max_l11, min(min_l12) as min_l12, max(max_l12) as max_l12, min(min_l13) as min_l13, max(max_l13) as max_l13
from
  t1
;