Schema Info
Schema Name: sfdl_dev_segment.yim_product_list_viewed
- created: 2018-03-27 14:02:05
- disabled: False
- format: raw
- id: 708
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_segment", "table": "yim_product_list_viewed" } - type: segment
Schema Versions: 3
-
Version 4676447
- created: 2020-02-27 12:08:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.yim_product_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.yim_product_list_viewed`\n(\n`receivedAt`STRING,`sentAt`STRING,`properties`struct<`qualityScoreFeatureFlagOn`:STRING,`products`:array,`unbundled`:array >,`type`STRING,`userId`STRING,`version`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.yim_product_list_viewed" ] - hive_path: s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed
- id: 4676447
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Segment.io" ], "unbundled": [] }, "_origin": "2020-02-27T18:07:58Z|s3://sfdl-segment-yim-dev/segment-logs/lz0BmGgGwT/1582761600000/1582826861792.81f34d95408c.e4797d0.a11abe17-eb83-4b82-97ad-49b2bf06ef56.gz|segment_separator:34", "anonymousId": "1ce143a5-b160-489c-bef5-85fbe34fa194", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.11.0" }, "locale": "en-US", "page": { "path": "/search/storage", "referrer": "", "search": "?searchType=storage&zoom=11&distance=15&location=National-City%2C%20CA&latitude=32.678000&longitude=-117.099000", "title": "YIM search storage", "url": "http://localhost:9024/search/storage?searchType=storage&zoom=11&distance=15&location=National-City%2C%20CA&latitude=32.678000&longitude=-117.099000" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36" }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-982fd9c3bda56bbe8cfbdc45f0c34675", "originalTimestamp": "2020-02-27T17:35:52.418Z", "projectId": "lz0BmGgGwT", "properties": { "Hit Timestamp": 1582824952415, "agentId": "1345381", "callSessionId": "5394025", "env": "staging", "isReact": true, "products": [ { "distance": 1.6016938620801073, "facilityId": 206271, "position": 0 }, { "distance": 1.701916127108007, "facilityId": 63134, "position": 1 }, { "distance": 5.661195893968957, "facilityId": 215238, "position": 2 }, { "distance": 1.2824006735680467, "facilityId": 201299, "position": 3 }, { "distance": 1.9994599649545777, "facilityId": 105200, "position": 4 }, { "distance": 4.144223719040103, "facilityId": 208126, "position": 5 }, { "distance": 9.609840680030322, "facilityId": 107823, "position": 6 }, { "distance": 11.344817130003603, "facilityId": 107825, "position": 7 }, { "distance": 3.7458484223346216, "facilityId": 215873, "position": 8 }, { "distance": 8.12026110082394, "facilityId": 208983, "position": 9 }, { "distance": 13.132145475785105, "facilityId": 107635, "position": 10 }, { "distance": 5.936129096399767, "facilityId": 103337, "position": 11 }, { "distance": 5.886279468602035, "facilityId": 215317, "position": 12 }, { "distance": 5.234121441087651, "facilityId": 209597, "position": 13 }, { "distance": 3.368709533100526, "facilityId": 215305, "position": 14 }, { "distance": 4.923650067729628, "facilityId": 108691, "position": 15 }, { "distance": 7.625978972746592, "facilityId": 156020, "position": 16 }, { "distance": 11.783204294928355, "facilityId": 216046, "position": 17 }, { "distance": 8.743443274882871, "facilityId": 216073, "position": 18 }, { "distance": 8.011301527334187, "facilityId": 204193, "position": 19 }, { "distance": 6.168318068276436, "facilityId": 63284, "position": 20 }, { "distance": 10.984484322765853, "facilityId": 216007, "position": 21 }, { "distance": 8.413207277517492, "facilityId": 64409, "position": 22 }, { "distance": 12.557994581629737, "facilityId": 107820, "position": 23 }, { "distance": 14.606951296804901, "facilityId": 215358, "position": 24 }, { "distance": 8.46641604632955, "facilityId": 215237, "position": 25 }, { "distance": 7.129262927659785, "facilityId": 64408, "position": 26 }, { "distance": 13.45666235848236, "facilityId": 210665, "position": 27 }, { "distance": 7.344993599860812, "facilityId": 206268, "position": 28 }, { "distance": 8.91446120770005, "facilityId": 208104, "position": 29 }, { "distance": 14.753200690966484, "facilityId": 199482, "position": 30 }, { "distance": 4.070351199870754, "facilityId": 200546, "position": 31 }, { "distance": 8.411054842357736, "facilityId": 63160, "position": 32 }, { "distance": 7.42359228006512, "facilityId": 204121, "position": 33 }, { "distance": 7.7709812718257165, "facilityId": 63159, "position": 34 }, { "distance": 8.80970584214647, "facilityId": 154747, "position": 35 }, { "distance": 11.158605391029862, "facilityId": 105679, "position": 36 }, { "distance": 9.072703095678973, "facilityId": 210207, "position": 37 }, { "distance": 8.493533373929687, "facilityId": 208492, "position": 38 }, { "distance": 10.996105235686679, "facilityId": 216077, "position": 39 }, { "distance": 12.495545378850956, "facilityId": 215213, "position": 40 }, { "distance": 9.94424670983136, "facilityId": 212648, "position": 41 }, { "distance": 10.242378242012252, "facilityId": 208618, "position": 42 }, { "distance": 10.615441733878484, "facilityId": 215345, "position": 43 }, { "distance": 5.685658717238122, "facilityId": 206279, "position": 44 }, { "distance": 7.941837647731369, "facilityId": 105677, "position": 45 }, { "distance": 13.049097766786383, "facilityId": 206045, "position": 46 }, { "distance": 8.684821417475487, "facilityId": 154758, "position": 47 }, { "distance": 11.13156014266718, "facilityId": 103343, "position": 48 }, { "distance": 8.395693265562281, "facilityId": 210982, "position": 49 }, { "distance": 10.07642076876235, "facilityId": 208139, "position": 50 }, { "distance": 9.727170765655487, "facilityId": 63162, "position": 51 }, { "distance": 8.162858066039494, "facilityId": 212331, "position": 52 }, { "distance": 11.016526029303938, "facilityId": 64348, "position": 53 }, { "distance": 11.158003902220786, "facilityId": 156024, "position": 54 }, { "distance": 6.376763766512981, "facilityId": 206278, "position": 55 }, { "distance": 13.7293903090708, "facilityId": 208385, "position": 56 }, { "distance": 12.262915232331265, "facilityId": 63137, "position": 57 } ] }, "receivedAt": "2020-02-27T17:35:52.520Z", "sentAt": "2020-02-27T17:35:52.422Z", "timestamp": "2020-02-27T17:35:52.516Z", "type": "track", "userId": "5394025", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.agentId": "string", "properties.callSessionId": "string", "properties.env": "string", "properties.isReact": "string", "properties.products": [ { "distance": "string", "facilityId": "string", "position": "string" } ], "properties.qualityScoreFeatureFlagOn": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 708
- schema_scan_id: 5456449
- updated: 2020-02-27 12:09:18
-
Version 4667249
- created: 2019-03-14 14:37:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.yim_product_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.yim_product_list_viewed`\n(\n`timestamp`STRING,`userId`STRING,`integrations`struct<`_empty_`:STRING>,`receivedAt`STRING,`anonymousId`STRING,`_origin`STRING,`properties`struct<`Hit_Timestamp`:STRING,`qualityScoreFeatureFlagOn`:STRING,`callSessionId`:STRING,`isReact`:STRING,`products`:array,`unbundled`:array >,`version`STRING,`originalTimestamp`STRING,`context`struct<`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`campaign`:struct<`_empty_`:STRING>,`userAgent`:STRING>,`messageId`STRING,`type`STRING,`channel`STRING,`sentAt`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.yim_product_list_viewed" ] - hive_path: s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed
- id: 4667249
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Segment.io" ], "unbundled": [] }, "_origin": "2019-03-14T19:37:00Z|s3://sfdl-segment-yim-dev/segment-logs/lz0BmGgGwT/1552521600000/1552591791372.0acb454b0078.dev.986d3970-4a5f-41ef-bb24-466ed767ca31.gz|segment_separator:34", "anonymousId": "12a09659-cca1-4435-a3d5-a6d991b146a0", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.7.2" }, "page": { "path": "/search/storage", "referrer": "", "search": "?sort=distance%3Aasc&searchType=storage&zoom=11&distance=15&location=Austin%2C%20TX%2078745%2C%20USA&latitude=30.2153869&longitude=-97.79601179999997&types=postal_code", "title": "YIM search storage", "url": "http://localhost:9024/search/storage?sort=distance%3Aasc&searchType=storage&zoom=11&distance=15&location=Austin%2C%20TX%2078745%2C%20USA&latitude=30.2153869&longitude=-97.79601179999997&types=postal_code" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36" }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-8dd3385d9dd9fc869bf399c3e8df8aad", "originalTimestamp": "2019-03-14T19:14:05.521Z", "projectId": "lz0BmGgGwT", "properties": { "Hit Timestamp": 1552590845518, "agentId": "2453533", "callSessionId": "2664592", "env": "staging", "isReact": true, "products": [ { "distance": 1.0363299862055253, "facilityId": 152939, "position": 0 }, { "distance": 1.2725622304795756, "facilityId": 50712, "position": 1 }, { "distance": 1.3711592951147675, "facilityId": 201698, "position": 2 }, { "distance": 1.6065762362210596, "facilityId": 210059, "position": 3 }, { "distance": 1.7061575552711048, "facilityId": 209072, "position": 4 }, { "distance": 1.8019977133483291, "facilityId": 199878, "position": 5 }, { "distance": 1.8148608746442643, "facilityId": 63542, "position": 6 }, { "distance": 1.9543322107199226, "facilityId": 205806, "position": 7 }, { "distance": 2.1772960965364683, "facilityId": 202820, "position": 8 }, { "distance": 2.5884927982899826, "facilityId": 69694, "position": 9 }, { "distance": 2.609241055339456, "facilityId": 203135, "position": 10 }, { "distance": 2.6424474629351162, "facilityId": 156046, "position": 11 }, { "distance": 2.7921168926392186, "facilityId": 209060, "position": 12 }, { "distance": 2.8928989523655657, "facilityId": 202724, "position": 13 }, { "distance": 3.127018156511365, "facilityId": 152927, "position": 14 }, { "distance": 3.214310214125045, "facilityId": 153366, "position": 15 }, { "distance": 3.2806813973430105, "facilityId": 194245, "position": 16 }, { "distance": 3.3837560739185006, "facilityId": 204349, "position": 17 }, { "distance": 3.4463918749300952, "facilityId": 206130, "position": 18 }, { "distance": 3.542136528017697, "facilityId": 63544, "position": 19 }, { "distance": 3.772796922962208, "facilityId": 206258, "position": 20 }, { "distance": 4.429818186337257, "facilityId": 156115, "position": 21 }, { "distance": 4.478361440093455, "facilityId": 209852, "position": 22 }, { "distance": 4.4917000136702, "facilityId": 154077, "position": 23 }, { "distance": 4.802555084693104, "facilityId": 208574, "position": 24 }, { "distance": 4.941385101967266, "facilityId": 205886, "position": 25 }, { "distance": 5.027297525693763, "facilityId": 210294, "position": 26 }, { "distance": 5.819078628506096, "facilityId": 69692, "position": 27 }, { "distance": 7.2100830153976165, "facilityId": 69693, "position": 28 }, { "distance": 8.236813849155554, "facilityId": 209054, "position": 29 }, { "distance": 8.267309580324854, "facilityId": 105377, "position": 30 }, { "distance": 8.457176855108306, "facilityId": 153058, "position": 31 }, { "distance": 8.726277231660184, "facilityId": 28265, "position": 32 }, { "distance": 8.788276560577629, "facilityId": 202824, "position": 33 }, { "distance": 9.493660133967962, "facilityId": 110052, "position": 34 }, { "distance": 9.52527806429965, "facilityId": 201149, "position": 35 }, { "distance": 10.270671828202865, "facilityId": 156262, "position": 36 }, { "distance": 10.73279729578585, "facilityId": 50658, "position": 37 }, { "distance": 10.907813140790633, "facilityId": 208687, "position": 38 }, { "distance": 11.514460586327314, "facilityId": 204306, "position": 39 }, { "distance": 12.404874047746281, "facilityId": 210551, "position": 40 }, { "distance": 12.443648949258701, "facilityId": 152957, "position": 41 }, { "distance": 12.849431443945965, "facilityId": 199407, "position": 42 }, { "distance": 12.892329774938796, "facilityId": 201143, "position": 43 }, { "distance": 13.263979022456411, "facilityId": 200301, "position": 44 }, { "distance": 13.528910609318105, "facilityId": 50710, "position": 45 }, { "distance": 13.608668149676266, "facilityId": 158156, "position": 46 }, { "distance": 13.609055886263935, "facilityId": 155482, "position": 47 }, { "distance": 13.622298582027415, "facilityId": 198352, "position": 48 }, { "distance": 14.0654131507326, "facilityId": 157542, "position": 49 }, { "distance": 14.293455702337603, "facilityId": 157074, "position": 50 }, { "distance": 14.40181565113649, "facilityId": 203910, "position": 51 }, { "distance": 14.569836081872072, "facilityId": 200555, "position": 52 }, { "distance": 14.73595759752445, "facilityId": 209051, "position": 53 }, { "distance": 14.868115500764288, "facilityId": 210057, "position": 54 }, { "distance": 14.985298321050866, "facilityId": 206257, "position": 55 } ], "qualityScoreFeatureFlagOn": false }, "receivedAt": "2019-03-14T19:14:06.017Z", "sentAt": "2019-03-14T19:14:05.525Z", "timestamp": "2019-03-14T19:14:06.013Z", "type": "track", "userId": "2453533", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.agentId": "string", "properties.callSessionId": "string", "properties.env": "string", "properties.isReact": "string", "properties.products": [ { "distance": "string", "facilityId": "string", "position": "string" } ], "properties.qualityScoreFeatureFlagOn": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 708
- schema_scan_id: 4629228
- updated: 2019-03-14 14:37:37
-
Version 4665680
- created: 2019-02-19 12:17:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.yim_product_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.yim_product_list_viewed`\n(\n`version`STRING,`timestamp`STRING,`messageId`STRING,`userId`STRING,`integrations`struct<`_empty_`:STRING>,`event`STRING,`receivedAt`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array >,`anonymousId`STRING,`originalTimestamp`STRING,`context`struct<`ip`:STRING,`campaign`:struct<`_empty_`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`userAgent`:STRING>,`projectId`STRING,`_origin`STRING,`type`STRING,`properties`struct<`Hit_Timestamp`:STRING,`agentId`:STRING,`callSessionId`:STRING,`isReact`:STRING,`products`:array - hive_path: s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed
- id: 4665680
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Segment.io" ], "unbundled": [] }, "_origin": "2019-02-19T18:17:34Z|s3://sfdl-segment-yim-dev/segment-logs/lz0BmGgGwT/1550534400000/1550599772568.a378b1cd6202.dev.cde2a7fe-77e9-4e89-90c2-3e64d7356a5e.gz|segment_separator:34", "anonymousId": "12a09659-cca1-4435-a3d5-a6d991b146a0", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.7.2" }, "page": { "path": "/search/storage", "referrer": "http://localhost:9024/login", "search": "?sort=distance%3Aasc&searchType=storage&zoom=11&distance=15&location=Perryville%2C%20AK%2099648%2C%20USA&latitude=55.9246646&longitude=-159.15747999999996&types=postal_code", "title": "YIM search storage", "url": "http://localhost:9024/search/storage?sort=distance%3Aasc&searchType=storage&zoom=11&distance=15&location=Perryville%2C%20AK%2099648%2C%20USA&latitude=55.9246646&longitude=-159.15747999999996&types=postal_code" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.109 Safari/537.36" }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-73c754b29cca208ca73d86f5879d6c5c", "originalTimestamp": "2019-02-19T17:43:11.745Z", "projectId": "lz0BmGgGwT", "properties": { "Hit Timestamp": 1550598191743, "agentId": "2453533", "callSessionId": "2664592", "env": "staging", "isReact": true, "products": [ { "distance": 0.7132330644860627, "facilityId": 158519, "position": 0 }, { "distance": 0.7132330644860627, "facilityId": 210953, "position": 1 }, { "distance": 0.7132330644860627, "facilityId": 210933, "position": 2 }, { "distance": 0.7132330644860627, "facilityId": 210947, "position": 3 }, { "distance": 0.7132330644860627, "facilityId": 210945, "position": 4 }, { "distance": 0.7132330644860627, "facilityId": 210948, "position": 5 }, { "distance": 0.7132330644860627, "facilityId": 210942, "position": 6 }, { "distance": 0.7132330644860627, "facilityId": 210946, "position": 7 }, { "distance": 0.7132330644860627, "facilityId": 210935, "position": 8 }, { "distance": 0.7132330644860627, "facilityId": 210955, "position": 9 }, { "distance": 0.7132330644860627, "facilityId": 210944, "position": 10 }, { "distance": 0.7132330644860627, "facilityId": 210949, "position": 11 }, { "distance": 0.7132330644860627, "facilityId": 210954, "position": 12 }, { "distance": 0.7132330644860627, "facilityId": 210943, "position": 13 }, { "distance": 0.7132330644860627, "facilityId": 210937, "position": 14 }, { "distance": 0.7132330644860627, "facilityId": 210956, "position": 15 }, { "distance": 0.7132330644860627, "facilityId": 210952, "position": 16 }, { "distance": 0.7132330644860627, "facilityId": 210940, "position": 17 }, { "distance": 0.7132330644860627, "facilityId": 210939, "position": 18 }, { "distance": 0.7132330644860627, "facilityId": 210936, "position": 19 }, { "distance": 0.7132330644860627, "facilityId": 210951, "position": 20 }, { "distance": 0.7132330644860627, "facilityId": 210938, "position": 21 }, { "distance": 0.7132330644860627, "facilityId": 205902, "position": 22 }, { "distance": 0.7132330644860627, "facilityId": 105463, "position": 23 }, { "distance": 0.7132330644860627, "facilityId": 105461, "position": 24 }, { "distance": 0.7132330644860627, "facilityId": 105472, "position": 25 }, { "distance": 0.7132330644860627, "facilityId": 155561, "position": 26 }, { "distance": 0.7132330644860627, "facilityId": 155845, "position": 27 }, { "distance": 0.7132330644860627, "facilityId": 155560, "position": 28 }, { "distance": 0.7132330644860627, "facilityId": 155558, "position": 29 }, { "distance": 0.7132330644860627, "facilityId": 108319, "position": 30 }, { "distance": 0.7132330644860627, "facilityId": 108280, "position": 31 }, { "distance": 0.7132330644860627, "facilityId": 155559, "position": 32 }, { "distance": 0.7132330644860627, "facilityId": 201492, "position": 33 }, { "distance": 0.7229088321920787, "facilityId": 108647, "position": 34 }, { "distance": 0.7229088321920787, "facilityId": 203761, "position": 35 }, { "distance": 0.7229088321920787, "facilityId": 203838, "position": 36 } ], "qualityScoreFeatureFlagOn": false }, "receivedAt": "2019-02-19T17:43:12.105Z", "sentAt": "2019-02-19T17:43:11.749Z", "timestamp": "2019-02-19T17:43:12.101Z", "type": "track", "userId": "2453533", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.agentId": "string", "properties.callSessionId": "string", "properties.env": "string", "properties.isReact": "string", "properties.products": "", "properties.qualityScoreFeatureFlagOn": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 708
- schema_scan_id: 4557561
- updated: 2019-02-19 12:18:02
Schema Scans: 3
Last at 2020-02-27 12:08:37
-
Scan 5456449
- duration: 0:00:44.680628
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 153, "partitions_applied": false, "success": true } - id: 5456449
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2020-02-27/", "name": "dt", "type": "string", "value": "2020-02-27" }, "s3": { "bucket": "sfdl-segment-yim-dev", "hive_path": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2020-02-27/1582826861792.81f34d95408c.e4797d0.a11abe17-eb83-4b82-97ad-49b2bf06ef56.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.yim_Product_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 708
- start_time: 2020-02-27 12:08:37
- success: True
- trace_id: 6806340082238896368
-
Scan 4629228
- duration: 0:00:35.723276
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 108, "partitions_applied": false, "success": true } - id: 4629228
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2019-03-14/", "name": "dt", "type": "string", "value": "2019-03-14" }, "s3": { "bucket": "sfdl-segment-yim-dev", "hive_path": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2019-03-14/1552591791372.0acb454b0078.dev.986d3970-4a5f-41ef-bb24-466ed767ca31.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.yim_Product_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 708
- start_time: 2019-03-14 14:37:05
- success: True
- trace_id: 362029688113744403
-
Scan 4557561
- duration: 0:00:29.913657
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 107, "partitions_applied": false, "success": true } - id: 4557561
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2019-02-19/", "name": "dt", "type": "string", "value": "2019-02-19" }, "s3": { "bucket": "sfdl-segment-yim-dev", "hive_path": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2019-02-19/1550599772568.a378b1cd6202.dev.cde2a7fe-77e9-4e89-90c2-3e64d7356a5e.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.yim_Product_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 708
- start_time: 2019-02-19 12:17:35
- success: True
- trace_id: 5922830821547652598
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_dev_segment.yim_product_list_viewed`\nADD\n\n\n PARTITION (dt='2021-01-13') location 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-01-13/'\n PARTITION (dt='2021-01-19') location 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-01-19/'\n PARTITION (dt='2021-02-01') location 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-02-01/'\n;" ] - name: dt
- state:
[ { "info": { "id": 164044, "location": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-01-13/", "name": "dt", "value": "2021-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-01-13 13:16:08", "last_data": "2021-01-13 14:31:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 164271, "location": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-01-19/", "name": "dt", "value": "2021-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-01-19 10:17:16", "last_data": "2021-01-19 11:25:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 164744, "location": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-02-01/", "name": "dt", "value": "2021-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-02-01 10:47:36", "last_data": "2021-02-01 10:47:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.agentId": "string", "properties.callSessionId": "string", "properties.env": "string", "properties.isReact": "string", "properties.products": [ { "distance": "string", "facilityId": "string", "position": "string" } ], "properties.qualityScoreFeatureFlagOn": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2020-02-27 12:08:37
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.yim_product_list_viewed`\n(\n`receivedAt`STRING,`sentAt`STRING,`properties`struct<`qualityScoreFeatureFlagOn`:STRING,`products`:array,`unbundled`:array >,`type`STRING,`userId`STRING,`version`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.yim_product_list_viewed`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.yim_product_list_viewed" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2018-03-27 14:02:05",
"disabled": false,
"format": "raw",
"id": 708,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_segment",
"table": "yim_product_list_viewed"
},
"type": "segment"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_dev_segment.yim_product_list_viewed`\nADD\n\n\n PARTITION (dt='2021-01-13') location 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-01-13/'\n PARTITION (dt='2021-01-19') location 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-01-19/'\n PARTITION (dt='2021-02-01') location 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-02-01/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 164044,
"location": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-01-13/",
"name": "dt",
"value": "2021-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-01-13 13:16:08",
"last_data": "2021-01-13 14:31:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 164271,
"location": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-01-19/",
"name": "dt",
"value": "2021-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-01-19 10:17:16",
"last_data": "2021-01-19 11:25:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 164744,
"location": "s3://sfdl-segment-yim-dev/separated_dt/Product List Viewed/dt=2021-02-01/",
"name": "dt",
"value": "2021-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-02-01 10:47:36",
"last_data": "2021-02-01 10:47:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.locale": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.userAgent": "string",
"event": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.agentId": "string",
"properties.callSessionId": "string",
"properties.env": "string",
"properties.isReact": "string",
"properties.products": [
{
"distance": "string",
"facilityId": "string",
"position": "string"
}
],
"properties.qualityScoreFeatureFlagOn": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2020-02-27 12:08:37",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.yim_product_list_viewed`\n(\n`receivedAt`STRING,`sentAt`STRING,`properties`struct<`qualityScoreFeatureFlagOn`:STRING,`products`:array>,`Hit_Timestamp`:STRING,`agentId`:STRING,`env`:STRING,`isReact`:STRING,`callSessionId`:STRING>,`_origin`STRING,`projectId`STRING,`anonymousId`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`campaign`:struct<`_empty_`:STRING>,`page`:struct<`search`:STRING,`url`:STRING,`title`:STRING,`path`:STRING,`referrer`:STRING>,`ip`:STRING,`locale`:STRING,`userAgent`:STRING>,`channel`STRING,`integrations`struct<`_empty_`:STRING>,`messageId`STRING,`timestamp`STRING,`originalTimestamp`STRING,`event`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`type`STRING,`userId`STRING,`version`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-yim-dev/separated_dt/Product List Viewed'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.yim_product_list_viewed`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.yim_product_list_viewed"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}