// [END bigtable_reads_row_partial] // [START bigtable_reads_rows] /// <summary> /// /// Reads multiple rows from an existing table. ///</summary> /// <param name="projectId">Your Google Cloud Project ID.</param> /// <param name="instanceId">Your Google Cloud Bigtable Instance ID.</param> /// <param name="tableId">Your Google Cloud Bigtable table ID.</param> public string readRows(string projectId = "YOUR-PROJECT-ID", string instanceId = "YOUR-INSTANCE-ID", string tableId = "YOUR-TABLE-ID") { BigtableClient bigtableClient = BigtableClient.Create(); TableName tableName = new TableName(projectId, instanceId, tableId); RowSet rowSet = RowSet.FromRowKeys("phone#4c410523#20190501", "phone#4c410523#20190502"); ReadRowsStream readRowsStream = bigtableClient.ReadRows(tableName, rowSet); string result = ""; readRowsStream.ForEach(row => result += printRow(row)); return(result); }
// [END bigtable_reads_prefix] // [START bigtable_reads_filter] /// <summary> /// /// Reads using a filter from an existing table. ///</summary> /// <param name="projectId">Your Google Cloud Project ID.</param> /// <param name="instanceId">Your Google Cloud Bigtable Instance ID.</param> /// <param name="tableId">Your Google Cloud Bigtable table ID.</param> public string readFilter(string projectId = "YOUR-PROJECT-ID", string instanceId = "YOUR-INSTANCE-ID", string tableId = "YOUR-TABLE-ID") { BigtableClient bigtableClient = BigtableClient.Create(); TableName tableName = new TableName(projectId, instanceId, tableId); RowFilter filter = RowFilters.ValueRegex("PQ2A.*"); ReadRowsStream readRowsStream = bigtableClient.ReadRows(tableName, filter: filter); string result = ""; readRowsStream.ForEach(row => result += printRow(row)); return(result); }
// [END bigtable_filters_composing_condition] // [START bigtable_filters_limit_row_sample] // [START bigtable_filters_limit_row_regex] // [START bigtable_filters_limit_cells_per_col] // [START bigtable_filters_limit_cells_per_row] // [START bigtable_filters_limit_cells_per_row_offset] // [START bigtable_filters_limit_col_family_regex] // [START bigtable_filters_limit_col_qualifier_regex] // [START bigtable_filters_limit_col_range] // [START bigtable_filters_limit_value_range] // [START bigtable_filters_limit_value_regex] // [START bigtable_filters_limit_timestamp_range] // [START bigtable_filters_limit_block_all] // [START bigtable_filters_limit_pass_all] // [START bigtable_filters_modify_strip_value] // [START bigtable_filters_modify_apply_label] // [START bigtable_filters_composing_chain] // [START bigtable_filters_composing_interleave] // [START bigtable_filters_composing_condition] public string readFilter(string projectId, string instanceId, string tableId, RowFilter filter) { BigtableClient bigtableClient = BigtableClient.Create(); TableName tableName = new TableName(projectId, instanceId, tableId); ReadRowsStream readRowsStream = bigtableClient.ReadRows(tableName, filter: filter); string result = ""; readRowsStream.ForEach(row => result += printRow(row)); if (result == "") { return("empty"); } return(result); }
// [END bigtable_reads_rows] // [START bigtable_reads_row_range] /// <summary> /// /// Reads a range of rows from an existing table. ///</summary> /// <param name="projectId">Your Google Cloud Project ID.</param> /// <param name="instanceId">Your Google Cloud Bigtable Instance ID.</param> /// <param name="tableId">Your Google Cloud Bigtable table ID.</param> public string readRowRange(string projectId = "YOUR-PROJECT-ID", string instanceId = "YOUR-INSTANCE-ID", string tableId = "YOUR-TABLE-ID") { String start = "phone#4c410523#20190501"; String end = "phone#4c410523#201906201"; BigtableClient bigtableClient = BigtableClient.Create(); TableName tableName = new TableName(projectId, instanceId, tableId); RowSet rowSet = RowSet.FromRowRanges(RowRange.ClosedOpen(start, end)); ReadRowsStream readRowsStream = bigtableClient.ReadRows(tableName, rowSet); string result = ""; readRowsStream.ForEach(row => result += printRow(row)); return(result); }
// [END bigtable_reads_row_ranges] // [START bigtable_reads_prefix] /// <summary> /// /// Reads rows starting with a prefix from an existing table. ///</summary> /// <param name="projectId">Your Google Cloud Project ID.</param> /// <param name="instanceId">Your Google Cloud Bigtable Instance ID.</param> /// <param name="tableId">Your Google Cloud Bigtable table ID.</param> public string readPrefix(string projectId = "YOUR-PROJECT-ID", string instanceId = "YOUR-INSTANCE-ID", string tableId = "YOUR-TABLE-ID") { BigtableClient bigtableClient = BigtableClient.Create(); TableName tableName = new TableName(projectId, instanceId, tableId); String prefix = "phone"; Char prefixEndChar = prefix[prefix.Length - 1]; prefixEndChar++; String end = prefix.Substring(0, prefix.Length - 1) + prefixEndChar; RowSet rowSet = RowSet.FromRowRanges(RowRange.Closed(prefix, end)); ReadRowsStream readRowsStream = bigtableClient.ReadRows(tableName, rowSet); string result = ""; readRowsStream.ForEach(row => result += printRow(row)); return(result); }