def read_filter(project_id, instance_id, table_id): client = bigtable.Client(project=project_id, admin=True) instance = client.instance(instance_id) table = instance.table(table_id) rows = table.read_rows(filter_=row_filters.ValueRegexFilter(b"PQ2A.*$")) for row in rows: print_row(row)
def filter_limit_value_regex(project_id, instance_id, table_id): client = bigtable.Client(project=project_id, admin=True) instance = client.instance(instance_id) table = instance.table(table_id) rows = table.read_rows( filter_=row_filters.ValueRegexFilter("PQ2A.*$".encode("utf-8"))) for row in rows: print_row(row)
def filter_composing_interleave(project_id, instance_id, table_id): client = bigtable.Client(project=project_id, admin=True) instance = client.instance(instance_id) table = instance.table(table_id) rows = table.read_rows(filter_=row_filters.RowFilterUnion( filters=[row_filters.ValueRegexFilter("true"), row_filters.ColumnQualifierRegexFilter("os_build")])) for row in rows: print_row(row)
def filter_composing_condition(project_id, instance_id, table_id): client = bigtable.Client(project=project_id, admin=True) instance = client.instance(instance_id) table = instance.table(table_id) rows = table.read_rows(filter_=row_filters.ConditionalRowFilter( base_filter=row_filters.RowFilterChain(filters=[ row_filters.ColumnQualifierRegexFilter("data_plan_10gb"), row_filters.ValueRegexFilter("true") ]), true_filter=row_filters.ApplyLabelFilter(label="passed-filter"), false_filter=row_filters.ApplyLabelFilter(label="filtered-out"))) for row in rows: print_row(row)
def write_conditional(project_id, instance_id, table_id): client = bigtable.Client(project=project_id, admin=True) instance = client.instance(instance_id) table = instance.table(table_id) timestamp = datetime.datetime.utcnow() column_family_id = "stats_summary" row_key = "phone#4c410523#20190501" row_filter = row_filters.RowFilterChain(filters=[ row_filters.FamilyNameRegexFilter(column_family_id), row_filters.ColumnQualifierRegexFilter("os_build"), row_filters.ValueRegexFilter("PQ2A\\..*"), ]) row = table.conditional_row(row_key, filter_=row_filter) row.set_cell(column_family_id, "os_name", "android", timestamp) row.commit() print("Successfully updated row's os_name.")