ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Valentin Kulichenko <valentin.kuliche...@gmail.com>
Subject Re: SQL usability issues
Date Thu, 17 Aug 2017 00:55:22 GMT
Denis,

I think this article should be more generic, describing how to connect a
generic JDBC tool to Ignite (probably using DBeaver as an example).

Right now it looks like out of all such tools we support only DBeaver for
some reason :)

What do you think?

-Val

On Wed, Aug 16, 2017 at 1:49 PM, Denis Magda <dmagda@apache.org> wrote:

> Igniters,
>
> I’ve prepared the getting started basing on DBeaver tool:
> https://apacheignite-tools.readme.io/docs/dbeaver <
> https://apacheignite-tools.readme.io/docs/dbeaver>
>
> That guide is based on the generic one made out by Akmal:
> https://apacheignite.readme.io/docs/getting-started-sql <
> https://apacheignite.readme.io/docs/getting-started-sql>
>
> During the work on the guide we faced one more issue that prevents us from
> using the bulk inserts:
> https://issues.apache.org/jira/browse/IGNITE-6092 <
> https://issues.apache.org/jira/browse/IGNITE-6092>
>
> *Alexander P.*, *Vladimir*, how difficult is to support this feature?
>
> —
> Denis
>
> > On Aug 13, 2017, at 9:20 AM, Dmitriy Setrakyan <dsetrakyan@apache.org>
> wrote:
> >
> > On Fri, Aug 11, 2017 at 7:31 PM, Denis Magda <dmagda@gridgain.com>
> wrote:
> >
> >> Dmitriy,
> >>
> >> That's the documentation that shows how to configure Pentaho via JDBC:
> >> https://apacheignite-tools.readme.io/v2.1/docs/pentaho
> >
> >
> > I am not sure I agree. Why would I look at Pentaho integration when
> trying
> > to configure a generic SQL viewer tool? We need a generic documentation
> > section for configuring JDBC/ODBC drivers with 3rd party tools.
> >
> >
> >>
> >>
> >> Plus on the tools' domain you can see Tableau based ODBC example.
> >>
> >> So, I'm not sure we need something else from the documentation
> standpoint.
> >> I would rather add a direct reference from JDBC/ODBC docs to Pentaho and
> >> Tablea.
> >>
> >> Denis
> >>
> >> On Friday, August 11, 2017, Dmitriy Setrakyan <dsetrakyan@apache.org>
> >> wrote:
> >>
> >>> Igniters,
> >>>
> >>> I have tried to connect to Ignite from DBeaver [1], and realized that
> >> there
> >>> are some usability issues we need to address before the next release:
> >>>
> >>>   1. We need to have documentation on how to configure JDBC and ODBC
> >>>   drivers with external SQL tools [2]
> >>>   2. You cannot highlight multiple SQL statements and run them together
> >>> [3]
> >>>   3. Commands like *DESCRIBE* or *SHOW* do not work [4]
> >>>   4. Schema, index, and table metadata is not displayed [5]. Looks like
> >>>   this fix was already implemented.
> >>>
> >>> The links to the tickets are below.
> >>>
> >>> [1] http://dbeaver.jkiss.org/
> >>> [2] https://issues.apache.org/jira/browse/IGNITE-6048
> >>> [3] https://issues.apache.org/jira/browse/IGNITE-6046
> >>> [4] https://issues.apache.org/jira/browse/IGNITE-6047
> >>> [5] https://issues.apache.org/jira/browse/IGNITE-5233
> >>>
> >>> D.
> >>>
> >>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message