Home Forums Hive / HCatalog Protocole to connect to Hive/HCatalog

This topic contains 1 reply, has 2 voices, and was last updated by  Thejas Nair 6 months, 4 weeks ago.

  • Creator
    Topic
  • #50636

    Gwenael Le Barzic
    Participant

    Hello there.

    I create this topic because I would like to know which protocole is used in the ODBC driver for Hive ? Is it just HTTP or is it something else ?

    http://s3.amazonaws.com/public-repo-1.hortonworks.com/index.html#/HDP/hive-odbc

    I read somewhere that it is possible to execute HQL with the following ways :
    – Directly in command lines in the Hadoop cluster (on each node with at least the client Hive installed ?)
    – by using JDBC (Java Database Connectivity)
    – by using ODBC (Open Database Connectivity)
    – by using the client Hive Thrift Client

    Which protocole use each of this way ?

    I hope my questions makes sense.

    Best regards.

    Gwenael Le Barzic

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #50731

    Thejas Nair
    Participant

    In case of JDBC/ODBC, it talks to hive server2 (or hive server1 in older versions) using thrift binary api (thrift protocol over tcp). There is an option to use thrift over http , and its support has been greatly improved in upcoming hive 0.13 release. I believe the http mode is supported since hive 0.12.

    In case of hive commandline, there is no rpc to the hive server2. It runs the hive parser/optimizer/scheduler etc within the same have commandline jvm.
    Hope this answers your question.

    Collapse
Viewing 1 replies (of 1 total)