Hive User FAQ

General

I see errors like: Server access Error: Connection timed out url=http://archive.apache.org/dist/hadoop/core/hadoop-0.20.1/hadoop-0.20.1.tar.gz^{Image Removed}

Run the following commands:
cd ~/.ant/cache/hadoop/core/sources
wget http://archive.apache.org/dist/hadoop/core/hadoop-0.20.1/hadoop-0.20.1.tar.gzImage Removed

How to change the warehouse.dir location for older tables?

...

Does Hive support Unicode?

HiveQL

...

You can use Unicode string on data/comments, but cannot use for database/table/column name.

You can use UTF-8 encoding for Hive data. However, other encodings are not supported (HIVE-7142 introduce encoding for LazySimpleSerDe, however, the implementation is not complete and not address all cases).

Hive SQL

Are Hive SQL identifiers (e.g. table names, column names, etc) case sensitive?

No. Hive is case insensitive.

Executing:

SELECT * FROM MyTable WHERE myColumn = 3

is strictly equivalent to

select * from mytable where mycolumn = 3

What are the maximum allowed lengths for

...

Hive SQL identifiers?

Importing Data into Hive

How do I import XML data into Hive?

...

What are dynamic partitions?

Can a Hive table contain data in more than one format?

Is it possible to set the data format on a per-partition basis?

JDBC Driver

Does Hive have a JDBC Driver?

Yes. Look out to the hive-jdbc jar. The driver is 'org.apache.hadoop.hive.jdbc.HiveDriver'.

It supports two modes: a local mode and a remote one.

In the remote mode it connects to the hive server through its Thrift API. The JDBC url to use should be of the form: 'jdbc:hive://hostname:port/databasename'

In the local mode Hive is embedded. The JDBC url to use should be 'jdbc:hive://'.

ODBC Driver

Does Hive have an ODBC driver?

Yes.  Many third-party vendors provide ODBC drivers.

Simba provides both ODBC and JDBC drivers, and developed many of the drivers for other companies.

http://www.simba.com/drivers/hive-odbc-jdbc/

Microsoft provides an ODBC driver for Hive in HDInsight and local clusters.

https://azure.microsoft.com/en-us/documentation/articles/hdinsight-connect-excel-hive-odbc-driver/
https://www.microsoft.com/en-ca/download/details.aspx?id=40886 

Hortonworks provides an ODBC driver for HDP

http://hortonworks.com/hdp/addons/

Cloudera provides an ODBC driver for Cloudera Enterprise

http://www.cloudera.com/downloads/connectors/hive/odbc/2-5-12.html

MapR provides ODBC drivers

http://doc.mapr.com/display/MapR/Hive+ODBC+Connector

Progress offers a DataDirect ODBC driver

https://www.progress.com/odbc/apache-hadoop-hive

Amazon provides ODBC/JDBC drivers for Amazon EMR

https://docs.aws.amazon.com/ElasticMapReduce/latest/DeveloperGuide/emr-bi-tools.html