|
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;
}
}
}
