# schemacrawler-hive

**Repository Path**: vindell/schemacrawler-hive

## Basic Information

- **Project Name**: schemacrawler-hive
- **Description**: A SchemaCrawler plugin for Apache Hive
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 1
- **Created**: 2018-12-13
- **Last Updated**: 2023-09-01

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# schemacrawler-hive

Unfortunately, [Apache Hive support for SchemaCrawler](http://schemacrawler.sourceforge.net/database-support.html) seems to be unrealistic so far.

As of hive-2.3.2, [hive-jdbc](https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBC) does not support most [java.sql.DatabaseMetaData interface](https://github.com/cloudera/hive/blob/cdh5.4.2-release/jdbc/src/java/org/apache/hive/jdbc/HiveDatabaseMetaData.java#L546-L548). Therefore, this SchemaCrawler hive plugin throws exception: `Database access exception: Method not supported`.  

```
schemacrawler-14.20.03-main/_schemacrawler$ ./sc.sh -server=hive -database=default -password= -host localhost -infolevel=standard -command=list
log4j:WARN No appenders could be found for logger (org.apache.hive.jdbc.Utils).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Database access exception: Method not supported
Re-run SchemaCrawler with the -? option for help
Or, re-run SchemaCrawler with the -loglevel=CONFIG option for details on the error
```