Mala Chikka Kempanna created IMPALA-7225: --------------------------------------------
Summary: Refresh command on single partition resets the row count of partition to -1 Key: IMPALA-7225 URL: https://issues.apache.org/jira/browse/IMPALA-7225 Project: IMPALA Issue Type: Bug Reporter: Mala Chikka Kempanna Doing refresh on single partition resets it's row count to -1 {code} [nightly513-unsecure-2.gce.cloudera.com:21000] > show partitions web_logs_new; Query: show partitions web_logs_new +------------+-------+--------+----------+--------------+-------------------+--------+-------------------+---------------------------------------------------------------------------------------------------------+ | date_col | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats | Location | +------------+-------+--------+----------+--------------+-------------------+--------+-------------------+---------------------------------------------------------------------------------------------------------+ | 2015-11-18 | -1 | 1 | 112.15KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-18 | | 2015-11-19 | -1 | 1 | 98.83KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-19 | | 2015-11-20 | -1 | 1 | 101.57KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-20 | | 2015-11-21 | -1 | 1 | 82.99KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-21 | | Total | -1 | 4 | 395.54KB | 0B | | | | | +------------+-------+--------+----------+--------------+-------------------+--------+-------------------+---------------------------------------------------------------------------------------------------------+ Fetched 5 row(s) in 0.01s [nightly513-unsecure-2.gce.cloudera.com:21000] > compute stats web_logs_new; Query: compute stats web_logs_new +------------------------------------------+ | summary | +------------------------------------------+ | Updated 4 partition(s) and 28 column(s). | +------------------------------------------+ Fetched 1 row(s) in 1.31s [nightly513-unsecure-2.gce.cloudera.com:21000] > show partitions web_logs_new; Query: show partitions web_logs_new +------------+-------+--------+----------+--------------+-------------------+--------+-------------------+---------------------------------------------------------------------------------------------------------+ | date_col | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats | Location | +------------+-------+--------+----------+--------------+-------------------+--------+-------------------+---------------------------------------------------------------------------------------------------------+ | 2015-11-18 | 250 | 1 | 112.15KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-18 | | 2015-11-19 | 250 | 1 | 98.83KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-19 | | 2015-11-20 | 250 | 1 | 101.57KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-20 | | 2015-11-21 | 250 | 1 | 82.99KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-21 | | Total | 1000 | 4 | 395.54KB | 0B | | | | | +------------+-------+--------+----------+--------------+-------------------+--------+-------------------+---------------------------------------------------------------------------------------------------------+ Fetched 5 row(s) in 0.01s [nightly513-unsecure-2.gce.cloudera.com:21000] > refresh web_logs_new partition(date_col='2015-11-18'); Query: refresh web_logs_new partition(date_col='2015-11-18') Query submitted at: 2018-06-29 12:53:32 (Coordinator: http://nightly513-unsecure-2.gce.cloudera.com:25000) Query progress can be monitored at: http://nightly513-unsecure-2.gce.cloudera.com:25000/query_plan?query_id=7146dedb62cb6503:bc403a8500000000 Fetched 0 row(s) in 0.06s [nightly513-unsecure-2.gce.cloudera.com:21000] > show partitions web_logs_new; Query: show partitions web_logs_new +------------+-------+--------+----------+--------------+-------------------+--------+-------------------+---------------------------------------------------------------------------------------------------------+ | date_col | #Rows | #Files | Size | Bytes Cached | Cache Replication | Format | Incremental stats | Location | +------------+-------+--------+----------+--------------+-------------------+--------+-------------------+---------------------------------------------------------------------------------------------------------+ | 2015-11-18 | -1 | 1 | 112.15KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-18 | | 2015-11-19 | 250 | 1 | 98.83KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-19 | | 2015-11-20 | 250 | 1 | 101.57KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-20 | | 2015-11-21 | 250 | 1 | 82.99KB | NOT CACHED | NOT CACHED | TEXT | false | hdfs://nightly513-unsecure-1.gce.cloudera.com:8020/user/hive/warehouse/web_logs_new/date_col=2015-11-21 | | Total | 1000 | 4 | 395.54KB | 0B | | | | | +------------+-------+--------+----------+--------------+-------------------+--------+-------------------+---------------------------------------------------------------------------------------------------------+ Fetched 5 row(s) in 0.01s {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)