Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CREATE TABLE fails with useless error if schema registry not up #72

Open
chipmaurer opened this issue Nov 4, 2021 · 0 comments
Open
Assignees

Comments

@chipmaurer
Copy link
Collaborator

chipmaurer commented Nov 4, 2021

presto:cartoondb> create table s3.cartoondb.table1 ( id bigint, name varchar, balance double) WITH (has_header_row = 'false', FORMAT = 'CSV', external_location='s3a://testbucket/db1/' );
Query 20211104_123238_00007_z25g9 failed: java.net.ConnectException: Connection refused (Connection refused)

Here is the server log

2021-11-04T08:37:10.911-0400 ERROR dispatcher-query-13 com.facebook.presto.s3.S3SchemaRegistryManager Cannot connect to schema registry
2021-11-04T08:37:10.911-0400 INFO dispatcher-query-13 com.facebook.presto.s3.S3SchemaRegistryManager Create S3 table schema table1, in group cartoondb to schema registry host: 127.0.0.1 using namespace: s3-schemas
2021-11-04T08:37:10.915-0400 INFO dispatcher-query-13 com.facebook.presto.s3.S3SchemaRegistryManager Add schema: {"$comment":"{"database":"cartoondb","objectDataFormat":"csv","sources":{"testbucket":["/db1/"]},"recordDelimiter":"\n","tablename":"table1","fieldDelimiter":",","hasHeaderRow":"false"}","description":"Format of row of data","type":"object","properties":{"id":{"type":"integer"},"name":{"type":"string"},"balance":{"type":"number"}}}
2021-11-04T08:37:10.951-0400 INFO dispatcher-query-17 com.facebook.presto.event.QueryMonitor TIMELINE: Query 20211104_123710_00009_z25g9 :: Transaction:[bbddb169-775f-4761-843d-4a1325777df0] :: elapsed 93ms :: planning 0ms :: scheduling 93ms :: running 0ms :: finishing 93ms :: begin 2021-11-04T08:37:10.847-04:00 :: end 2021-11-04T08:37:10.940-04:00

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants