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
Results
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