private static void Main(string[] args)
{
try
{
using (var conn = new Connection("xxx", 10000, "xx", "xx",
TProtocolVersion.HIVE_CLI_SERVICE_PROTOCOL_V6))
{
var cursor = conn.GetCursor();
cursor.Execute("use xx");
var list = cursor.FetchMany(100);
if (!list.IsEmpty())
{
var dict = list[0] as IDictionary <string, object>;
foreach (var key in dict.Keys)
{
Console.WriteLine(key + dict[key].ToString());
}
}
else
{
Console.WriteLine("no result");
}
cursor.Execute("select * from xx");
var list2 = cursor.FetchMany(100);
if (!list2.IsEmpty())
{
var dict = list2[0] as IDictionary <string, object>;
foreach (var key in dict.Keys)
{
Console.WriteLine(key + dict[key].ToString());
}
}
else
{
Console.WriteLine("no result");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.ReadLine();
}
private static void Main(string[] args)
{
try
{
using (var conn = new Connection("X.X.X.X", 10000, "hadoop", "hadoop"))
{
var cursor = conn.GetCursor();
cursor.Execute("use default");
var list = cursor.FetchMany(100);
if (!list.IsEmpty())
{
var dict = list[0] as IDictionary <string, object>;
foreach (var key in dict.Keys)
{
Console.WriteLine(key + dict[key].ToString());
}
}
else
{
Console.WriteLine("no result");
}
cursor.Execute("select * from XXX");
var list2 = cursor.FetchMany(100);
if (!list2.IsEmpty())
{
var dict = list2[0] as IDictionary <string, object>;
foreach (var key in dict.Keys)
{
Console.WriteLine(key + dict[key].ToString());
}
}
else
{
Console.WriteLine("no result");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.ReadLine();
}
