A complete solution for open data platforms, enterprise data catalogs, data lakes and data management. Open source, mature, fully-featured and production ready.

DataHub

Hi team, I am using datahub 0.9.0 and trying to ingest data using the cli from trino but the ingestion is failing with 

HttpError: error 400: b'&lt;html&gt;\r\n&lt;head&gt;&lt;title&gt;400 The plain HTTP request was sent to HTTPS port&lt;/title&gt;&lt;/head&gt;\r\n&lt;body&gt;\r\n&lt;center&gt;&lt;h1&gt;400 Bad Request&lt;/h1&gt;&lt;/center&gt;\r\n&lt;center&gt;The plain HTTP request was sent to HTTPS port&lt;/center&gt;\r\n&lt;/body&gt;\r\n&lt;/html&gt;\r\n'

Can someone help me with the issue is and how I can fix it.
TIA

hey <@U0492PZFK16> can you provide the full stacktrace?

stack.txt

Hi Sandi, could you try the steps listed here and let me know if anything changes? <https://datahubproject.io/docs/debugging/>

Hi <@U042KCFV9GX> I tried the steps and everything is green. I am able to connect other sources as well like pg, Kafka and dbt. Facing issue only with trino

Hi Sandi, have you reviewed the Trino ingestion docs as well? <https://datahubproject.io/docs/generated/ingestion/sources/trino>

trino-ingest-error.txt

<@U042KCFV9GX> My trino instance is not running via HTTPS.  Are we able to specify that in the recipe? Right not I get errors due to the ingestion calling the HTTPS endpoint. Thanks!

```"[2022-11-15 15:25:46,797] ERROR    {datahub.entrypoints:206} - Command failed: HTTPSConnectionPool(host='172.30.231.2', port=8085): Max "
           'retries exceeded with url: /v1/statement (Caused by ConnectTimeoutError(&lt;urllib3.connection.HTTPSConnection object at 0x7f745dcb5a20&gt;, '
           "'Connection to 172.30.231.2 timed out. (connect timeout=30.0)'))\n"```

<@U01GZEETMEZ> any idea if it’s possible to set the Trino source to http instead of https?

Could you try setting - you’ll need to click the yaml tab in the UI
```# options should be at the same level of indentation as username, password, etc
options:
  connect_args:
    http_scheme: http```

<@U01GZEETMEZ> That worked perfectly.  Thank you!

Awesome - I’ve added that to our sample recipe in the docs <https://github.com/datahub-project/datahub/pull/6461>