Schema Info
Schema Name: sfdl_prod_csv.payrixess_mms_monthly_summary
- created: 2024-07-24 10:21:33
- disabled: False
- format: raw
- id: 1965
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_csv", "table": "payrixess_mms_monthly_summary" } - type: csv
Schema Versions: 15
-
Version 1718263
- created: 2026-04-17 09:35:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-17/1776436513'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-17/1776436513
- id: 1718263
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 162178500
- updated: 2026-04-17 09:35:31
-
Version 1717058
- created: 2026-04-16 09:47:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-16/1776350831'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-16/1776350831
- id: 1717058
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 162122998
- updated: 2026-04-16 09:47:28
-
Version 1715833
- created: 2026-04-15 09:44:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-15/1776264269'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-15/1776264269
- id: 1715833
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 162067355
- updated: 2026-04-15 09:44:46
-
Version 1714620
- created: 2026-04-14 09:28:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-14/1776176920'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-14/1776176920
- id: 1714620
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 162011148
- updated: 2026-04-14 09:28:58
-
Version 1713442
- created: 2026-04-13 09:51:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-13/1776091797'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-13/1776091797
- id: 1713442
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161954323
- updated: 2026-04-13 09:52:12
-
Version 1712234
- created: 2026-04-12 09:38:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-12/1776004718'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-12/1776004718
- id: 1712234
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161903614
- updated: 2026-04-12 09:38:54
-
Version 1711006
- created: 2026-04-11 09:26:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-11/1775917612'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-11/1775917612
- id: 1711006
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161851934
- updated: 2026-04-11 09:27:12
-
Version 1709837
- created: 2026-04-10 09:28:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-10/1775831275'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-10/1775831275
- id: 1709837
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161797279
- updated: 2026-04-10 09:28:12
-
Version 1708693
- created: 2026-04-09 09:34:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-09/1775745248'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-09/1775745248
- id: 1708693
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161741424
- updated: 2026-04-09 09:34:22
-
Version 1707506
- created: 2026-04-08 09:31:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-08/1775658713'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-08/1775658713
- id: 1707506
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161686232
- updated: 2026-04-08 09:32:12
-
Version 1706338
- created: 2026-04-07 09:46:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-07/1775573181'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-07/1775573181
- id: 1706338
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161630693
- updated: 2026-04-07 09:46:40
-
Version 1705079
- created: 2026-04-06 09:26:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-06/1775485602'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-06/1775485602
- id: 1705079
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161572670
- updated: 2026-04-06 09:27:01
-
Version 1703893
- created: 2026-04-05 09:47:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-05/1775400455'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-05/1775400455
- id: 1703893
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161524059
- updated: 2026-04-05 09:48:07
-
Version 1702721
- created: 2026-04-04 09:37:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-04/1775313459'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-04/1775313459
- id: 1702721
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161471777
- updated: 2026-04-04 09:37:54
-
Version 1701513
- created: 2026-04-03 09:29:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-03/1775226535'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-03/1775226535
- id: 1701513
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 1965
- schema_scan_id: 161414309
- updated: 2026-04-03 09:29:12
Schema Scans: 15
Last at 2026-04-17 09:35:17
-
Scan 162178500
- duration: 0:00:14.358675
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162178500
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-17/1776436513", "key": "raw/mms_monthly_summary/2026-04-17/1776436513/ad33637e-09a6-4d9c-ac7a-2e408f24bb77.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 1221299587262487035, "service_name": "drive-thru", "span_id": 1987634841990887852, "trace_id": 1659763443130009508 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-17 09:35:17
- success: True
- trace_id: 1659763443130009508
-
Scan 162122998
- duration: 0:00:11.834564
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162122998
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-16/1776350831", "key": "raw/mms_monthly_summary/2026-04-16/1776350831/493f3fe5-207f-4b0f-ae21-d9880a6370f3.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 9215419138643730667, "service_name": "drive-thru", "span_id": 10540854889006299921, "trace_id": 4160898806127030824 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-16 09:47:16
- success: True
- trace_id: 4160898806127030824
-
Scan 162067355
- duration: 0:00:11.897970
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162067355
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-15/1776264269", "key": "raw/mms_monthly_summary/2026-04-15/1776264269/889882fa-976c-438c-909c-e3f5ddb5a33d.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 10597030881437064207, "service_name": "drive-thru", "span_id": 16859381275546709555, "trace_id": 2405117821374439674 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-15 09:44:35
- success: True
- trace_id: 2405117821374439674
-
Scan 162011148
- duration: 0:00:11.766754
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162011148
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-14/1776176920", "key": "raw/mms_monthly_summary/2026-04-14/1776176920/45fa6cce-a0b5-45fd-81c6-2b16e5cff4e0.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 13773243625241839517, "service_name": "drive-thru", "span_id": 15723545768593997514, "trace_id": 164381269902586066 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-14 09:28:46
- success: True
- trace_id: 164381269902586066
-
Scan 161954323
- duration: 0:00:14.397260
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161954323
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-13/1776091797", "key": "raw/mms_monthly_summary/2026-04-13/1776091797/1403d292-9c8d-4f49-9bff-f2b69e0a9b71.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 2305074691541413771, "service_name": "drive-thru", "span_id": 8295664508162186853, "trace_id": 2313370152605560580 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-13 09:51:58
- success: True
- trace_id: 2313370152605560580
-
Scan 161903614
- duration: 0:00:11.904500
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161903614
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-12/1776004718", "key": "raw/mms_monthly_summary/2026-04-12/1776004718/22b9fb1f-c15f-4404-bc20-b12fe4b5918a.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 11341381004364223414, "service_name": "drive-thru", "span_id": 7178731572674200082, "trace_id": 7572365433425732746 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-12 09:38:42
- success: True
- trace_id: 7572365433425732746
-
Scan 161851934
- duration: 0:00:14.260545
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161851934
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-11/1775917612", "key": "raw/mms_monthly_summary/2026-04-11/1775917612/8b15eb00-f5fd-4788-aec8-617d476918dc.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 10557709950695404614, "service_name": "drive-thru", "span_id": 17807199609178366179, "trace_id": 16587399893972472007 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-11 09:26:57
- success: True
- trace_id: 16587399893972472007
-
Scan 161797279
- duration: 0:00:11.820386
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161797279
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-10/1775831275", "key": "raw/mms_monthly_summary/2026-04-10/1775831275/6c097c24-3fd4-4d14-90e7-f3d270c9699b.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 14688208589992605847, "service_name": "drive-thru", "span_id": 886335102559547123, "trace_id": 10531868880276817932 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-10 09:28:01
- success: True
- trace_id: 10531868880276817932
-
Scan 161741424
- duration: 0:00:11.755155
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161741424
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-09/1775745248", "key": "raw/mms_monthly_summary/2026-04-09/1775745248/8ef89411-2ecb-44c7-98db-e8f1fb8e9c1c.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 10520003464595094513, "service_name": "drive-thru", "span_id": 5014730387134274789, "trace_id": 11123155070296356213 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-09 09:34:11
- success: True
- trace_id: 11123155070296356213
-
Scan 161686232
- duration: 0:00:14.284101
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161686232
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-08/1775658713", "key": "raw/mms_monthly_summary/2026-04-08/1775658713/925208d2-29ff-4e2c-b6de-c126ed1cc84e.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 2544130644197517043, "service_name": "drive-thru", "span_id": 14727288385556681142, "trace_id": 3289528424327468583 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-08 09:31:58
- success: True
- trace_id: 3289528424327468583
-
Scan 161630693
- duration: 0:00:14.344608
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161630693
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-07/1775573181", "key": "raw/mms_monthly_summary/2026-04-07/1775573181/2c49f7b5-5d4a-4629-b21a-48f80e9917dd.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 12853749081867021536, "service_name": "drive-thru", "span_id": 15007114896757039727, "trace_id": 15671821461691960567 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-07 09:46:26
- success: True
- trace_id: 15671821461691960567
-
Scan 161572670
- duration: 0:00:14.365063
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161572670
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-06/1775485602", "key": "raw/mms_monthly_summary/2026-04-06/1775485602/b2593c2c-a752-496e-87a2-f824888f52ec.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 18142366993077654643, "service_name": "drive-thru", "span_id": 3919220758916600692, "trace_id": 13041844745486691089 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-06 09:26:47
- success: True
- trace_id: 13041844745486691089
-
Scan 161524059
- duration: 0:00:14.319870
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161524059
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-05/1775400455", "key": "raw/mms_monthly_summary/2026-04-05/1775400455/413e061e-e4a8-4e2b-9f39-84f27990518c.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 6340329481787592551, "service_name": "drive-thru", "span_id": 13530473902962330554, "trace_id": 2719883764076441502 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-05 09:47:53
- success: True
- trace_id: 2719883764076441502
-
Scan 161471777
- duration: 0:00:11.716487
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161471777
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-04/1775313459", "key": "raw/mms_monthly_summary/2026-04-04/1775313459/18981d48-52e4-4cbd-bd99-d2aa8d34f597.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 1456145966113597765, "service_name": "drive-thru", "span_id": 12160611663483381385, "trace_id": 10498603681440641402 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-04 09:37:43
- success: True
- trace_id: 10498603681440641402
-
Scan 161414309
- duration: 0:00:11.800978
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161414309
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-prod", "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-03/1775226535", "key": "raw/mms_monthly_summary/2026-04-03/1775226535/496fba0b-2025-41ce-8767-fa0c9e400ea4.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 7587538466625229312, "service_name": "drive-thru", "span_id": 18280314063140922702, "trace_id": 13896681460953186075 } } - running: False
- schema_name_id: 1965
- start_time: 2026-04-03 09:29:00
- success: True
- trace_id: 13896681460953186075
- attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - created: 2026-04-17 09:35:17
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-17/1776436513'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2024-07-24 10:21:33",
"disabled": false,
"format": "raw",
"id": 1965,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_csv",
"table": "payrixess_mms_monthly_summary"
},
"type": "csv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"base": "string",
"count": "string",
"entity": "string",
"month": "string",
"sum": "string",
"tag": "string",
"year": "string"
},
"created": "2026-04-17 09:35:17",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` string , `tag` string , `count` string , `sum` 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-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-17/1776436513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}