[Amazon](500310) Invalid operation: Invalid digit, Value '-', Pos 4, Type:    Long
Details:
 -----------------------------------------------
  error:  Invalid digit, Value '-', Pos 4, Type: Long
  code:      1207
  context:   2018-12-13T10:16:42.047Z
  query:     5702235
  location:  :0
  process:   query11_873_5702235 [pid=0]
 -----------------------------------------------

with odsn as
(select dsn
, order_day
, asin
, marketplace_id
, order_id
, is_free_replacement
, customer_id
FROM deeplens.d_shipment_items_hash),

ddsn as
(select device_serial_number
, date(date_add('ms'::text, create_date::bigint, '1970-01-01 00:00:00'::timestamp without time zone)) as reg_date
from deeplens.deeplens_dsn ddsn)

select odsn.dsn
, odsn.order_day
, odsn.asin
, odsn.marketplace_id
, odsn.order_id
, odsn.is_free_replacement
, odsn.customer_id
, ddsn.device_serial_number
, ddsn.reg_date
 FROM odsn
 JOIN ddsn
 ON odsn.dsn = ddsn.device_serial_number;