Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
[email protected] webmail 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 Python by registered user vvillacorta ( 10 months 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'
    );
    
    SELECT * FROM d_mdl_vpc_disc.SEGUIMIENTO_BASES_TELEFONOS LIMIT 100

 

Revise this Paste

Your Name: Code Language: