search

confluentinc / ksql

The database purpose-built for stream processing applications.
https://ksqldb.io
Other
102 stars 1.04k forks source link

Timeout error from httpie #7105

Open mike-thompson-h opened 3 years ago

mike-thompson-h commented 3 years ago

I am making the following request via httpie, but I get a timeout error after 30 seconds:

http POST http://{endpoint}:8088/ksql ksql='SELECT TOP * FROM STREAM_TEST;' --auth-type=basic --auth=:

Do you have any idea why this might be? I cannot see anything wrong with the params I have filled in above

PeterLindner commented 3 years ago

@mike-thompson-h from the docs:

The /ksql resource runs a sequence of SQL statements. All statements, except those starting with SELECT, can be run on this endpoint. To run SELECT statements use the /query endpoint.

Hope this helps

mike-thompson-h commented 3 years ago

Apologies, that was a mistake in what I entered in my original post. I have tried the LIST STREAMS; statement with the ksql endpoint and the SELECT statement with the query endpoint, but I get a timeout error in both cases. I have tried on 2 different machines and I get the same result.

I have used the api key and secret from the kSQLdb app on Confluent Cloud. The app is active. Is there anything I need to do server side on Confluent Cloud to active this?

Thanks for your help Peter