This project seems to do a similar job to SQLLine, except that it is
written in Go rather than Java, and speaks the Avatica protocol rather
than JDBC.

A few observations:

1. The best fit for it would be in the avatica-go project. But SQLLine
has been successful as an independent project (not tied to any
particular back-end). The loose coupling has been successful for both
Calcite/Avatica and SQLLine. So, I wonder whether this could also be
successful as an independent project. Avatica-go could reference it,
in the same way that Calcite includes a bash script to launch SQLLine,
even though SQLLine is independently developed, versioned and
released.

(Hive forked SQLLine to create a utility, BeeLine, that is now part of
their source tree. In my opinion that was a mistake. It would have
been better if they had referenced SQLLine, and added hooks to
customize it.)

2. Would it be possible to make this CLI more loosely coupled? Maybe
it should depend on Go's equivalent of JDBC (sorry I'm no Go expert)
rather than directly on the Avatica API. Then it could be used as a
CLI to talk to other databases.

Julian







On Sun, Oct 15, 2023 at 8:01 AM Hongyu Guo <[email protected]> wrote:
>
> Hi Satya,
> I take a quick look for your repository, I'm not sure if your project has
> already finished, I notice some .go file is empty, did you forget to push
> some commits?
>
> From the current code, you have imported the calcite-avatica-go project and
> provided a command line tool. I don't think you need to create a new
> project, it would be better choice to submit the new feature you mentioned
> in the form of a Pull Request to calcite-avatica.
>
> You can log a new JIRA case first.
>
> Best,
> Hongyu Guo
>
> Satya Kommula <[email protected]> 于2023年10月15日周日 13:49写道:
>
> > Dear Apache Calcite Development Team,
> >
> > I hope this message finds you well. I am writing to express my interest in
> > donating the "calcite-cli" repository, available at "
> > https://github.com/satyakommula96/calcite-cli"; to the Apache Calcite
> > project. This repository provides a valuable SQL prompt for executing both
> > multiline and single-line queries, which aligns with the capabilities of
> > the Calcite project.
> > The "calcite-cli" repository has been developed with the aim of enhancing
> > the SQL querying experience by providing features that align with the
> > principles and objectives of Apache Calcite. It enables users to work with
> > complex queries, offering both multiline and single-line query support,
> > which is crucial for a wide range of use cases.
> > I believe that integrating "calcite-cli" with the Apache Calcite project
> > would be mutually beneficial. It would provide the Calcite community with a
> > valuable tool for query execution and testing, and it would allow me to
> > contribute to the ongoing development and improvement of Apache Calcite. I
> > am committed to supporting and maintaining this repository in collaboration
> > with the Calcite community.
> > I kindly request that you consider accepting this donation and provide
> > guidance on the process for transferring ownership and control of the
> > "calcite-cli" repository to the Apache Calcite project. Please let me know
> > if there are any specific steps or requirements I need to follow to
> > facilitate this process.
> > I am excited about the possibility of contributing to the Apache Calcite
> > project and further advancing the capabilities of the SQL prompt. Your
> > feedback and guidance are highly appreciated, and I am looking forward to
> > being a part of the Apache Calcite community.
> > Thank you for your time and consideration.
> > Best regards,Satya Kommula.

Reply via email to