title: Oracle 12C DB Link to Hive
body: <p>I created a database link to Hive following the article
  <a href="https://community.oracle.com/docs/DOC-1002634" rel="nofollow noreferrer">How To Query Hive and Impala from Oracle using ODBC Heterogeneous Gateway</a>.</p>
  
  <pre><code>select count(*) from customers@HIVEDSN;
  </code></pre>
  
  <p>isql works fine, but in SQL*Plus I get an error:</p>
  
  <pre><code>ERROR at line 1:
  ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
  [
  </code></pre>
  
  <p>Here is the trace log:</p>
  
  <pre><code>--------------------------------------------
  Entered hgopoer at 2017/05/19-03:08:29
  hgopoer, line 240: got native error 10210 and sqlstate H; message follows...
  [
  Exiting hgopoer, rc=0 at 2017/05/19-03:08:29
  hgolgon, line 202: calling SQLSetConnectAttr got sqlstate H
  Exiting hgolgon, rc=28500 at 2017/05/19-03:08:29 with error ptr FILE:hgolgon.c LINE:202 ID:Connection Attribute: TRACE
  hostmstr:          0: HOA After hoalgon
  RPC Calling nscontrol(0), rc=0
  </code></pre>