internal ResultSetResponse InternalTablesRequest(pbc.RepeatedField <string> list)
{
ResultSetResponse response = null;
Task <ResultSetResponse> tResp = _client.TablesRequestAsync("", "", "", list, true, this.ConnectionId, this.Options);
tResp.Wait();
response = tResp.Result;
return(response);
}
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;
}
}
}
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;
}
}
}