1 files changed, 238 insertions, 0 deletions
diff --git a/tsg-olap/parcels/roles/validation/troubleshooting/templates/Prod.postman_environment.json.j2 b/tsg-olap/parcels/roles/validation/troubleshooting/templates/Prod.postman_environment.json.j2
new file mode 100644
index 0000000..4f10a06
--- /dev/null
+++ b/tsg-olap/parcels/roles/validation/troubleshooting/templates/Prod.postman_environment.json.j2
@@ -0,0 +1,238 @@
+{
+    "id": "18e95f62-58ae-4fc0-8350-f84b45b006af",
+    "name": "Develop",
+    "values": [
+        {
+            "key": "qgw_ip",
+            "value": "{{ groups.loadbalancer[0] }}",
+            "enabled": true
+        },
+        {
+            "key": "qgw_port",
+            "value": "9999",
+            "enabled": true
+        },
+        {
+            "key": "druid_ip",
+            "value": "{{ groups.loadbalancer[0] }}",
+            "type": "default",
+            "enabled": true
+        },
+        {
+            "key": "druid_port",
+            "value": "8089",
+            "enabled": true
+        },
+        {
+            "key": "hbase_ip",
+            "value": "{{ groups.hbase[0] }}",
+            "enabled": true
+        },
+        {
+            "key": "hbase_port",
+            "value": "50070",
+            "enabled": true
+        },
+        {
+            "key": "hos_token",
+            "value": "{{ hos_token }}",
+            "type": "secret",
+            "enabled": true
+        },
+        {
+            "key": "hos_ip",
+            "value": "{{ groups.galaxy_hos_service[0] }}",
+            "enabled": true
+        },
+        {
+            "key": "hos_port",
+            "value": "9098",
+            "enabled": true
+        },
+        {
+            "key": "clickhouse_ip",
+            "value": "{{ groups.clickhouse[0] }}",
+            "enabled": true
+        },
+        {
+            "key": "clickhouse_port",
+            "value": "8123",
+            "enabled": true
+        },
+        {
+            "key": "clickhouse_database",
+            "value": "tsg_galaxy_v3",
+            "enabled": true
+        },
+        {
+            "key": "clickhouse_user",
+            "value": "default",
+            "enabled": true
+        },
+        {
+            "key": "clickhouse_password",
+            "value": "galaxy2019",
+            "type": "secret",
+            "enabled": true
+        },
+        {
+            "key": "arango_ip",
+            "value": "{{ groups.arangodb[0] }}",
+            "enabled": true
+        },
+        {
+            "key": "arango_port",
+            "value": "8529",
+            "enabled": true
+        },
+        {
+            "key": "kafka_load_ip",
+            "value": "{{ groups.kafka[0] }}",
+            "enabled": true
+        },
+        {
+            "key": "kafka_monitor_port",
+            "value": "9991",
+            "enabled": true
+        },
+        {
+            "key": "kafka_merge_ip",
+            "value": "{{ groups.kafka[0] }}",
+            "enabled": true
+        },
+        {
+            "key": "report_ip",
+            "value": "{{ groups.saved_query_scheduler[0] }}",
+            "enabled": true
+        },
+        {
+            "key": "report_port",
+            "value": "9093",
+            "enabled": true
+        },
+        {
+            "key": "job_id",
+            "value": "",
+            "type": "any",
+            "enabled": true
+        },        
+        {
+            "key": "Last 5 Minutes Start",
+            "value": "FROM_UNIXTIME(UNIX_TIMESTAMP(now())-300)",
+            "enabled": true
+        },
+        {
+            "key": "now",
+            "value": "now()",
+            "enabled": true
+        },
+        {
+            "key": "Last 1 Hour Start",
+            "value": "FROM_UNIXTIME(UNIX_TIMESTAMP(now())-3600)",
+            "enabled": true
+        },
+        {
+            "key": "Last 12 Hour Start",
+            "value": "FROM_UNIXTIME(UNIX_TIMESTAMP(now())-43200)",
+            "enabled": true
+        },
+        {
+            "key": "Last 24 Hour Start",
+            "value": "FROM_UNIXTIME(UNIX_TIMESTAMP(now())-86400)",
+            "enabled": true
+        },
+        {
+            "key": "Today Start",
+            "value": "DATE(FROM_UNIXTIME(UNIX_TIMESTAMP(now())))",
+            "enabled": true
+        },
+        {
+            "key": "Today End",
+            "value": "DATE(FROM_UNIXTIME(UNIX_TIMESTAMP(now()) +86400))",
+            "enabled": true
+        },
+        {
+            "key": "Today so far Start",
+            "value": "DATE(FROM_UNIXTIME(UNIX_TIMESTAMP(now())))",
+            "enabled": true
+        },
+        {
+            "key": "Yesterday Start",
+            "value": "DATE(FROM_UNIXTIME(UNIX_TIMESTAMP(now()) -86400))",
+            "enabled": true
+        },
+        {
+            "key": "Yesterday End",
+            "value": "DATE(FROM_UNIXTIME(UNIX_TIMESTAMP(now())))",
+            "enabled": true
+        },
+        {
+            "key": "PT5S_RECV_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(common_recv_time,'PT5s'))",
+            "enabled": true
+        },
+        {
+            "key": "PT30S_RECV_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(common_recv_time,'PT30S'))",
+            "enabled": true
+        },
+        {
+            "key": "PT5M_RECV_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(common_recv_time,'PT5M'))",
+            "enabled": true
+        },
+        {
+            "key": "PT30M_RECV_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(common_recv_time,'PT30M'))",
+            "enabled": true
+        },
+        {
+            "key": "PT1H_RECV_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(common_recv_time,'PT1H'))",
+            "enabled": true
+        },
+        {
+            "key": "P1D_RECV_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(common_recv_time,'P1D'))",
+            "enabled": true
+        },
+        {
+            "key": "PT5S_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(UNIX_TIMESTAMP(__time),'PT5s'))",
+            "enabled": true
+        },
+        {
+            "key": "PT30S_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(UNIX_TIMESTAMP(__time),'PT30S'))",
+            "enabled": true
+        },
+        {
+            "key": "PT1M_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(UNIX_TIMESTAMP(__time),'PT1M'))",
+            "enabled": true
+        },
+        {
+            "key": "PT5M_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(UNIX_TIMESTAMP(__time),'PT5M'))",
+            "enabled": true
+        },
+        {
+            "key": "PT30M_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(UNIX_TIMESTAMP(__time),'PT30M'))",
+            "enabled": true
+        },
+        {
+            "key": "PT1H_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(UNIX_TIMESTAMP(__time),'PT1H'))",
+            "enabled": true
+        },
+        {
+            "key": "P1D_TIME",
+            "value": "FROM_UNIXTIME(TIME_FLOOR_WITH_FILL(UNIX_TIMESTAMP(__time),'P1D'))",
+            "enabled": true
+        }
+    ],
+    "_postman_variable_scope": "environment",
+    "_postman_exported_at": "2023-12-12T08:53:52.025Z",
+    "_postman_exported_using": "Postman/10.21.2"
+}