[
https://issues.apache.org/jira/browse/IGNITE-10784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16728808#comment-16728808
]
ASF GitHub Bot commented on IGNITE-10784:
-----------------------------------------
GitHub user pavel-kuznetsov opened a pull request:
https://github.com/apache/ignite/pull/5749
IGNITE-10784: added TABLES view
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gridgain/apache-ignite ignite-10784
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/5749.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #5749
----
commit 8aa0e1a89ad5ccd081aa863b3f68d8b7d768e01c
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-24T17:19:25Z
ignite-10784: wip
commit ea4dd42b4497bd561a308d8ff0c6fba9d5d71f24
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-24T23:33:56Z
ignite-10784: Implemented minimal view IGNITE.TABLES.
commit a80e224f45d0624217258f23e281f9dc6569fa14
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-25T10:09:33Z
ignite-10784: Tests wip.
commit 354d0c152952cc039ba7c6a8859c4639d3237826
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-25T12:34:29Z
ignite-10784: Fixed bug with filter. Updated code and tests;
commit 0bad909b65ccf5cdf8ee38fae9c442d3d8940164
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-25T12:47:50Z
ignite-10784: Rename column name;
Renamed column name of the view according to ISO standard.
commit f367f97215033a7e7f4f7d702bcf6cffd39d93dd
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-25T14:11:25Z
ignite-10784: added Affinity column.
commit 526cb3eb98623bbe50c694859a9ea898dbc4401a
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-25T15:00:27Z
ignite-10784: reverted affinity mode info in the view.
AffinityMapper should be handled during IGNITE-10310
commit ca14ca844c484e437aef323082839143daa52bf7
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-25T18:52:31Z
ignite-10784: Added key and field alias columns.
commit 3af040ba1d439228b5e00a615bdb8a97c6aee053
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-25T19:19:18Z
ignite-10784: fixed duplicates.
commit 795486fea87b762f58bbde11f0ec6e242217000c
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-25T19:23:17Z
ignite-10784: Got rid of unnecessary arrays allocations.
commit 6512c06e6bab6bbdcc3162d5a2be02a485806d2a
Author: Pavel Kuznetsov <palmihal@...>
Date: 2018-12-25T19:40:27Z
ignite-10784: Added key/value type name columns to the TABLES view.
----
> SQL: Create a view with list of existing tables
> -----------------------------------------------
>
> Key: IGNITE-10784
> URL: https://issues.apache.org/jira/browse/IGNITE-10784
> Project: Ignite
> Issue Type: Task
> Components: sql
> Reporter: Vladimir Ozerov
> Assignee: Pavel Kuznetsov
> Priority: Major
> Fix For: 2.8
>
>
> We need to create a system view of currently available SQL tables.
> Minimal required information:
> 1) Schema name
> 2) Table name
> 3) Owning cache name
> 4) Owning cache ID
> Other info to consider:
> 1) Affinity column name
> 2) Key/value aliases
> 3) Key/value type names
> 4) Analyse other vendors (e.g. MySQL, Postgresql) and see if any other useful
> information could be exposed (taking in count that a lot of engine properties
> are already exposed through {{CACHES}} view)
> Starting point: {{SqlSystemView}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
