ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Magda <dma...@apache.org>
Subject Re: SQL usability issues
Date Thu, 17 Aug 2017 01:01:35 GMT
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