Paste code

CREATE EXTERNAL TABLE `d_mdl_vpc_disc.HM_NUEVO_MES_AGENDA_CREDITOS_CAMPANIAS`(
  `num_doc` string COMMENT &#039;&#039;, 
  `cod_sbs_val` string COMMENT &#039;&#039;, 
  `cod_sbs` string COMMENT &#039;&#039;, 
  `periodo_val` string COMMENT &#039;&#039;, 
  `numruc_val` string COMMENT &#039;&#039;, 
  `cod_unico_val` string COMMENT &#039;&#039;, 
  `tip_contribuyente_val` string COMMENT &#039;&#039;, 
  `tip_persona_val` string COMMENT &#039;&#039;, 
  `condicion_domicilio` string COMMENT &#039;&#039;, 
  `estado_contribuyente` string COMMENT &#039;&#039;, 
  `contabilidad` string COMMENT &#039;&#039;, 
  `facturacion` string COMMENT &#039;&#039;, 
  `comercio_exterior` string COMMENT &#039;&#039;, 
  `estado` string COMMENT &#039;&#039;, 
  `ciiu_val` string COMMENT &#039;&#039;, 
  `ubigeo_val` string COMMENT &#039;&#039;, 
  `num_trabajadores` int COMMENT &#039;&#039;, 
  `monto_deuda_tributo_amt` decimal(18,3) COMMENT &#039;&#039;, 
  `cnt_deudas_tributarias` int COMMENT &#039;&#039;, 
  `cnt_rrll` int COMMENT &#039;&#039;, 
  `tiempo_baja` decimal(18,2) COMMENT &#039;&#039;, 
  `tiempo_alta` decimal(18,2) COMMENT &#039;&#039;, 
  `promedio_edad_rrll` decimal(18,3) COMMENT &#039;&#039;, 
  `tenencia_maxima_rrll` int COMMENT &#039;&#039;, 
  `banca_fin_val` string COMMENT &#039;&#039;, 
  `nro_entidades` int COMMENT &#039;&#039;, 
  `rango_ventas` decimal(22,4) COMMENT &#039;&#039;, 
  `saldo_coloc_direct_tc` decimal(18,3) COMMENT &#039;&#039;, 
  `nroregs_coloc_directas_bcos` int COMMENT &#039;&#039;, 
  `porc_coloc_direct_vig_cmpt` decimal(18,3) COMMENT &#039;&#039;, 
  `facturacion_prom_ult9m_mnt` double COMMENT &#039;&#039;, 
  `deuda_sf_prom_ult9m` double COMMENT &#039;&#039;, 
  `tend_facturacion_ult_trim_mnt` double COMMENT &#039;&#039;, 
  `tend_facturacion_ult_mes_mnt` double COMMENT &#039;&#039;, 
  `tend_deuda_agrar_ult_trim_mnt` double COMMENT &#039;&#039;, 
  `tend_deuda_agrar_ult_mes_mnt` double COMMENT &#039;&#039;, 
  `tend_deuda_sf_ult_trim_mnt` double COMMENT &#039;&#039;, 
  `monto_adquirido_u6_amt` double COMMENT &#039;&#039;, 
  `monto_pagado_ult_rcc_amt` double COMMENT &#039;&#039;, 
  `monto_pagado_u3_amt` double COMMENT &#039;&#039;, 
  `monto_pagado_u6_amt` double COMMENT &#039;&#039;, 
  `saldo_coloc_vig_otros_bancos_amt` double COMMENT &#039;&#039;, 
  `sow_ibk` double COMMENT &#039;&#039;, 
  `sow_otros_bancos` double COMMENT &#039;&#039;, 
  `sow_cajas` double COMMENT &#039;&#039;, 
  `tendencia_nro_entidades_v2` decimal(18,4) COMMENT &#039;&#039;, 
  `tendencia_nro_coloc_direct_bancos_v2` decimal(18,4) COMMENT &#039;&#039;, 
  `prom_reactiva_u6m` double COMMENT &#039;&#039;, 
  `prom_gar_u12m` double COMMENT &#039;&#039;)
PARTITIONED BY ( 
  `p_periodo_v` string COMMENT &#039;&#039;)
ROW FORMAT SERDE 
  &#039;org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe&#039; 
STORED AS INPUTFORMAT 
  &#039;org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat&#039; 
OUTPUTFORMAT 
  &#039;org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat&#039;
LOCATION
  &#039;s3://sagemaker-us-east-1-058528764918/vpc/propension/athena/HM_NUEVO_MES_AGENDA_CREDITOS_CAMPANIAS/&#039;
TBLPROPERTIES (
  &#039;has_encrypted_data&#039;=&#039;false&#039;, 
  &#039;parquet.compression&#039;=&#039;SNAPPY&#039;, 
  &#039;presto_query_id&#039;=&#039;20220331_213952_00103_w9qm9&#039;)