来自 C# 客户端的 Apache Arrow 飞行 SQL

这里有示例代码：

https://github.com/apache/arrow/blob/master/csharp/examples/FlightClientExample/Program.cs

但是，要让它在 Dremio 中工作，您需要添加身份验证。以下是如何在 localhost 测试环境中对“HTTP”（而不是 https）使用基本身份验证的示例。Flight 侦听端口 32010。我在示例中硬编码了用户名“mydremiouser”和密码“mydremiopassword”。

// ...
            string host = args.Length > 0 ? args[0] : "localhost";
            string port = args.Length > 1 ? args[1] : "32010";
            string encoded = System.Convert.ToBase64String(System.Text.Encoding.GetEncoding("ISO-8859-1").GetBytes("mydremiouser" + ":" + "mydremiopassword"));
            
            var httpClient = new HttpClient();
            httpClient.DefaultRequestHeaders.Add("Authorization", "Basic " + encoded);

            var address = $"http://{host}:{port}";
            var channel = GrpcChannel.ForAddress(address, new GrpcChannelOptions
            {
                HttpClient = httpClient
            });

            FlightClient client = new FlightClient(channel);
// ...