ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitriy Setrakyan <dsetrak...@apache.org>
Subject Re: SQL usability issues
Date Fri, 18 Aug 2017 00:05:53 GMT
On Thu, Aug 17, 2017 at 2:22 PM, Denis Magda <dmagda@apache.org> wrote:

> No I see what you tried to convey. Here it is the doc:
> https://apacheignite.readme.io/docs/sql-tooling <
> https://apacheignite.readme.io/docs/sql-tooling>
>

Looks very nice. I think we should separate all the SQL-related
documentation into its own separate SQL section.


> —
> Denis
>
> > On Aug 16, 2017, at 6:06 PM, Dmitriy Setrakyan <dsetrakyan@apache.org>
> wrote:
> >
> > Denis,
> >
> > I agree with Val. I am OK with using DBeaver as an example, but the name
> of
> > the doc should be generic and the doc should be updated stating that
> > DBeaver is just one example of how Ignite can be used with generic SQL
> > viewer tools.
> >
> > D.
> >
> > On Wed, Aug 16, 2017 at 6:01 PM, Denis Magda <dmagda@apache.org> wrote:
> >
> >> Val,
> >>
> >> This article is generic:
> >> https://apacheignite.readme.io/docs/getting-started-sql <
> >> https://apacheignite.readme.io/docs/getting-started-sql>
> >>
> >> DBeaver, Pentaho and Tableau are given as examples.
> >>
> >> If the description or introduction of the tool should sound clearer
> please
> >> suggest your version.
> >>
> >> —
> >> Denis
> >>
> >>> On Aug 16, 2017, at 5:55 PM, Valentin Kulichenko <
> >> valentin.kulichenko@gmail.com> wrote:
> >>>
> >>> 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