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"