[jira] [Created] (HIVE-13279) SHOW TABLE EXTENDED doesn't show the correct lastUpdateTime of partition's file system

["Aleksey Vovchenko (JIRA)" <ji...@apache.org>]

Aleksey Vovchenko created HIVE-13279:
----------------------------------------

             Summary: SHOW TABLE EXTENDED doesn't show the correct lastUpdateTime of partition's file system
                 Key: HIVE-13279
                 URL: https://issues.apache.org/jira/browse/HIVE-13279
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.0.0
            Reporter: Aleksey Vovchenko
            Assignee: Aleksey Vovchenko


h2. STEP 1. Create test Tables

Execute in command line:

{noformat} 
nano test.data
{noformat} 

Add to file:

{noformat}
1,aa
2,aa
3,ff
4,sad
5,adsf
6,adsf
7,affss
{noformat}

{noformat}
hadoop fs -put test.data /
{noformat} 

{noformat}
hive> create table test (x int, y string, z string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
hive> create table ptest(x int, y string) partitioned by(z string); 
hive> LOAD DATA  INPATH '/test.data' OVERWRITE INTO TABLE test;
hive> insert overwrite table ptest partition(z=65) select * from test;
hive> insert overwrite table ptest partition(z=67) select * from test;
{noformat}

h2. STEP 2. Compare lastUpdateTime

Execute in Hive shell:

{noformat}
hive> SHOW TABLE EXTENDED FROM default LIKE 'ptest' PARTITION(z='65');
hive> SHOW TABLE EXTENDED FROM default LIKE 'ptest' PARTITION(z='67');
{noformat}

lastUpdateTime should be different.

h2. STEP 3. Put data into hdfs and compare lastUpdateTime

Execute in command line:

{noformat}
hadoop fs -put test.data /user/hive/warehouse/ptest
{noformat}

Execute in Hive shell:

{noformat}
hive> SHOW TABLE EXTENDED FROM default LIKE 'ptest' PARTITION(z='65');
hive> SHOW TABLE EXTENDED FROM default LIKE 'ptest' PARTITION(z='67');
{noformat}

lastUpdateTime should be different but they are same.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)