Mac 구성 임팔라 ODBC

해당 Mac용 드라이버를 다운로드하여 설치하세요: http://www.cloudera.com/downloads.html.html

*HOST 주소는 임팔라 데몬이 설치된 머신의 IP 주소입니다. 위치이며 포트는 cm 설정
에 있을 수 있습니다. vi /usr/local/Cellar/unixodbc/2.3.2_1/etc/odbc.ini

<code><span>[ODBC Data Sources]</span><span>Sample_Cloudera_Impala_DSN_64=<span>Cloudera Impala ODBC Driver <span>64</span>-bit</span></span><span>[Sample_Cloudera_Impala_DSN_64]</span><span>Driver=<span>/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib</span></span><span>HOST=<span><span>192.168</span>.<span>2.103</span></span></span><span>PORT=<span><span>21050</span></span></span></code>

vi /usr/local/Cellar/unixodbc/2.3.2_1/etc/odbcinst.ini

<code>[<span>ODBC</span><span>Drivers</span>]
<span>Cloudera</span><span>Impala</span><span>ODBC</span><span>Driver</span><span>64</span>-bit=<span>Installed</span>[<span>Cloudera</span><span>Impala</span><span>ODBC</span><span>Driver</span><span>64</span>-bit]
<span>Description</span>=<span>Cloudera</span><span>Impala</span><span>ODBC</span><span>Driver</span> (<span>64</span>-bit)
<span>Driver</span>=<span>/opt/cloudera</span><span>/impalaodbc/lib</span><span>/universal/libclouderaimpalaodbc</span>.dylib</code>

테스트:
isql -v Sample_Cloudera_Impala_DSN_64

PHP 연결:

<code><span><span><?php</span><span>$connection</span>=odbc_connect(<span>'Sample_Cloudera_Impala_DSN_64'</span>,<span>''</span>,<span>''</span>);
<span>$SQL_Exec_String</span>=<span>"show tables"</span>;
<span>$result</span>=odbc_exec(<span>$connection</span>, <span>$SQL_Exec_String</span>);
<span>while</span>(odbc_fetch_row(<span>$result</span>))
{
<span>$Tables</span>=odbc_result(<span>$result</span>, <span>1</span>);
<span>echo</span><span>$Tables</span>.<span>'<br/>'</span>;
}
<span>?></span></span></code>

').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i ').text(i)); }; $numbering.fadeIn(1700); }); });

위 내용은 관련 내용을 포함하여 mac 구성 임팔라 odbc를 소개한 내용이 PHP 튜토리얼에 관심이 있는 친구들에게 도움이 되었으면 좋겠습니다.