[jira] [Commented] (HIVE-187) ODBC driver

["tian1982tian (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14599215#comment-14599215 ] 

tian1982tian commented on HIVE-187:
-----------------------------------

Hi Eric,
I have installed package what you Attachments,but i can't install suceessfully,would you provide some help for me? 
error info:
I. Building Thrift:
1. Get the latest revision of Thrift from http://incubator.apache.org/thrift/download/.
2. Make and install thrift after tar extraction with the following commands (courtesy of Raghu):
Configure and build thrift compiler and libraries
$ cd thrift-instant-r790732
$ ./configure --without-csharp --without-ruby --prefix=<thrift_install_path> && make -j4
Install thrift
$ make install
.......

make[3]: Leaving directory `/opt/hiveodbc/thrift-0.9.2/compiler/cpp'
make[2]: Leaving directory `/opt/hiveodbc/thrift-0.9.2/compiler/cpp'
Making all in lib
make[2]: Entering directory `/opt/hiveodbc/thrift-0.9.2/lib'
Making all in java
make[3]: Entering directory `/opt/hiveodbc/thrift-0.9.2/lib/java'
/opt/apache-ant-1.8.4/bin/ant
Buildfile: /opt/hiveodbc/thrift-0.9.2/lib/java/build.xml

setup.init:

mvn.ant.tasks.check:

proxy:

mvn.ant.tasks.download:
      [get] Getting: http://repo1.maven.org/maven2/org/apache/maven/maven-ant-tasks/2.1.3/maven-ant-tasks-2.1.3.jar
      [get] To: /opt/hiveodbc/thrift-0.9.2/lib/java/build/tools/maven-ant-tasks-2.1.3.jar
      [get] Error getting http://repo1.maven.org/maven2/org/apache/maven/maven-ant-tasks/2.1.3/maven-ant-tasks-2.1.3.jar to /opt/hiveodbc/thrift-0.9.2/lib/java/build/tools/maven-ant-tasks-2.1.3.jar

BUILD FAILED
/opt/hiveodbc/thrift-0.9.2/lib/java/build.xml:298: java.net.ConnectException: Connection timed out
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:579)
        at java.net.Socket.connect(Socket.java:528)
        at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
        at sun.net.www.http.HttpClient.<init>(HttpClient.java:211)
        at sun.net.www.http.HttpClient.New(HttpClient.java:308)
        at sun.net.www.http.HttpClient.New(HttpClient.java:326)
        at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:996)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:932)
        at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:850)
        at org.apache.tools.ant.taskdefs.Get$GetThread.openConnection(Get.java:660)
        at org.apache.tools.ant.taskdefs.Get$GetThread.get(Get.java:579)
        at org.apache.tools.ant.taskdefs.Get$GetThread.run(Get.java:569)

Total time: 21 seconds
make[3]: *** [all-local] Error 1
make[3]: Leaving directory `/opt/hiveodbc/thrift-0.9.2/lib/java'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/opt/hiveodbc/thrift-0.9.2/lib'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/opt/hiveodbc/thrift-0.9.2'
make: *** [all] Error 2
[root@thrift-0.9.2]#


thanks!

> ODBC driver
> -----------
>
>                 Key: HIVE-187
>                 URL: https://issues.apache.org/jira/browse/HIVE-187
>             Project: Hive
>          Issue Type: New Feature
>          Components: Clients, ODBC
>            Reporter: Raghotham Murthy
>            Assignee: Eric Hwang
>             Fix For: 0.4.0
>
>         Attachments: HIVE-187.1.patch, HIVE-187.2.patch, HIVE-187.3.patch, hive-187.4.patch, thrift_64.r790732.tgz, thrift_home_linux_32.tgz, thrift_home_linux_64.tgz, unixODBC-2.2.14-1.tgz, unixODBC-2.2.14-2.tgz, unixODBC-2.2.14-3.tgz, unixODBC-2.2.14-hive-patched.tar.gz, unixODBC-2.2.14.tgz, unixodbc.patch
>
>
> We need to provide the a small number of functions to get basic query
> execution and retrieval of results. This is based on the tutorial provided
> here: http://www.easysoft.com/developer/languages/c/odbc_tutorial.html
>  
> The minimum set of ODBC functions required are:
> SQLAllocHandle - for environment, connection, statement
> SQLSetEnvAttr
> SQLDriverConnect
> SQLExecDirect
> SQLNumResultCols
> SQLFetch
> SQLGetData
> SQLDisconnect
> SQLFreeHandle
>  
> If required the plan would be to do the following:
> 1. generate c++ client stubs for thrift server
> 2. implement the required functions in c++ by calling the c++ client
> 3. make the c++ functions in (2) extern C and then use those in the odbc
> SQL* functions
> 4. provide a .so (in linux) which can be used by the ODBC clients.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)