...
No Format |
---|
$ schematool -help usage: schemaTool -dbType <databaseType> Metastore database type -driver <driver> Driver name for connection -dryRun List SQL scripts (no execute) -help Print this message -info Show config and schema details -initSchema Schema initialization -initSchemaTo <initTo> Schema initialization to a version -metaDbType <metaDatabaseType> Used only if upgrading the system catalog for hive -passWord <password> Override config file password -upgradeSchema Schema upgrade -upgradeSchemaFrom <upgradeFrom> Schema upgrade from a version -url <url> Connection url to the database -userName <user> Override config file user name -verbose Only print SQL statements (Additional catalog related options added in Hive 3.0.0 (HIVE-19135] release are below. -createCatalog <catalogname><catalog> Create catalog with given name -catalogLocation <location> Location of new catalog, required when adding a catalog -catalogDescription <description> Description of new catalog -ifNotExists If passed then it is not an error to create an existing catalog -moveDatabase <database> Move a database between catalogs. All tables under it would still be under it as part of new catalog. Argument is the database name. Requires --fromCatalog and --toCatalog parameters as well -moveTable <table> Move a table to a different database. Argument is the table name. Requires --fromCatalog, --toCatalog, --fromDatabase, and --toDatabase -toCatalog <catalog> Catalog a moving database or table is going to. This is required if you are moving a database or table. -fromCatalog <catalog> Catalog a moving database or table is coming from. This is required if you are moving a database or table. -toDatabase <database> Database a moving table is going to. This is required if you are moving a table. -fromDatabase <database> Database a moving table is coming from. This is required if you are moving a table. |
...