def get_table_create_sql( self, reader: Reader, schema: str, table: str, pk, partition_by: str = None, engine_settings: str = None, sign_column: str = None, version_column: str = None, ): super(ClickHouseVersionedCollapsingMergeTree, self).get_table_create_sql(reader, schema, table, pk, partition_by, engine_settings, sign_column=sign_column) select_sql = reader.get_source_select_sql(schema, table, sign_column) partition_by_str = "" engine_settings_str = "" if partition_by: partition_by_str = f" PARTITION BY {partition_by} " if engine_settings: engine_settings_str = f" SETTINGS {engine_settings} " return f"CREATE TABLE {schema}.{table}{cluster_sql(self.cluster_name)} ENGINE = {self.engine}({sign_column},{version_column}) {partition_by_str} ORDER BY {pk} {engine_settings_str} AS {select_sql} limit 0"
def get_table_create_sql( self, reader: Reader, schema: str, table: str, pk, partition_by: str = None, engine_settings: str = None, **kwargs, ): partition_by_str = "" engine_settings_str = "" if partition_by: partition_by_str = f" PARTITION BY {partition_by} " if engine_settings: engine_settings_str = f" SETTINGS {engine_settings} " select_sql = reader.get_source_select_sql(schema, table) return f"CREATE TABLE {schema}.{table} ENGINE = {self.engine} {partition_by_str} ORDER BY {pk} {engine_settings_str} AS {select_sql} limit 0"
def get_table_create_sql( self, reader: Reader, schema: str, table: str, pk, partition_by: str = None, engine_settings: str = None, sign_column: str = None, version_column: str = None, ): select_sql = reader.get_source_select_sql(schema, table, sign_column) partition_by_str = "" engine_settings_str = "" if partition_by: partition_by_str = f" PARTITION BY {partition_by} " if engine_settings: engine_settings_str = f" SETTINGS {engine_settings} " return f"CREATE TABLE {schema}.{table} ENGINE = {self.engine}({sign_column},{version_column}) {partition_by_str} ORDER BY {pk} {engine_settings_str} AS {select_sql} limit 0"
def get_table_create_sql( self, reader: Reader, schema: str, table: str, pk, partition_by: str = None, engine_settings: str = None, **kwargs, ): super(ClickHouseMergeTree, self).get_table_create_sql(reader, schema, table, pk, partition_by, engine_settings, **kwargs) partition_by_str = "" engine_settings_str = "" if partition_by: partition_by_str = f" PARTITION BY {partition_by} " if engine_settings: engine_settings_str = f" SETTINGS {engine_settings} " select_sql = reader.get_source_select_sql(schema, table) return f"CREATE TABLE {schema}.{table}{cluster_sql(self.cluster_name)} ENGINE = {self.engine} {partition_by_str} ORDER BY {pk} {engine_settings_str} AS {select_sql} limit 0"