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 21:22:44 GMT
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>

—
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