...
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.
...
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?
...
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