How to query a multiple delimited table in Hive

This article explains how to query a multi delimited Hive table in CDH5.3.x. Use case as follow: Having the following table definitions: CREATE TABLE test_multi (a string, b string) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH SERDEPROPERTIES ( "field.delim"="#|", "collection.delim"=":", "mapkey.delim"="@" ); Query all columns is OK: select * from test_multi; +—————+—————+ …

Kerberos connections to HIveServer2 not working cross domain

The following is the scenario of the cross domain problem with Kerberized cluster: 1. Cluster is within realm “DEV.EXAMPLE.COM” 2. Client is outside cluster with realm “EXAMPLE.COM” 3. Connect to Impala from client machine works 4. Connect to HS2 from client machine does not work and get the following error: …