hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasad Chakka (JIRA)" <>
Subject [jira] Commented: (HIVE-142) Create a metastore check command
Date Tue, 06 Jan 2009 16:48:44 GMT


Prasad Chakka commented on HIVE-142:

Code looks good. Found few usability issues

1) msck on all tables prints information only at the end of checking on all tables. If there
is an en exception in the middle, then it doesn't print information collected so far. It would
be better to print the information before exiting.

2) there should be an option to continue if a check fails on a table.

3) the table name could have a wild card

4) there should be an option to check only tables and not partitions 

Apart from 1) everything else can be fixed in additional JIRAs. 

> Create a metastore check command
> --------------------------------
>                 Key: HIVE-142
>                 URL:
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Metastore
>            Reporter: Johan Oskarsson
>            Assignee: Johan Oskarsson
>             Fix For: 0.2.0
>         Attachments: HIVE-142.patch, HIVE-142.patch
> We need a command to verify that the information in the metastore reflects the data that
is on hdfs. For example partitions can be deleted on hdfs but still be in the metastore.
> From Joydeep Sen Sarma, see ticket HIVE-126 for the full comment:
> for a command line interface - one might want to check the entire database or just a
table or even just one partition. other metadata checks will also be added over time (for
example - do the file types on disk agree with metadata records, bucketing information etc).
So, here's a strawman proposal for a new command:
> alter table <DB>[.TABLE [PARTITION-SPEC]] check [TYPE-LIST]
> where TYPE by default is 'all' (check for all kinds of errors), but can be specified
to a specific type. For example - in this case - we can have a type called 'partitions' (and
then over time we can add other types like 'fileformat' etc.). for v1 - we can just drop the
type-list altogether.
> the check command can produce a list of things that need to be done to fix the format
(like adding any directories not in the metastore - but in hdfs - to the metastore). actually
performing of such steps would require a user confirmation (y/n).

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message