import sys
from awsglue.transforms import *
from awsglue.utils import getResolvedOptions
from pyspark.context import SparkContext
from awsglue.context import GlueContext
from awsglue.job import Job
glueContext = GlueContext(sc)
spark = glueContext.spark_session
job = Job(glueContext)
datasource0 = glueContext.create_dynamic_frame.from_catalog(database = "apps_community_olap_stg", table_name = "fe_glueapps_community_olap_stg_fe_adm_city_vm", transformation_ctx = "datasource0")
datasource1 = glueContext.create_dynamic_frame.from_catalog(database = "apps_community_olap_stg", table_name = "fe_glueapps_community_olap_stg_fe_adm_state_vm")
datasource1 = datasource1.drop_field(['state_code', 'state_name', 'active', 'client', 'legislation']).rename_field('id', 'state_id').rename_field('country','country_id')
l_result= Join.apply(datasource0, datasource1, 'state_code', 'state_code').drop_field(['city_code','country_code','state-code','client', 'legislation'])
l_result.printSchema()
aW1wb3J0IHN5cwpmcm9tIGF3c2dsdWUudHJhbnNmb3JtcyBpbXBvcnQgKgpmcm9tIGF3c2dsdWUudXRpbHMgaW1wb3J0IGdldFJlc29sdmVkT3B0aW9ucwpmcm9tIHB5c3BhcmsuY29udGV4dCBpbXBvcnQgU3BhcmtDb250ZXh0CmZyb20gYXdzZ2x1ZS5jb250ZXh0IGltcG9ydCBHbHVlQ29udGV4dApmcm9tIGF3c2dsdWUuam9iIGltcG9ydCBKb2IKZ2x1ZUNvbnRleHQgPSBHbHVlQ29udGV4dChzYykKc3BhcmsgPSBnbHVlQ29udGV4dC5zcGFya19zZXNzaW9uCmpvYiA9IEpvYihnbHVlQ29udGV4dCkKZGF0YXNvdXJjZTAgPSBnbHVlQ29udGV4dC5jcmVhdGVfZHluYW1pY19mcmFtZS5mcm9tX2NhdGFsb2coZGF0YWJhc2UgPSAiYXBwc19jb21tdW5pdHlfb2xhcF9zdGciLCB0YWJsZV9uYW1lID0gImZlX2dsdWVhcHBzX2NvbW11bml0eV9vbGFwX3N0Z19mZV9hZG1fY2l0eV92bSIsIHRyYW5zZm9ybWF0aW9uX2N0eCA9ICJkYXRhc291cmNlMCIpCgpkYXRhc291cmNlMSA9IGdsdWVDb250ZXh0LmNyZWF0ZV9keW5hbWljX2ZyYW1lLmZyb21fY2F0YWxvZyhkYXRhYmFzZSA9ICJhcHBzX2NvbW11bml0eV9vbGFwX3N0ZyIsIHRhYmxlX25hbWUgPSAiZmVfZ2x1ZWFwcHNfY29tbXVuaXR5X29sYXBfc3RnX2ZlX2FkbV9zdGF0ZV92bSIpCmRhdGFzb3VyY2UxID0gZGF0YXNvdXJjZTEuZHJvcF9maWVsZChbJ3N0YXRlX2NvZGUnLCAnc3RhdGVfbmFtZScsICdhY3RpdmUnLCAnY2xpZW50JywgJ2xlZ2lzbGF0aW9uJ10pLnJlbmFtZV9maWVsZCgnaWQnLCAnc3RhdGVfaWQnKS5yZW5hbWVfZmllbGQoJ2NvdW50cnknLCdjb3VudHJ5X2lkJykKCmxfcmVzdWx0PSAgSm9pbi5hcHBseShkYXRhc291cmNlMCwgZGF0YXNvdXJjZTEsICdzdGF0ZV9jb2RlJywgJ3N0YXRlX2NvZGUnKS5kcm9wX2ZpZWxkKFsnY2l0eV9jb2RlJywnY291bnRyeV9jb2RlJywnc3RhdGUtY29kZScsJ2NsaWVudCcsICdsZWdpc2xhdGlvbiddKQpsX3Jlc3VsdC5wcmludFNjaGVtYSgp