You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2012/07/24 11:53:33 UTC

[jira] [Created] (HIVE-3293) Load file into a table does not update table statistics

Namit Jain created HIVE-3293:
--------------------------------

             Summary: Load file into a table does not update table statistics
                 Key: HIVE-3293
                 URL: https://issues.apache.org/jira/browse/HIVE-3293
             Project: Hive
          Issue Type: Bug
            Reporter: Namit Jain


create table smb_bucket_1(key int, value string);

load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;


does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-3293:
-----------------------------

    Attachment: hive.3293.2.patch

Latest patch attached
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch, hive.3293.2.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13429283#comment-13429283 ] 

Kevin Wilfong commented on HIVE-3293:
-------------------------------------

Thanks Namit.  +1
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach updated HIVE-3293:
---------------------------------

    Status: Open  (was: Patch Available)

Please attach the most recent version of the patch to this ticket.
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13429265#comment-13429265 ] 

Kevin Wilfong commented on HIVE-3293:
-------------------------------------

One comment on the diff, otherwise looks good.
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Assigned] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain reassigned HIVE-3293:
--------------------------------

    Assignee: Namit Jain
    
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-3293:
-----------------------------

    Status: Patch Available  (was: Open)
    
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13425951#comment-13425951 ] 

Namit Jain commented on HIVE-3293:
----------------------------------

The number of rows need a complete scan.

However, the number of files, size etc. should be fixed.
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13433300#comment-13433300 ] 

Kevin Wilfong commented on HIVE-3293:
-------------------------------------

That's exactly what happened, thanks Namit.
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>          Components: Statistics
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>             Fix For: 0.10.0
>
>         Attachments: hive.3293.1.patch, hive.3293.2.patch, hive.3293.3.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13429984#comment-13429984 ] 

Carl Steinbach commented on HIVE-3293:
--------------------------------------

Thanks. Looks good to me.
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>          Components: Statistics
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch, hive.3293.2.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-3293:
-----------------------------

    Status: Open  (was: Patch Available)
    
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-3293:
-----------------------------

    Status: Patch Available  (was: Open)
    
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13427558#comment-13427558 ] 

Kevin Wilfong commented on HIVE-3293:
-------------------------------------

Commented on the diff.
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach updated HIVE-3293:
---------------------------------

    Component/s: Statistics
    
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>          Components: Statistics
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch, hive.3293.2.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-3293:
-----------------------------

    Attachment: hive.3293.1.patch
    
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Comment Edited] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428806#comment-13428806 ] 

Namit Jain edited comment on HIVE-3293 at 8/5/12 5:35 AM:
----------------------------------------------------------

comments addressed
                
      was (Author: namit):
    comments addrssed
                  
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kevin Wilfong updated HIVE-3293:
--------------------------------

    Fix Version/s: 0.10.0
    
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>          Components: Statistics
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>             Fix For: 0.10.0
>
>         Attachments: hive.3293.1.patch, hive.3293.2.patch, hive.3293.3.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-3293:
-----------------------------

      Resolution: Fixed
    Hadoop Flags: Reviewed
          Status: Resolved  (was: Patch Available)

This was committed by Kevin last week, I think he could not update the
jira since it was down.
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>          Components: Statistics
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch, hive.3293.2.patch, hive.3293.3.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13429280#comment-13429280 ] 

Namit Jain commented on HIVE-3293:
----------------------------------

that was when i was testing on my mac - addressed.
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428806#comment-13428806 ] 

Namit Jain commented on HIVE-3293:
----------------------------------

comments addrssed
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13426529#comment-13426529 ] 

Namit Jain commented on HIVE-3293:
----------------------------------

https://reviews.facebook.net/D4473
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-3293:
-----------------------------

    Attachment: hive.3293.3.patch

updated more test results
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>          Components: Statistics
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch, hive.3293.2.patch, hive.3293.3.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13427094#comment-13427094 ] 

Namit Jain commented on HIVE-3293:
----------------------------------

updated results
                
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-3293:
-----------------------------

    Status: Patch Available  (was: Open)
    
> Load file into a table does not update table statistics
> -------------------------------------------------------
>
>                 Key: HIVE-3293
>                 URL: https://issues.apache.org/jira/browse/HIVE-3293
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3293.1.patch, hive.3293.2.patch
>
>
> create table smb_bucket_1(key int, value string);
> load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1;
> load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2;
> does not update the stats for smb_bucket_1

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira