Schema Info
Schema Name: sfdl_dev_csv.payrixess_mms_monthly_summary
- created: 2024-07-22 13:07:13
- disabled: False
- format: raw
- id: 2371
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_csv", "table": "payrixess_mms_monthly_summary" } - type: csv
Schema Versions: 15
-
Version 4773359
- created: 2026-04-17 09:48:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-17/1776437319'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-17/1776437319
- id: 4773359
- 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: 2371
- schema_scan_id: 6867760
- updated: 2026-04-17 09:48:55
-
Version 4773293
- created: 2026-04-16 09:39:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-16/1776350345'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-16/1776350345
- id: 4773293
- 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: 2371
- schema_scan_id: 6867523
- updated: 2026-04-16 09:39:21
-
Version 4773244
- created: 2026-04-15 10:05:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-15/1776265500'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-15/1776265500
- id: 4773244
- 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: 2371
- schema_scan_id: 6867282
- updated: 2026-04-15 10:05:16
-
Version 4773153
- created: 2026-04-14 09:41:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-14/1776177655'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-14/1776177655
- id: 4773153
- 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: 2371
- schema_scan_id: 6866885
- updated: 2026-04-14 09:41:11
-
Version 4773119
- created: 2026-04-13 09:49:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-13/1776091743'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-13/1776091743
- id: 4773119
- 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: 2371
- schema_scan_id: 6866705
- updated: 2026-04-13 09:49:21
-
Version 4773042
- created: 2026-04-12 09:28:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-12/1776004088'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-12/1776004088
- id: 4773042
- 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: 2371
- schema_scan_id: 6866378
- updated: 2026-04-12 09:28:49
-
Version 4773020
- created: 2026-04-11 09:47:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-11/1775918814'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-11/1775918814
- id: 4773020
- 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: 2371
- schema_scan_id: 6866325
- updated: 2026-04-11 09:47:15
-
Version 4772931
- created: 2026-04-10 09:26:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-10/1775831207'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-10/1775831207
- id: 4772931
- 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: 2371
- schema_scan_id: 6865957
- updated: 2026-04-10 09:27:03
-
Version 4772895
- created: 2026-04-09 09:48:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-09/1775746106'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-09/1775746106
- id: 4772895
- 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: 2371
- schema_scan_id: 6865814
- updated: 2026-04-09 09:49:02
-
Version 4772836
- created: 2026-04-08 09:45:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-08/1775659526'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-08/1775659526
- id: 4772836
- 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: 2371
- schema_scan_id: 6865528
- updated: 2026-04-08 09:45:55
-
Version 4772771
- created: 2026-04-07 09:45:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-07/1775573132'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-07/1775573132
- id: 4772771
- 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: 2371
- schema_scan_id: 6865271
- updated: 2026-04-07 09:46:00
-
Version 4772709
- created: 2026-04-06 09:45:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-06/1775486702'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-06/1775486702
- id: 4772709
- 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: 2371
- schema_scan_id: 6864926
- updated: 2026-04-06 09:45:21
-
Version 4772666
- created: 2026-04-05 09:49:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-05/1775400553'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-05/1775400553
- id: 4772666
- 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: 2371
- schema_scan_id: 6864752
- updated: 2026-04-05 09:49:39
-
Version 4772587
- created: 2026-04-04 09:26:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-04/1775312780'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-04/1775312780
- id: 4772587
- 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: 2371
- schema_scan_id: 6864453
- updated: 2026-04-04 09:26:38
-
Version 4772531
- created: 2026-04-03 09:30:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-03/1775226625'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-03/1775226625
- id: 4772531
- 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: 2371
- schema_scan_id: 6864226
- updated: 2026-04-03 09:30:42
Schema Scans: 15
Last at 2026-04-17 09:48:44
-
Scan 6867760
- duration: 0:00:11.722474
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867760
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-17/1776437319", "key": "raw/mms_monthly_summary/2026-04-17/1776437319/1b1cdef7-d799-4230-9f95-dadc451d64af.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 2720274393470287594, "service_name": "drive-thru", "span_id": 16296435672280547327, "trace_id": 4637986838851078901 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-17 09:48:44
- success: True
- trace_id: 4637986838851078901
-
Scan 6867523
- duration: 0:00:11.816418
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867523
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-16/1776350345", "key": "raw/mms_monthly_summary/2026-04-16/1776350345/7d0bcfb0-2ca0-4bdf-b027-8e66a9e51a7a.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 8747347312314676318, "service_name": "drive-thru", "span_id": 5939489026902915086, "trace_id": 8085582421244234645 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-16 09:39:10
- success: True
- trace_id: 8085582421244234645
-
Scan 6867282
- duration: 0:00:11.904415
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867282
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-15/1776265500", "key": "raw/mms_monthly_summary/2026-04-15/1776265500/f292b4f5-e3ff-4d70-a369-3416a861fd87.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 18198007320089722395, "service_name": "drive-thru", "span_id": 6615491359601905157, "trace_id": 14763044887648480335 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-15 10:05:04
- success: True
- trace_id: 14763044887648480335
-
Scan 6866885
- duration: 0:00:11.865799
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866885
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-14/1776177655", "key": "raw/mms_monthly_summary/2026-04-14/1776177655/eea6845c-96e9-41de-a344-2afb782f93b2.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 9030767911787656828, "service_name": "drive-thru", "span_id": 8095868304815633880, "trace_id": 9193301894693459394 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-14 09:40:59
- success: True
- trace_id: 9193301894693459394
-
Scan 6866705
- duration: 0:00:14.449656
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866705
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-13/1776091743", "key": "raw/mms_monthly_summary/2026-04-13/1776091743/a85f7c89-c795-4f92-ab83-a842cc5bf0d7.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 5458416371622804377, "service_name": "drive-thru", "span_id": 2197235123552781887, "trace_id": 14835443441067090094 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-13 09:49:07
- success: True
- trace_id: 14835443441067090094
-
Scan 6866378
- duration: 0:00:11.746869
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866378
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-12/1776004088", "key": "raw/mms_monthly_summary/2026-04-12/1776004088/1e211769-749d-470a-b5f2-b3f609c60a3b.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 1295762351437800789, "service_name": "drive-thru", "span_id": 13681207217901942456, "trace_id": 10501696303829978049 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-12 09:28:38
- success: True
- trace_id: 10501696303829978049
-
Scan 6866325
- duration: 0:00:14.349133
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866325
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-11/1775918814", "key": "raw/mms_monthly_summary/2026-04-11/1775918814/bc228e62-0cdf-4458-967f-043ad40a60c1.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 4275556056971406366, "service_name": "drive-thru", "span_id": 8117624709608065469, "trace_id": 17832028809252035730 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-11 09:47:00
- success: True
- trace_id: 17832028809252035730
-
Scan 6865957
- duration: 0:00:11.758943
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865957
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-10/1775831207", "key": "raw/mms_monthly_summary/2026-04-10/1775831207/30793aa3-9fe1-482e-9fee-2c984befcabe.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 2572017381028130943, "service_name": "drive-thru", "span_id": 17834838062202810718, "trace_id": 4686087119585048183 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-10 09:26:51
- success: True
- trace_id: 4686087119585048183
-
Scan 6865814
- duration: 0:00:11.810305
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865814
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-09/1775746106", "key": "raw/mms_monthly_summary/2026-04-09/1775746106/bec585e4-73b8-4c92-900c-b0fbdce7c9a0.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 6053825121424166318, "service_name": "drive-thru", "span_id": 1600191557757414123, "trace_id": 5557227644270062287 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-09 09:48:51
- success: True
- trace_id: 5557227644270062287
-
Scan 6865528
- duration: 0:00:14.367639
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865528
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-08/1775659526", "key": "raw/mms_monthly_summary/2026-04-08/1775659526/2ae61d21-ecb9-4cdb-ac11-fb0e00b8b2a9.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 9865209075953183966, "service_name": "drive-thru", "span_id": 17739252090413495542, "trace_id": 4901874400627635642 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-08 09:45:41
- success: True
- trace_id: 4901874400627635642
-
Scan 6865271
- duration: 0:00:14.561518
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865271
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-07/1775573132", "key": "raw/mms_monthly_summary/2026-04-07/1775573132/797e2b0b-0883-4098-b6eb-1ba78606d119.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 17911171074878539580, "service_name": "drive-thru", "span_id": 18187930358875505659, "trace_id": 4589388226993789951 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-07 09:45:46
- success: True
- trace_id: 4589388226993789951
-
Scan 6864926
- duration: 0:00:14.321839
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864926
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-06/1775486702", "key": "raw/mms_monthly_summary/2026-04-06/1775486702/737b8a1a-58ff-4e05-9a4e-2e6004820303.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 18062135208442129186, "service_name": "drive-thru", "span_id": 7915771757583519760, "trace_id": 6726916109566435878 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-06 09:45:06
- success: True
- trace_id: 6726916109566435878
-
Scan 6864752
- duration: 0:00:14.400448
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864752
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-05/1775400553", "key": "raw/mms_monthly_summary/2026-04-05/1775400553/dc2c67a5-83ae-4ee6-80e9-28c7100cc26d.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 5617468254977201911, "service_name": "drive-thru", "span_id": 1272728899943814300, "trace_id": 16811867399635353176 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-05 09:49:25
- success: True
- trace_id: 16811867399635353176
-
Scan 6864453
- duration: 0:00:14.333136
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864453
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-04/1775312780", "key": "raw/mms_monthly_summary/2026-04-04/1775312780/bee04e1a-8f99-411c-a9a1-3c810d432b8e.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 9841759065185411734, "service_name": "drive-thru", "span_id": 14183543131930442108, "trace_id": 4022802306877530782 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-04 09:26:24
- success: True
- trace_id: 4022802306877530782
-
Scan 6864226
- duration: 0:00:14.363257
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864226
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-03/1775226625", "key": "raw/mms_monthly_summary/2026-04-03/1775226625/94f3372c-0285-4aff-9fe0-39066cb52eb2.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 9636077257276703752, "service_name": "drive-thru", "span_id": 4050323852524252998, "trace_id": 1788429174569367699 } } - running: False
- schema_name_id: 2371
- start_time: 2026-04-03 09:30:28
- success: True
- trace_id: 1788429174569367699
- attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - created: 2026-04-17 09:48:44
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-17/1776437319'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2024-07-22 13:07:13",
"disabled": false,
"format": "raw",
"id": 2371,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_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:48:44",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_monthly_summary/2026-04-17/1776437319'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}