Using the DataStax ODBC driver for Hive

After configuring the ODBC data source for Hive, connect and pull data from Hive using any compliant BI tool.

After configuring the ODBC data source for Hive, you can connect and pull data from Hive using any compliant BI tool. For example, to retrieve data using Microsoft Excel:

Procedure

  1. Use the data connection wizard to select your new ODBC data source:


  2. In Connect to OBDC Data Source, select DSE2 Hive > Next.
  3. Select one or more data objects (or construct a query) to retrieve the data, and then click Finish.


Results

After the ODBC query is executed and the data is retrieved, a Hive MapReduce job runs on the server:
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201208230939_0006,
   Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201208230939_0006
Kill Command = ./dse hadoop job
   -Dmapred.job.tracker=127.0.0.1:8012 -kill job_201208230939_0006
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0
2012-08-23 12:44:39,795 Stage-1 map = 0%,  reduce = 0%
2012-08-23 12:44:42,824 Stage-1 map = 100%,  reduce = 0%
2012-08-23 12:44:44,833 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201208230939_0006
MapReduce Jobs Launched:
Job 0: Map: 1   HDFS Read: 0 HDFS Write: 0 SUCCESS
Total MapReduce CPU Time Spent: 0 msec