public TablesRequestAsync ( string catalog, string schemaPattern, string tableNamePattern, pbc |
||
catalog | string | |
schemaPattern | string | |
tableNamePattern | string | |
typeList | pbc |
|
hasTypeList | bool | |
connectionId | string | |
options | RequestOptions | |
return | Task |
public void TableOperationTest() { var client = new PhoenixClient(null); string connId = GenerateRandomConnId(); RequestOptions options = RequestOptions.GetVNetDefaultOptions(); // In VNET mode, PQS requests will be http://<PQS workernode ip>:8765 options.AlternativeHost = "10.17.0.13"; OpenConnectionResponse openConnResponse = null; try { // Opening connection pbc::MapField<string, string> info = new pbc::MapField<string, string>(); openConnResponse = client.OpenConnectionRequestAsync(connId, info, options).Result; // Syncing connection ConnectionProperties connProperties = new ConnectionProperties { HasAutoCommit = true, AutoCommit = true, HasReadOnly = true, ReadOnly = false, TransactionIsolation = 0, Catalog = "", Schema = "", IsDirty = true }; client.ConnectionSyncRequestAsync(connId, connProperties, options).Wait(); // List system tables pbc.RepeatedField<string> list = new pbc.RepeatedField<string>(); list.Add("SYSTEM TABLE"); ResultSetResponse tablesResponse = client.TablesRequestAsync("", "", "", list, true, connId, options).Result; Assert.AreEqual(4, tablesResponse.FirstFrame.Rows.Count); // List all table types ResultSetResponse tableTypeResponse = client.TableTypesRequestAsync(connId, options).Result; Assert.AreEqual(6, tableTypeResponse.FirstFrame.Rows.Count); } catch (Exception ex) { Assert.Fail(ex.Message); } finally { if (openConnResponse != null) { client.CloseConnectionRequestAsync(connId, options).Wait(); openConnResponse = null; } } }
public void TableOperationTest() { var client = new PhoenixClient(_credentials); string connId = GenerateRandomConnId(); RequestOptions options = RequestOptions.GetGatewayDefaultOptions(); // In gateway mode, PQS requests will be https://<cluster dns name>.azurehdinsight.net/hbasephoenix<N>/ // Requests sent to hbasephoenix0/ will be forwarded to PQS on workernode0 options.AlternativeEndpoint = "hbasephoenix0/"; OpenConnectionResponse openConnResponse = null; try { // Opening connection pbc::MapField<string, string> info = new pbc::MapField<string, string>(); openConnResponse = client.OpenConnectionRequestAsync(connId, info, options).Result; // Syncing connection ConnectionProperties connProperties = new ConnectionProperties { HasAutoCommit = true, AutoCommit = true, HasReadOnly = true, ReadOnly = false, TransactionIsolation = 0, Catalog = "", Schema = "", IsDirty = true }; client.ConnectionSyncRequestAsync(connId, connProperties, options).Wait(); // List system tables pbc.RepeatedField<string> list = new pbc.RepeatedField<string>(); list.Add("SYSTEM TABLE"); ResultSetResponse tablesResponse = client.TablesRequestAsync("", "", "", list, true, connId, options).Result; Assert.AreEqual(4, tablesResponse.FirstFrame.Rows.Count); // List all table types ResultSetResponse tableTypeResponse = client.TableTypesRequestAsync(connId, options).Result; Assert.AreEqual(6, tableTypeResponse.FirstFrame.Rows.Count); } catch (Exception ex) { Assert.Fail(ex.Message); } finally { if (openConnResponse != null) { client.CloseConnectionRequestAsync(connId, options).Wait(); openConnResponse = null; } } }