Example #1
0
        static void Main(string[] args)
        {
            string userName  = "******";
            string password  = "******";
            var    byteArray = Encoding.ASCII.GetBytes($"{userName}:{password}");
            Dictionary <string, string> customHeaders = new Dictionary <string, string>();

            customHeaders.Add("Authorization", $"Basic {Convert.ToBase64String(byteArray)}");
            //Uri uri = new Uri("https://powerbiintrahdiiq.azurehdinsight.net/cliservice");
            Uri uri       = new Uri("http://localhost:10001/cliservice");
            var transport = new THttpClientTransport(uri, customHeaders);

            System.Console.WriteLine("Open connection");
            Hive hive = new Hive(transport);

            hive.OpenAsync().Wait();
            System.Console.WriteLine("Get Cursor");
            var cursor = hive.GetCursorAsync().Result;

            System.Console.WriteLine("Execute query");
            cursor.ExecuteAsync("SHOW TABLES").Wait();
            var result = cursor.FetchManyAsync(100).Result;

            if (!result.IsEmpty())
            {
                System.Console.WriteLine("-----------Début-------------");
                foreach (var row in result)
                {
                    System.Console.Write("Row - ");
                    var dict = row as IDictionary <string, object>;
                    foreach (var key in dict.Keys)
                    {
                        System.Console.WriteLine($"{key} : {dict[key].ToString()}");
                    }
                }
                System.Console.WriteLine("-----------Fin-------------");
            }
            else
            {
                System.Console.WriteLine("No result");
            }
            System.Console.WriteLine("Finished");
        }