Mailing-List: contact issues-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ignite.apache.org
Date: Mon, 24 Apr 2017 16:14:04 +0000 (UTC)
From: "ASF GitHub Bot (JIRA)" <jira@apache.org>
To: issues@ignite.apache.org
Message-ID: <JIRA.12989970.1468623518000.34161.1493050444202@Atlassian.JIRA>
In-Reply-To: <JIRA.12989970.1468623518000@Atlassian.JIRA>
References: <JIRA.12989970.1468623518000@Atlassian.JIRA> <JIRA.12989970.1468623518179@jira-lw-us.apache.org>
Subject: [jira] [Commented] (IGNITE-3487) _key and _val fields should be
 excluded from 'select * from' queries
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Mon, 24 Apr 2017 16:14:10 -0000


    [ https://issues.apache.org/jira/browse/IGNITE-3487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15981429#comment-15981429 ] 

ASF GitHub Bot commented on IGNITE-3487:
----------------------------------------

GitHub user skalashnikov opened a pull request:

    https://github.com/apache/ignite/pull/1865

    IGNITE-3487: hidden _key and _val columns

    
You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/gridgain/apache-ignite ignite-3487

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/ignite/pull/1865.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 #1865
    
----

----


> _key and _val fields should be excluded from 'select * from' queries
> --------------------------------------------------------------------
>
>                 Key: IGNITE-3487
>                 URL: https://issues.apache.org/jira/browse/IGNITE-3487
>             Project: Ignite
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 1.6
>            Reporter: Valentin Kulichenko
>            Assignee: Sergey Kalashnikov
>              Labels: important
>             Fix For: 2.0
>
>
> We have a pretty serious usability issue - predefined {{_key}} and {{_val}} fields are returned when query like {{select * from}} is executed. First of all, this is counterintuitive because user never defines or configures these fields. Second of all, they actually duplicate all other fields. And finally, they cause serialization exceptions because classes for key and value are not always available.
> We should exclude these fields from {{select * from}} queries, but this is a compatibility breaking change. It should be done in 2.0.


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)