Schema Info
Schema Name: sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset
- created: 2023-10-17 01:57:14
- disabled: False
- format: raw
- id: 1654
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_moloinstalmentspaymentmethodset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717609
- created: 2026-04-17 03:02:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-17/1776412732'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-17/1776412732
- id: 1717609
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 162167389
- updated: 2026-04-17 03:02:47
-
Version 1716344
- created: 2026-04-16 03:04:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-16/1776326491'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-16/1776326491
- id: 1716344
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 162111711
- updated: 2026-04-16 03:05:11
-
Version 1715187
- created: 2026-04-15 03:04:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-15/1776239960'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-15/1776239960
- id: 1715187
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 162055879
- updated: 2026-04-15 03:04:11
-
Version 1713968
- created: 2026-04-14 03:03:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-14/1776153687'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-14/1776153687
- id: 1713968
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 162000398
- updated: 2026-04-14 03:04:09
-
Version 1712747
- created: 2026-04-13 02:56:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-13/1776066880'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-13/1776066880
- id: 1712747
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161941544
- updated: 2026-04-13 02:57:08
-
Version 1711552
- created: 2026-04-12 02:59:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-12/1775980595'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-12/1775980595
- id: 1711552
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161892408
- updated: 2026-04-12 02:59:21
-
Version 1710324
- created: 2026-04-11 03:00:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-11/1775894356'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-11/1775894356
- id: 1710324
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161840968
- updated: 2026-04-11 03:01:08
-
Version 1709279
- created: 2026-04-10 03:07:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-10/1775808112'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-10/1775808112
- id: 1709279
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161785972
- updated: 2026-04-10 03:07:36
-
Version 1708075
- created: 2026-04-09 03:01:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-09/1775721451'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-09/1775721451
- id: 1708075
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161730062
- updated: 2026-04-09 03:01:38
-
Version 1706857
- created: 2026-04-08 03:03:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-08/1775635259'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-08/1775635259
- id: 1706857
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161675435
- updated: 2026-04-08 03:03:42
-
Version 1705674
- created: 2026-04-07 02:55:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-07/1775548432'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-07/1775548432
- id: 1705674
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161618358
- updated: 2026-04-07 02:56:05
-
Version 1704571
- created: 2026-04-06 03:09:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-06/1775462400'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-06/1775462400
- id: 1704571
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161561697
- updated: 2026-04-06 03:09:13
-
Version 1703298
- created: 2026-04-05 03:04:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-05/1775376023'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-05/1775376023
- id: 1703298
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161514875
- updated: 2026-04-05 03:05:10
-
Version 1702075
- created: 2026-04-04 03:01:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-04/1775289506'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-04/1775289506
- id: 1702075
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161459978
- updated: 2026-04-04 03:01:53
-
Version 1700886
- created: 2026-04-03 03:07:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-03/1775203279'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-03/1775203279
- id: 1700886
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1654
- schema_scan_id: 161401816
- updated: 2026-04-03 03:07:41
Schema Scans: 15
Last at 2026-04-17 03:02:33
-
Scan 162167389
- duration: 0:00:14.042685
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167389
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-17/1776412732", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-17/1776412732/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15794478613742109482, "service_name": "drive-thru", "span_id": 4421132710952506721, "trace_id": 16923949864762406375 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-17 03:02:33
- success: True
- trace_id: 16923949864762406375
-
Scan 162111711
- duration: 0:00:14.003981
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111711
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-16/1776326491", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-16/1776326491/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10793424951635272847, "service_name": "drive-thru", "span_id": 13510228165616099193, "trace_id": 11999560999312889235 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-16 03:04:57
- success: True
- trace_id: 11999560999312889235
-
Scan 162055879
- duration: 0:00:11.692948
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055879
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-15/1776239960", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-15/1776239960/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4415016627343895927, "service_name": "drive-thru", "span_id": 16735663506786934266, "trace_id": 16326387779843547408 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-15 03:03:59
- success: True
- trace_id: 16326387779843547408
-
Scan 162000398
- duration: 0:00:14.213179
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000398
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-14/1776153687", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-14/1776153687/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14076138678738274415, "service_name": "drive-thru", "span_id": 13519117661363186564, "trace_id": 5835152087060685514 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-14 03:03:55
- success: True
- trace_id: 5835152087060685514
-
Scan 161941544
- duration: 0:00:14.009970
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941544
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-13/1776066880", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-13/1776066880/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2191410122049769998, "service_name": "drive-thru", "span_id": 11952491074833769278, "trace_id": 14484868818951701857 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-13 02:56:54
- success: True
- trace_id: 14484868818951701857
-
Scan 161892408
- duration: 0:00:17.948348
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892408
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-12/1775980595", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-12/1775980595/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15305271666145401462, "service_name": "drive-thru", "span_id": 182076623056880550, "trace_id": 10306564706728613369 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-12 02:59:03
- success: True
- trace_id: 10306564706728613369
-
Scan 161840968
- duration: 0:00:11.514003
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161840968
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-11/1775894356", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-11/1775894356/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12152571037993793095, "service_name": "drive-thru", "span_id": 11804991172095020162, "trace_id": 7306944669715696196 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-11 03:00:57
- success: True
- trace_id: 7306944669715696196
-
Scan 161785972
- duration: 0:00:11.431491
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785972
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-10/1775808112", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-10/1775808112/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16840165161399814720, "service_name": "drive-thru", "span_id": 3993597298338372965, "trace_id": 3959754622961956148 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-10 03:07:24
- success: True
- trace_id: 3959754622961956148
-
Scan 161730062
- duration: 0:00:11.613676
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730062
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-09/1775721451", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-09/1775721451/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 818232164380859797, "service_name": "drive-thru", "span_id": 14974177690697030803, "trace_id": 6931384121404955202 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-09 03:01:26
- success: True
- trace_id: 6931384121404955202
-
Scan 161675435
- duration: 0:00:11.433770
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675435
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-08/1775635259", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-08/1775635259/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17307296835526599064, "service_name": "drive-thru", "span_id": 10599055437392497602, "trace_id": 5027713537969275686 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-08 03:03:31
- success: True
- trace_id: 5027713537969275686
-
Scan 161618358
- duration: 0:00:13.935403
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618358
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-07/1775548432", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-07/1775548432/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9060764311801175279, "service_name": "drive-thru", "span_id": 5985067610499327564, "trace_id": 7016143716001453354 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-07 02:55:52
- success: True
- trace_id: 7016143716001453354
-
Scan 161561697
- duration: 0:00:11.646290
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561697
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-06/1775462400", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-06/1775462400/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15924498423755430995, "service_name": "drive-thru", "span_id": 7006528043097309411, "trace_id": 15596890884676346271 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-06 03:09:02
- success: True
- trace_id: 15596890884676346271
-
Scan 161514875
- duration: 0:00:11.535424
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514875
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-05/1775376023", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-05/1775376023/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17136425080642678864, "service_name": "drive-thru", "span_id": 10462848344885844328, "trace_id": 3368426885540521247 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-05 03:04:58
- success: True
- trace_id: 3368426885540521247
-
Scan 161459978
- duration: 0:00:14.055583
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161459978
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-04/1775289506", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-04/1775289506/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4128948253141903082, "service_name": "drive-thru", "span_id": 1756857293482028793, "trace_id": 7481999847213867818 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-04 03:01:39
- success: True
- trace_id: 7481999847213867818
-
Scan 161401816
- duration: 0:00:11.531484
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401816
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-03/1775203279", "key": "raw/molo_moloInstalmentsPaymentMethodSet/2026-04-03/1775203279/InstalmentsPaymentMethodSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloInstalmentsPaymentMethodSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17361001962434049442, "service_name": "drive-thru", "span_id": 2432179891747974595, "trace_id": 3383937636828051751 } } - running: False
- schema_name_id: 1654
- start_time: 2026-04-03 03:07:30
- success: True
- trace_id: 3383937636828051751
- attributes:
{ "Id": "string", "Name": "string" } - created: 2026-04-17 03:02:33
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-17/1776412732'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-10-17 01:57:14",
"disabled": false,
"format": "raw",
"id": 1654,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_moloinstalmentspaymentmethodset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Id": "string",
"Name": "string"
},
"created": "2026-04-17 03:02:33",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`\n(\n `Id` string , `Name` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInstalmentsPaymentMethodSet/2026-04-17/1776412732'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinstalmentspaymentmethodset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}