[ https://issues.apache.org/jira/browse/HIVE-1361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12910380#action_12910380 ]
HBase Review Board commented on HIVE-1361: ------------------------------------------ Message from: "Carl Steinbach" <c...@cloudera.com> ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: http://review.cloudera.org/r/862/ ----------------------------------------------------------- Review request for Hive Developers. Summary ------- HIVE-1361 This addresses bug HIVE-1361. http://issues.apache.org/jira/browse/HIVE-1361 Diffs ----- trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java 997199 trunk/hbase-handler/src/java/org/apache/hadoop/hive/hbase/HBaseStatsAggregator.java PRE-CREATION trunk/hbase-handler/src/java/org/apache/hadoop/hive/hbase/HBaseStatsPublisher.java PRE-CREATION trunk/hbase-handler/src/java/org/apache/hadoop/hive/hbase/HBaseStatsSetupConstants.java PRE-CREATION trunk/ql/src/gen-javabean/org/apache/hadoop/hive/ql/plan/api/StageType.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/ExecDriver.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FileSinkOperator.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/JobCloseFeedBack.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/MapRedTask.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/MoveTask.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/Stat.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/StatsTask.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/TableScanOperator.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/Task.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/TaskFactory.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/Utilities.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRFileSink1.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMRTableScan1.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/GenMapRedUtils.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/QB.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/QBParseInfo.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/FileSinkDesc.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/MapredWork.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/StatsWork.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/TableScanDesc.java 997199 trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/StatsAggregator.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/StatsAggregator.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/StatsFactory.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/StatsFactory.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/StatsPublisher.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/StatsPublisher.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/StatsSetupConst.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/StatsSetupConst.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsAggregator.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsAggregator.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsAggregator.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsPublisher.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsPublisher.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsPublisher.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsSetupConstants.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsSetupConstants.java PRE-CREATION trunk/ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsSetupConstants.java PRE-CREATION Diff: http://review.cloudera.org/r/862/diff Testing ------- Thanks, Carl > table/partition level statistics > -------------------------------- > > Key: HIVE-1361 > URL: https://issues.apache.org/jira/browse/HIVE-1361 > Project: Hadoop Hive > Issue Type: Sub-task > Affects Versions: 0.6.0 > Reporter: Ning Zhang > Assignee: Ahmed M Aly > Attachments: HIVE-1361.java_only.patch, HIVE-1361.patch, stats0.patch > > > At the first step, we gather table-level stats for non-partitioned table and > partition-level stats for partitioned table. Future work could extend the > table level stats to partitioned table as well. > There are 3 major milestones in this subtask: > 1) extend the insert statement to gather table/partition level stats > on-the-fly. > 2) extend metastore API to support storing and retrieving stats for a > particular table/partition. > 3) add an ANALYZE TABLE [PARTITION] statement in Hive QL to gather stats for > existing tables/partitions. > The proposed stats are: > Partition-level stats: > - number of rows > - total size in bytes > - number of files > - max, min, average row sizes > - max, min, average file sizes > Table-level stats in addition to partition level stats: > - number of partitions -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.