Schema Info
Schema Name: sfdl_prod_csv.payrix_mms_monthly_summary
- created: 2024-07-10 09:32:06
- disabled: False
- format: raw
- id: 1914
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_csv", "table": "payrix_mms_monthly_summary" } - type: csv
Schema Versions: 15
-
Version 1718235
- created: 2026-04-17 09:26:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012
- id: 1718235
- 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: 1914
- schema_scan_id: 162178346
- updated: 2026-04-17 09:27:09
-
Version 1717017
- created: 2026-04-16 09:27:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-16/1776349628'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-16/1776349628
- id: 1717017
- 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: 1914
- schema_scan_id: 162122654
- updated: 2026-04-16 09:27:24
-
Version 1715885
- created: 2026-04-15 11:28:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-15/1776270463'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-15/1776270463
- id: 1715885
- 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: 1914
- schema_scan_id: 162072820
- updated: 2026-04-15 11:28:23
-
Version 1714943
- created: 2026-04-14 21:06:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-14/1776218795'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-14/1776218795
- id: 1714943
- 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: 1914
- schema_scan_id: 162046338
- updated: 2026-04-14 21:07:03
-
Version 1713443
- created: 2026-04-13 09:52:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-13/1776091773'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-13/1776091773
- id: 1713443
- 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: 1914
- schema_scan_id: 161954352
- updated: 2026-04-13 09:52:25
-
Version 1712250
- created: 2026-04-12 09:44:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-12/1776005072'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-12/1776005072
- id: 1712250
- 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: 1914
- schema_scan_id: 161903650
- updated: 2026-04-12 09:44:48
-
Version 1711026
- created: 2026-04-11 09:43:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-11/1775918610'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-11/1775918610
- id: 1711026
- 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: 1914
- schema_scan_id: 161852103
- updated: 2026-04-11 09:43:47
-
Version 1709860
- created: 2026-04-10 09:46:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-10/1775832251'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-10/1775832251
- id: 1709860
- 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: 1914
- schema_scan_id: 161797549
- updated: 2026-04-10 09:46:28
-
Version 1708675
- created: 2026-04-09 09:27:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-09/1775744866'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-09/1775744866
- id: 1708675
- 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: 1914
- schema_scan_id: 161741333
- updated: 2026-04-09 09:28:01
-
Version 1707535
- created: 2026-04-08 09:50:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-08/1775659658'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-08/1775659658
- id: 1707535
- 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: 1914
- schema_scan_id: 161686836
- updated: 2026-04-08 09:50:23
-
Version 1706334
- created: 2026-04-07 09:45:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-07/1775573123'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-07/1775573123
- id: 1706334
- 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: 1914
- schema_scan_id: 161630624
- updated: 2026-04-07 09:45:42
-
Version 1705084
- created: 2026-04-06 09:30:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-06/1775485806'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-06/1775485806
- id: 1705084
- 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: 1914
- schema_scan_id: 161572758
- updated: 2026-04-06 09:30:28
-
Version 1703887
- created: 2026-04-05 09:45:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-05/1775400344'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-05/1775400344
- id: 1703887
- 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: 1914
- schema_scan_id: 161523963
- updated: 2026-04-05 09:45:59
-
Version 1702746
- created: 2026-04-04 10:03:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-04/1775314917'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-04/1775314917
- id: 1702746
- 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: 1914
- schema_scan_id: 161474317
- updated: 2026-04-04 10:04:05
-
Version 1701510
- created: 2026-04-03 09:28:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-03/1775226511'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-03/1775226511
- id: 1701510
- 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: 1914
- schema_scan_id: 161414301
- updated: 2026-04-03 09:28:48
Schema Scans: 15
Last at 2026-04-17 09:26:58
-
Scan 162178346
- duration: 0:00:11.833895
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162178346
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012", "key": "raw/mms_monthly_summary/2026-04-17/1776436012/5ea27689-0e48-4dfe-9aeb-496cd8c8102d.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 17072314771495368869, "service_name": "drive-thru", "span_id": 4118141906635093823, "trace_id": 9248437058451748027 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-17 09:26:58
- success: True
- trace_id: 9248437058451748027
-
Scan 162122654
- duration: 0:00:11.843492
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162122654
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-16/1776349628", "key": "raw/mms_monthly_summary/2026-04-16/1776349628/93fb0d36-afcf-47da-a0fa-43c302c9f274.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 15039197422514931203, "service_name": "drive-thru", "span_id": 16572463817953393543, "trace_id": 14048474190340800768 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-16 09:27:12
- success: True
- trace_id: 14048474190340800768
-
Scan 162072820
- duration: 0:00:14.388997
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162072820
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-15/1776270463", "key": "raw/mms_monthly_summary/2026-04-15/1776270463/cdcbf06d-6957-4d06-919b-5963fbed1782.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 16559887651165163825, "service_name": "drive-thru", "span_id": 15480152146369961424, "trace_id": 12913757506220339138 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-15 11:28:09
- success: True
- trace_id: 12913757506220339138
-
Scan 162046338
- duration: 0:00:14.518439
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162046338
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-14/1776218795", "key": "raw/mms_monthly_summary/2026-04-14/1776218795/a8fcd5bd-6771-4ea6-9acd-fbf80e669d1f.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 12471555937220713124, "service_name": "drive-thru", "span_id": 521873819455204715, "trace_id": 12494620324134275196 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-14 21:06:48
- success: True
- trace_id: 12494620324134275196
-
Scan 161954352
- duration: 0:00:11.888098
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161954352
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-13/1776091773", "key": "raw/mms_monthly_summary/2026-04-13/1776091773/f1294be0-3ce1-44ff-bd45-a8bde9fbfb4d.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 6242858551872610855, "service_name": "drive-thru", "span_id": 4307555726860482605, "trace_id": 17408383814193433301 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-13 09:52:13
- success: True
- trace_id: 17408383814193433301
-
Scan 161903650
- duration: 0:00:11.669126
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161903650
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-12/1776005072", "key": "raw/mms_monthly_summary/2026-04-12/1776005072/b3fceea0-4c64-488e-87b7-5ef219051d9c.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 13806734064598577460, "service_name": "drive-thru", "span_id": 18076158281859051805, "trace_id": 4456360837694579743 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-12 09:44:37
- success: True
- trace_id: 4456360837694579743
-
Scan 161852103
- duration: 0:00:11.747512
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161852103
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-11/1775918610", "key": "raw/mms_monthly_summary/2026-04-11/1775918610/2a06a6d5-aead-4d3c-8f57-ab22602c0f88.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 10873868372674010062, "service_name": "drive-thru", "span_id": 12057891019167161391, "trace_id": 2637008250381215344 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-11 09:43:35
- success: True
- trace_id: 2637008250381215344
-
Scan 161797549
- duration: 0:00:14.379750
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161797549
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-10/1775832251", "key": "raw/mms_monthly_summary/2026-04-10/1775832251/6910824d-b388-4931-96b9-a368f32d7236.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 12724830952887729783, "service_name": "drive-thru", "span_id": 1225585330038387085, "trace_id": 3789284457738349150 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-10 09:46:13
- success: True
- trace_id: 3789284457738349150
-
Scan 161741333
- duration: 0:00:11.798584
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161741333
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-09/1775744866", "key": "raw/mms_monthly_summary/2026-04-09/1775744866/c62d07b6-2d03-48ab-bb4a-f2a0d40ea9d7.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 10845539750888096139, "service_name": "drive-thru", "span_id": 3261734393068711896, "trace_id": 11771560639288826531 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-09 09:27:50
- success: True
- trace_id: 11771560639288826531
-
Scan 161686836
- duration: 0:00:14.323882
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161686836
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-08/1775659658", "key": "raw/mms_monthly_summary/2026-04-08/1775659658/0aa28b4a-7feb-4661-b1e2-bc41df9e0e74.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 17834089895043479566, "service_name": "drive-thru", "span_id": 4183544044775194834, "trace_id": 12392105760606284984 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-08 09:50:09
- success: True
- trace_id: 12392105760606284984
-
Scan 161630624
- duration: 0:00:14.350716
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161630624
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-07/1775573123", "key": "raw/mms_monthly_summary/2026-04-07/1775573123/32c8bf03-731d-447c-a832-2c7fd191a5db.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 3102465936866037917, "service_name": "drive-thru", "span_id": 5635168398145217657, "trace_id": 14156803913226001252 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-07 09:45:28
- success: True
- trace_id: 14156803913226001252
-
Scan 161572758
- duration: 0:00:11.808469
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161572758
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-06/1775485806", "key": "raw/mms_monthly_summary/2026-04-06/1775485806/7c820b8c-c2b6-461b-87de-cea0f0611f85.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 8063461533810955430, "service_name": "drive-thru", "span_id": 18183108752093164844, "trace_id": 14091142344964438469 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-06 09:30:16
- success: True
- trace_id: 14091142344964438469
-
Scan 161523963
- duration: 0:00:11.727458
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161523963
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-05/1775400344", "key": "raw/mms_monthly_summary/2026-04-05/1775400344/a3f39f49-6d1c-40e4-ab16-7dfc8114de74.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 13107823339717553483, "service_name": "drive-thru", "span_id": 2379344228054842287, "trace_id": 17037603973870812299 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-05 09:45:48
- success: True
- trace_id: 17037603973870812299
-
Scan 161474317
- duration: 0:00:14.358681
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161474317
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-04/1775314917", "key": "raw/mms_monthly_summary/2026-04-04/1775314917/876548ab-6fbc-4695-8f23-cb8c8765c684.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 3486704146638080589, "service_name": "drive-thru", "span_id": 911598645647641721, "trace_id": 10162517720852521414 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-04 10:03:51
- success: True
- trace_id: 10162517720852521414
-
Scan 161414301
- duration: 0:00:11.759326
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161414301
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrix-prod", "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-03/1775226511", "key": "raw/mms_monthly_summary/2026-04-03/1775226511/cf8f4a59-f404-436d-8763-3949a2841587.csv.gz" }, "schema": { "name": "sfdl_prod_csv.payrix_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 17224149978860508701, "service_name": "drive-thru", "span_id": 4473824256674829408, "trace_id": 10581407894775704181 } } - running: False
- schema_name_id: 1914
- start_time: 2026-04-03 09:28:36
- success: True
- trace_id: 10581407894775704181
- attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - created: 2026-04-17 09:26:58
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_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-10 09:32:06",
"disabled": false,
"format": "raw",
"id": 1914,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_csv",
"table": "payrix_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:26:58",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}