static void Test1()
{
var line = File.ReadLines("account.txt").First();
var ss = line.Split(",");
ss = ss.Select(e => e.Trim()).ToArray();
using (var conn = new HiveConnection(ss[0], ss[1].ToInt(), ss[2], ss[3]))
{
var cmd = conn.CreateCommand();
cmd.Execute("use default");
cmd.Execute("select * from kbb");
var dt = cmd.Fetch(100);
if (dt != null)
{
foreach (var item in dt.Columns)
{
Console.Write(item + ",");
}
Console.WriteLine();
foreach (var row in dt.Rows)
{
Console.WriteLine(row.Join(","));
}
}
for (var i = 0; i < 100_000; i++)
{
var sql = $"insert into kbb (id, name) values ({i + 1},'{DateTime.Now.ToFullString()}')";
var sb = new StringBuilder();
sb.Append(sql);
for (var k = 0; k < 10; k++)
{
sb.Append(",");
sb.Append($"({i + 1},'{DateTime.Now.ToFullString()}')");
}
sql = sb.ToString();
XTrace.WriteLine(sql);
cmd.Execute(sql);
}
}
}
