Skip to content

Instantly share code, notes, and snippets.

@choplin
Last active December 11, 2015 17:09
Show Gist options
  • Select an option

  • Save choplin/4632940 to your computer and use it in GitHub Desktop.

Select an option

Save choplin/4632940 to your computer and use it in GitHub Desktop.
hive-0.9.0-cdh4.1.1/scripts
├── metastore
│   └── upgrade
│   ├── derby
│   │   ├── 001-HIVE-972.derby.sql
│   │   ├── 002-HIVE-1068.derby.sql
│   │   ├── 003-HIVE-675.derby.sql
│   │   ├── 004-HIVE-1364.derby.sql
│   │   ├── 005-HIVE-417.derby.sql
│   │   ├── 006-HIVE-1823.derby.sql
│   │   ├── 007-HIVE-78.derby.sql
│   │   ├── 008-HIVE-2246.derby.sql
│   │   ├── 008-REVERT-HIVE-2246.derby.sql
│   │   ├── 009-HIVE-2215.derby.sql
│   │   ├── README
│   │   ├── hive-schema-0.3.0.derby.sql
│   │   ├── hive-schema-0.4.0.derby.sql
│   │   ├── hive-schema-0.4.1.derby.sql
│   │   ├── hive-schema-0.5.0.derby.sql
│   │   ├── hive-schema-0.6.0.derby.sql
│   │   ├── hive-schema-0.7.0.derby.sql
│   │   ├── hive-schema-0.8.0.derby.sql
│   │   ├── hive-schema-0.9.0.derby.sql
│   │   ├── upgrade-0.5.0-to-0.6.0.derby.sql
│   │   ├── upgrade-0.6.0-to-0.7.0.derby.sql
│   │   ├── upgrade-0.7.0-to-0.8.0.derby.sql
│   │   └── upgrade-0.8.0-to-0.9.0.derby.sql
│   ├── mysql
│   │   ├── 001-HIVE-972.mysql.sql
│   │   ├── 002-HIVE-1068.mysql.sql
│   │   ├── 003-HIVE-675.mysql.sql
│   │   ├── 004-HIVE-1364.mysql.sql
│   │   ├── 005-HIVE-417.mysql.sql
│   │   ├── 006-HIVE-1823.mysql.sql
│   │   ├── 007-HIVE-78.mysql.sql
│   │   ├── 008-HIVE-2246.mysql.sql
│   │   ├── 009-HIVE-2215.mysql.sql
│   │   ├── README
│   │   ├── hive-schema-0.3.0.mysql.sql
│   │   ├── hive-schema-0.4.0.mysql.sql
│   │   ├── hive-schema-0.4.1.mysql.sql
│   │   ├── hive-schema-0.5.0.mysql.sql
│   │   ├── hive-schema-0.6.0.mysql.sql
│   │   ├── hive-schema-0.7.0.mysql.sql
│   │   ├── hive-schema-0.8.0.mysql.sql
│   │   ├── hive-schema-0.9.0.mysql.sql
│   │   ├── upgrade-0.5.0-to-0.6.0.mysql.sql
│   │   ├── upgrade-0.6.0-to-0.7.0.mysql.sql
│   │   ├── upgrade-0.7.0-to-0.8.0.mysql.sql
│   │   └── upgrade-0.8.0-to-0.9.0.mysql.sql
│   └── oracle
│   ├── hive-schema-0.8.0.oracle.sql
│   └── hive-schema-0.9.0.oracle.sql
└── pdk
├── build-plugin.xml
└── class-registration.xsl
6 directories, 49 files
$ rpm -q hive
hive-0.9.0+150-1.cdh4.1.1.p0.4.el6.noarch
$ rpm -ql hive | grep scripts/metastore
/usr/lib/hive/scripts/metastore
/usr/lib/hive/scripts/metastore/upgrade
/usr/lib/hive/scripts/metastore/upgrade/derby
/usr/lib/hive/scripts/metastore/upgrade/derby/001-HIVE-972.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/002-HIVE-1068.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/003-HIVE-675.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/004-HIVE-1364.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/005-HIVE-417.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/006-HIVE-1823.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/007-HIVE-78.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/008-HIVE-2246.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/008-REVERT-HIVE-2246.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/009-HIVE-2215.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/README
/usr/lib/hive/scripts/metastore/upgrade/derby/hive-schema-0.3.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/hive-schema-0.4.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/hive-schema-0.4.1.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/hive-schema-0.5.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/hive-schema-0.6.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/hive-schema-0.7.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/hive-schema-0.8.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/hive-schema-0.9.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/upgrade-0.5.0-to-0.6.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/upgrade-0.6.0-to-0.7.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/upgrade-0.7.0-to-0.8.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/derby/upgrade-0.8.0-to-0.9.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql
/usr/lib/hive/scripts/metastore/upgrade/mysql/001-HIVE-972.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/002-HIVE-1068.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/003-HIVE-675.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/004-HIVE-1364.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/005-HIVE-417.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/006-HIVE-1823.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/007-HIVE-78.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/008-HIVE-2246.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/009-HIVE-2215.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/README
/usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.3.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.4.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.4.1.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.5.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.6.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.7.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.8.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.9.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/upgrade-0.5.0-to-0.6.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/upgrade-0.6.0-to-0.7.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/upgrade-0.7.0-to-0.8.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql/upgrade-0.8.0-to-0.9.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/oracle
/usr/lib/hive/scripts/metastore/upgrade/oracle/hive-schema-0.8.0.oracle.sql
/usr/lib/hive/scripts/metastore/upgrade/oracle/hive-schema-0.9.0.oracle.sql
$ tree src/metastore/scripts/upgrade/postgres
src/metastore/scripts/upgrade/postgres
├── 001-HIVE-972.postgres.sql
├── 002-HIVE-1068.postgres.sql
├── 003-HIVE-675.postgres.sql
├── 004-HIVE-1364.postgres.sql
├── 005-HIVE-417.postgres.sql
├── 006-HIVE-1823.postgres.sql
├── 007-HIVE-78.postgres.sql
├── 008-HIVE-2246.postgres.sql
├── 008-REVERT-HIVE-2246.postgres.sql
├── 009-HIVE-2215.postgres.sql
├── README
├── hive-schema-0.3.0.postgres.sql
├── hive-schema-0.4.0.postgres.sql
├── hive-schema-0.4.1.postgres.sql
├── hive-schema-0.5.0.postgres.sql
├── hive-schema-0.6.0.postgres.sql
├── hive-schema-0.7.0.postgres.sql
├── hive-schema-0.8.0.postgres.sql
├── upgrade-0.5.0-to-0.6.0.postgres.sql
├── upgrade-0.6.0-to-0.7.0.postgres.sql
└── upgrade-0.7.0-to-0.8.0.postgres.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment