Estimated Per-Host Requirements: Memory=464.00MB VCores=2
WARNING: The following tables are missing relevant table and/or column statistics.
trivago_analytic.session_stats_master

11:MERGING-EXCHANGE [UNPARTITIONED]
|  order by: ymd ASC, date_id ASC
|
09:SORT
|  order by: ymd ASC, date_id ASC
|
08:ANALYTIC
|  functions: lead(unix_timestamp(concat(CAST(ymd AS STRING), CAST(time AS STRING)), 'yyyyMMddHH:mm:ss'), 1, NULL), lead(from_unixtime(unix_timestamp(concat(CAST(ymd AS STRING), CAST(time AS STRING)), 'yyyyMMddHH:mm:ss')), 1, NULL), lead(ymd, 1, NULL), lead(time, 1, NULL)
|  partition by: ssm.tracking_int_id
|  order by: date_id ASC
|  window: ROWS BETWEEN UNBOUNDED PRECEDING AND 1 FOLLOWING
|
07:SORT
|  order by: tracking_int_id ASC NULLS FIRST, date_id ASC
|
10:EXCHANGE [HASH(ssm.tracking_int_id)]
|
01:SUBPLAN
|
|--06:HASH JOIN [INNER JOIN]
|  |  hash predicates: cl.date_id = pl.date_id
|  |
|  |--04:UNNEST [ssm.page_log_entries pl]
|  |
|  05:NESTED LOOP JOIN [CROSS JOIN]
|  |
|  |--02:SINGULAR ROW SRC
|  |
|  03:UNNEST [ssm.co_log_entries cl]
|
00:SCAN HDFS [trivago_analytic.session_stats_master ssm]
   partitions=3/3178 files=384 size=59.97GB
   predicates: ssm.crawler_id = 0, !empty(ssm.co_log_entries), !empty(ssm.page_log_entries)
   predicates on cl: cl.page_id = 8001