hit-lacus edited a comment on issue #902: KYLIN-3832 Query pushdown support postgresql URL: https://github.com/apache/kylin/pull/902#issuecomment-547393013 ## Test Build  <img width="1128" alt="image" src="https://user-images.githubusercontent.com/14030549/67767483-a197f780-fa8b-11e9-90c4-1040df59e2b5.png";> <img width="596" alt="image" src="https://user-images.githubusercontent.com/14030549/67767578-ce4c0f00-fa8b-11e9-84e2-f1e07ac1a348.png";> ```json { "uuid": "fa1d7da9-4655-31cb-f0ae-79bc050d803f", "last_modified": 1572365311650, "version": "3.0.0.20500", "name": "PlayStatCube", "is_draft": false, "model_name": "FilmPlayModel", "description": "", "null_string": null, "dimensions": [ { "name": "AUDIENCE_ID", "table": "FILM_PLAY", "column": "AUDIENCE_ID", "derived": null }, { "name": "FILM_ID", "table": "FILM_PLAY", "column": "FILM_ID", "derived": null }, { "name": "WATCH_TIME", "table": "FILM_PLAY", "column": "WATCH_TIME", "derived": null }, { "name": "FILM_ID", "table": "FILM", "column": null, "derived": [ "FILM_ID" ] }, { "name": "TITLE", "table": "FILM", "column": null, "derived": [ "TITLE" ] }, { "name": "DESCRIPTION", "table": "FILM", "column": null, "derived": [ "DESCRIPTION" ] }, { "name": "RELEASE_YEAR", "table": "FILM", "column": null, "derived": [ "RELEASE_YEAR" ] }, { "name": "LANGUAGE_ID", "table": "FILM", "column": null, "derived": [ "LANGUAGE_ID" ] }, { "name": "ORIGINAL_LANGUAGE_ID", "table": "FILM", "column": null, "derived": [ "ORIGINAL_LANGUAGE_ID" ] }, { "name": "RENTAL_DURATION", "table": "FILM", "column": null, "derived": [ "RENTAL_DURATION" ] }, { "name": "FROM", "table": "FILM", "column": null, "derived": [ "FROM" ] }, { "name": "WHERE", "table": "FILM", "column": null, "derived": [ "WHERE" ] }, { "name": "REPLACEMENT_COST", "table": "FILM", "column": null, "derived": [ "REPLACEMENT_COST" ] }, { "name": "RATING", "table": "FILM", "column": null, "derived": [ "RATING" ] }, { "name": "LAST_UPDATE", "table": "FILM", "column": null, "derived": [ "LAST_UPDATE" ] }, { "name": "AUDIENCE_ID", "table": "AUDIENCE", "column": null, "derived": [ "AUDIENCE_ID" ] }, { "name": "FIRST_NAME", "table": "AUDIENCE", "column": null, "derived": [ "FIRST_NAME" ] }, { "name": "LAST_NAME", "table": "AUDIENCE", "column": null, "derived": [ "LAST_NAME" ] }, { "name": "LAST_UPDATE", "table": "AUDIENCE", "column": null, "derived": [ "LAST_UPDATE" ] } ], "measures": [ { "name": "_COUNT_", "function": { "expression": "COUNT", "parameter": { "type": "constant", "value": "1" }, "returntype": "bigint" } }, { "name": "SUM_PAYMENT", "function": { "expression": "SUM", "parameter": { "type": "column", "value": "FILM_PLAY.PAYMENT" }, "returntype": "bigint" } }, { "name": "MAX_PAYMENT", "function": { "expression": "MAX", "parameter": { "type": "column", "value": "FILM_PLAY.PAYMENT" }, "returntype": "integer" } } ], "dictionaries": [], "rowkey": { "rowkey_columns": [ { "column": "FILM_PLAY.AUDIENCE_ID", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, { "column": "FILM_PLAY.FILM_ID", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, { "column": "FILM_PLAY.WATCH_TIME", "encoding": "time", "encoding_version": 1, "isShardBy": false } ] }, "hbase_mapping": { "column_family": [ { "name": "F1", "columns": [ { "qualifier": "M", "measure_refs": [ "_COUNT_", "SUM_PAYMENT", "MAX_PAYMENT" ] } ] } ] }, "aggregation_groups": [ { "includes": [ "FILM_PLAY.AUDIENCE_ID", "FILM_PLAY.FILM_ID", "FILM_PLAY.WATCH_TIME" ], "select_rule": { "hierarchy_dims": [], "mandatory_dims": [], "joint_dims": [] } } ], "signature": "RdlyrCn0CZJq3JxMimu3cg==", "notify_list": [], "status_need_notify": [ "ERROR", "DISCARDED", "SUCCEED" ], "partition_date_start": 0, "partition_date_end": 3153600000000, "auto_merge_time_ranges": [ 604800000, 2419200000 ], "volatile_range": 0, "retention_range": 0, "engine_type": 2, "storage_type": 2, "override_kylin_properties": {}, "cuboid_black_list": [], "parent_forward": 3, "mandatory_dimension_set_list": [], "snapshot_table_desc_list": [] } ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
![https://user-images.githubusercontent.com/14030549/67767483-a197f780-fa8b-11e9-90c4-1040df59e2b5.png"](https://user-images.githubusercontent.com/14030549/67767483-a197f780-fa8b-11e9-90c4-1040df59e2b5.png"){kind=link}
![https://user-images.githubusercontent.com/14030549/67767578-ce4c0f00-fa8b-11e9-84e2-f1e07ac1a348.png"](https://user-images.githubusercontent.com/14030549/67767578-ce4c0f00-fa8b-11e9-84e2-f1e07ac1a348.png"){kind=link}