Page History

$ schematool -help
usage: schemaTool
 -dbTypealterCatalog <databaseType><arg>             Metastore database type
 -driverAlter <driver>a catalog, requires
                 Driver name for connection
 -dryRun               --catalogLocation and/or
             List SQL scripts (no execute)
 -help                  --catalogDescription parameter as well
 -catalogDescription <arg>       Print this message
 -infoDescription of new catalog
 -catalogLocation <arg>             Location of new catalog, required when
        Show config and schema details
 -initSchema                       adding Schemaa initializationcatalog
 -initSchemaTocreateCatalog <initTo><arg>             Schema initialization toCreate a catalog, versionrequires
 -metaDbType <metaDatabaseType>     Used only if upgrading the system catalog for hive
 -passWord <password>               Override config file password
 --upgradeSchemacatalogLocation parameter as well
 -createLogsTable <arg>             Create table for Schema upgradeHive
 -upgradeSchemaFrom <upgradeFrom>   Schema upgrade from a version
 -url <url>                         Connection url to the databasewarehouse/compute logs
 -userNamecreateUser <user>                   Override config file user name
Create -verbosethe Hive user, set hiveUser to
                      Only print SQL statements
(Additional catalog related options added in Hive 3.0.0 (HIVE-19135] release are below.
 -createCatalog <catalog>    the db admin user and the hive
   Create catalog with given name
 -catalogLocation <location>        Location of new catalog, required when adding a catalog
 -catalogDescription <description>  Description of new catalog
 -ifNotExists   password to the db admin password with
              If passed then it is not an error to create an existing catalog
 -moveDatabase <database>        this
 -dbOpts <databaseOpts>           Move a databaseBackend betweenDB catalogs.specific options
 All-dbType tables<databaseType> under it would still be under it as part of new catalog. ArgumentMetastore isdatabase thetype
 database-driver name.<driver> Requires --fromCatalog and --toCatalog parameters as well
 -moveTable  <table>         driver name for connection
 -dropAllDatabases   Move a table to a different database.  Argument is the table name. Requires --fromCatalog, --toCatalog, --fromDatabase, and --toDatabase 
 -toCatalog  <catalog> Drop all Hive databases (with
                 Catalog a moving database or table is going to.  This is required if you are moving a database or tableCASCADE).
 -fromCatalogThis <catalog>will remove all managed
          Catalog a moving database or table is coming from.  This is required if you are moving a database or table.
 -toDatabase  <database>   data!
 -dryRun        Database a moving table is going to.  This is required if you are moving a table.
 -fromDatabase <database>  list SQL scripts (no execute)
 -fromCatalog <arg>                 DatabaseCatalog a moving database or table is
                                    coming from.  This is required if you
 are moving a table.


                                 are moving a database or table.
 -fromDatabase <arg>                Database a moving table is coming
                                    from.  This is required if you are
                                    moving a table.
 -help                              print this message
 -hiveDb <arg>                      Hive database (for use with
                                    createUser)
 -hivePassword <arg>                Hive password (for use with
                                    createUser)
 -hiveUser <arg>                    Hive user (for use with createUser)
 -ifNotExists                       If passed then it is not an error to
                                    create an existing catalog
 -info                              Show config and schema details
 -initOrUpgradeSchema               Initialize or upgrade schema to latest
                                    version
 -initSchema                        Schema initialization
 -initSchemaTo <initTo>             Schema initialization to a version
 -mergeCatalog <arg>                Merge databases from a catalog into
                                    other, Argument is the source catalog
                                    name Requires --toCatalog to indicate
                                    the destination catalog
 -metaDbType <metaDatabaseType>     Used only if upgrading the system
                                    catalog for hive
 -moveDatabase <arg>                Move a database between catalogs.
                                    Argument is the database name.
                                    Requires --fromCatalog and --toCatalog
                                    parameters as well
 -moveTable <arg>                   Move a table to a different database.
                                    Argument is the table name. Requires
                                    --fromCatalog, --toCatalog,
                                    --fromDatabase, and --toDatabase
                                    parameters as well.
 -passWord <password>               Override config file password
 -retentionPeriod <arg>             Specify logs table retention period
 -servers <serverList>              a comma-separated list of servers used
                                    in location validation in the format
                                    of scheme://authority (e.g.
                                    hdfs://localhost:8000)
 -toCatalog <arg>                   Catalog a moving database or table is
                                    going to.  This is required if you are
                                    moving a database or table.
 -toDatabase <arg>                  Database a moving table is going to.
                                    This is required if you are moving a
                                    table.
 -upgradeSchema                     Schema upgrade
 -upgradeSchemaFrom <upgradeFrom>   Schema upgrade from a version
 -url <url>                         connection url to the database
 -userName <user>                   Override config file user name
 -validate                          Validate the database
 -verbose                           only print SQL statements
 -yes                               Don't ask for confirmation when using
                                    -dropAllDatabases.