CREATE TABLE mdc_appdev_lifeflux.mdc_flx_events_procedures_icd
PARTITIONED BY (internalpatientid)
STORED AS PARQUET
AS
select insertDate, dateOfEvent, eventXML, internalpatientid
from (
SELECT
now() insertDate,
procedures_icd.startdate dateOfEvent,
CONCAT
(
'
'Alias="','procedures_icd', '" ',
'Age="', cast(procedures_icd.ageatevent as varchar(23)), '" ',
'Time="', cast(procedures_icd.startdate as varchar(23)), '">',
'
''
) eventXML,
procedures_icd.internalpatientid internalpatientId
FROM
mimic_db.procedures_icd INNER JOIN mimic_db.demographics_static
ON (mimic_db.procedures_icd.internalpatientid=mimic_db.demographics_static.internalpatientid)
) tbl;