通过Terradata odbc驱动程序连接时，Presto协调器返回404错误 [英] Presto coordinator returning 404 error when connecting through Terradata odbc driver

问题描述

我正在尝试连接到驻留在EMR群集上的presto协调器.我正在使用Terradata ODBC驱动程序.我都通过通过ODBC连接对话框将相关细节放入DSN中来测试驱动程序，并编写了一个简单的C#应用​​程序来创建连接(请参见下面的代码).

I am attempting to connect to a presto coordinator that resides on an EMR cluster. I am using the Terradata ODBC driver. I have both tested the driver by putting the pertinent details into the DSN via ODBC connections dialog and written a simple C# application that creates a connection (see the code below).

问题是当在DSN对话框中测试连接或在C#代码中打开连接时，我得到了404错误返回.

The problem is that I am getting a 404 error returned when the connection is either tested in the DSN dialog or opened in the C# code.

我相信AWS中的安全组设置很好，因为我肯定可以进入配置为打开端口8080的主节点.

I believe the security group settings in AWS are fine as I am definitely getting through to the master node which is configured to have port 8080 open.

var connectionString = "Driver=Teradata Presto ODBC Driver;Host=xxx;Port=8080";
OdbcConnection cn = new OdbcConnection(connectionString);
OdbcCommand cmd = new OdbcCommand(sql, cn);
cn.Open();

此代码在运行时将引发一条异常，并显示一条消息"ERROR [HY000] [Teradata] [Presto](1040)HTTP请求出错，响应代码:404".

This code when run will throw an exception with "ERROR [HY000] [Teradata][Presto] (1040) Error with HTTP request, response code: 404" as a message.

我用这个把我的头撞在墙上.非常感谢您提供任何见解.

Am banging my head against the wall with this one. Any insights are very much appreciated.

推荐答案

问题出在我连接到Presto的端口上.我脑子里想的是8080，但实际上是8889.

The problem was the port I was connecting to Presto on. I had got it in my head that it was 8080 but in fact it was 8889.

这篇关于通过Terradata odbc驱动程序连接时，Presto协调器返回404错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！