Psst.. new poll here.
you@paste.org web/email now available. Want one? Go here.
Cannot use outlook/hotmail/live here to register as they blocking our mail servers. #microsoftdeez
Obey the Epel!
Paste
Pasted as SQL by registered user vvillacorta ( 1 year ago )
DROP TABLE IF EXISTS d_mdl_vpc_disc.SEGUIMIENTO_BASES_TELEFONOS -- No correr si ya se lee bien la data CREATE EXTERNAL TABLE d_mdl_vpc_disc.SEGUIMIENTO_BASES_TELEFONOS ( `gestion` string, `tipo_ruc` string, `conteo` int, `conteo_ruc_unico` int, `tlf_total_posible_mes` int, `tlf_flg_activo_mes` int, `ruc_flg_activo_mes` int, `tlf_ya_llamado_u18m` int, `ruc_tlf_ya_llamado_u18m` int, `tlf_fresco_u18m` int, `ruc_tlf_fresco_u18m` int, `tlf_desaparecido` int, `ruc_tlf_desaparecido` int, `tlf_fue_ce` int, `ruc_fue_ce` int, `tlf_fue_nc` int, `ruc_fue_nc` int, `fecproceso` string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION 's3://sagemaker-us-east-1-058528764918/vpc/contactabilidad/sagemaker/base_telefonos_ructelf/' TBLPROPERTIES ( 'skip.header.line.count'='1', 'has_encrypted_data'='false' );
Revise this Paste