On Thu, Sep 14, 2023 at 2:43 PM Sutou Kouhei <[email protected]> wrote: > > Hi Junwang, > > Thanks for trying this product! > > Sorry, the example program has problems. Could you try this > patch? > > ---- > diff --git a/example/flight-sql/query-prepared.cc > b/example/flight-sql/query-prepared.cc > index 621b650..a3e1a87 100644 > --- a/example/flight-sql/query-prepared.cc > +++ b/example/flight-sql/query-prepared.cc > @@ -128,7 +128,7 @@ run() > ARROW_RETURN_NOT_OK(i_builder->Append(10)); > ARROW_ASSIGN_OR_RAISE(auto record_batch, > record_batch_builder->Flush()); > ARROW_RETURN_NOT_OK(statement->SetParameters(record_batch)); > - ARROW_ASSIGN_OR_RAISE(auto info, statement->Execute()); > + ARROW_ASSIGN_OR_RAISE(auto info, statement->Execute(call_options)); > for (const auto& endpoint : info->endpoints()) > { > ARROW_ASSIGN_OR_RAISE(auto reader, > @@ -143,7 +143,7 @@ run() > std::cout << chunk.data->ToString() << std::endl; > } > } > - ARROW_RETURN_NOT_OK(statement->Close()); > + ARROW_RETURN_NOT_OK(statement->Close(call_options));
It works! thanks ;) > return sql_client->Close(); > } > // End query > ---- > > Thanks, > -- > kou > > In <CAEG8a3JFkqPeMMioPMegQwciOfo=AO47THZG2S=890aja93...@mail.gmail.com> > "Re: [ANNOUNCE] Apache Arrow Flight SQL adapter for PostgreSQL 0.1.0 > released" on Thu, 14 Sep 2023 14:31:32 +0800, > Junwang Zhao <[email protected]> wrote: > > > Hi Sutou, > > > > On Thu, Sep 14, 2023 at 8:06 AM Sutou Kouhei <[email protected]> wrote: > >> > >> The Apache Arrow team is pleased to announce the 0.1.0 release of > >> the Apache Arrow Flight SQL adapter for PostgreSQL. > >> > >> The release is available now from our website: > >> https://arrow.apache.org/flight-sql-postgresql/0.1.0/install.html > >> > >> Read about what's new in the release: > >> > >> https://arrow.apache.org/blog/2023/09/13/flight-sql-postgresql-0.1.0-release/ > >> > >> Release note: > >> > >> https://arrow.apache.org/flight-sql-postgresql/0.1.0/release-notes.html#version-0-1-0 > >> > >> > >> What is Apache Arrow Flight SQL adapter for PostgreSQL? > >> > >> Apache Arrow Flight SQL adapter for PostgreSQL is a > >> PostgreSQL extension that adds an Apache Arrow Flight SQL > >> endpoint to PostgreSQL. > >> > >> Apache Arrow Flight SQL is a protocol to use Apache Arrow > >> format to interact with SQL databases. You can use Apache > >> Arrow Flight SQL instead of the PostgreSQL wire protocol to > >> interact with PostgreSQL by Apache Arrow Flight SQL adapter > >> for PostgreSQL. > > > > I tried the examples provide in the repo, authenticate-password and > > query-ad-hoc gives the right output, but query-prepared seems > > not working well with following error message: > > > > /build/apache-arrow-13.0.0/cpp/src/arrow/flight/sql/client.cc:154: > > Failed to delete PreparedStatement: IOError: No authorization header. > > Detail: Unauthenticated. Detail: Unauthenticated > > IOError: No authorization header. Detail: Unauthenticated. gRPC client > > debug context: {"created":"@1694672534.441199175","description":"Error > > received from peer > > ipv4:127.0.0.1:15432","file":"/build/apache-arrow-13.0.0/cpp_build/grpc_ep-prefix/src/grpc_ep/src/core/lib/surface/call.cc","file_line":952,"grpc_message":"No > > authorization header. Detail: Unauthenticated","grpc_status":16}. > > Client context: OK. Detail: Unauthenticated > > > > This error came from this line: > > > > *ARROW_RETURN_NOT_OK(statement->SetParameters(record_batch));* > > > > That is to say the authenticate logic in connect is ok, do we need > > some authorization header to address this error? > > > >> > >> Apache Arrow format is designed for fast typed table data > >> exchange. If you want to get large data by SELECT or > >> INSERT/UPDATE large data, Apache Arrow Flight SQL will be > >> faster than the PostgreSQL wire protocol. > >> > >> > >> Please report any feedback to the GitHub issues or mailing lists: > >> * GitHub: https://github.com/apache/arrow-flight-sql-postgresql/issues > >> * ML: https://arrow.apache.org/community/ > >> > >> > >> Thanks, > >> -- > >> The Apache Arrow community > > > > > > > > -- > > Regards > > Junwang Zhao -- Regards Junwang Zhao
