Page Comparison

This guide describes how to integrate BAM Service Statistics Toolbox with Cassandra and Hive running in DataStax Enterprise Edition 3.0.0.

...

1. Drop h2-database-engine_1.2.140.wso2v3.jar and hive-jdbc-handler-0.8.1-wso2v8.jar (can be found inside <BAM_HOME>/repository/components/plugins/hive_0.8.1.wso2v8.jar) to <DSE_HOME>/resources/hive/lib folder where <DSE_HOME> is the DataStax installation directory.

2. Add the following property to <DSE_HOME>/resources/hive/conf/hive-site.xml file.
   

   Code Block
   language html/xml
   <property> <name>hive.aux.jars.path</name>   <value><DSE_HOME>/resources/hive/lib/hive-jdbc-handler-0.8.1-wso2v8.jar,<DSE_HOME>/resources/hive/lib/h2-database-engine_1.2.140.wso2v3.jar</value> </property>

   Note
   icon false
   Be sure to replace <DSE_HOME> in the above configuration with the actual file path of the installation directory. File path should start with file:///. For example, if <DSE_HOME> is /home/dse/dse-3.0 then the path is file:///home/dse/dse-3.0/resources/hive/lib/hive-jdbc-handler-0.8.1-wso2v8.jar.

3. Start the DSE Cassandra and Jobtracker using the following command: ./dse cassandra -j -t>.
You can view if the job tracker is started successfully using command:   ./dsetool jobtracker . It returns the hostname and port the JobTracker.
   View Cassandra ring status using command: ./nodetool ring -h [dse-node-ip]  
   Now start the Hive Thrift server using command: ./dse hive --service hiveserver -p 30000. It starts the Hive Thrift server on port 30000.
   

   Info
   icon false
   Hive server logs are available in <DSE_HOME>/logs/hive/hive directory.

   
   

...