Skip to main content

Installation Hive on Hadoop


wget http://ftp.itu.edu.tr/Mirror/Apache/hive/hive-0.10.0/hive-0.10.0-bin.tar.gz

sudo cp hive-0.10.0-bin.tar.gz /usr/local/

cd /usr/local/

sudo tar -xzvf hive-0.10.0-bin.tar.gz

sudo mv hive-0.10.0-bin/ hive/

vim /home/hduser/.bashrc
export HIVE_HOME=/usr/local/hive
if [ -d "$JAVA_HOME/bin" ] ; then
   PATH=$PATH:$HIVE_HOME/bin
fi

mkdir /usr/local/warehouse
chown -R hduser:hadoop hive/
chown -R hduser:hadoop warehouse/

cd /usr/local/warehouse

hduser@myhost:/usr/local/warehouse$ hive

hive>
Ctrl+z

vim /home/hduser/hive_examples.csv
1 apache
2 httpd
3 warehouse
4 java


hadoop dfs -mkdir examples

hadoop dfs -ls .
Found 3 items
drwxr-xr-x   - hduser supergroup          0 2013-01-24 09:51 /user/hduser/books
drwxr-xr-x   - hduser supergroup          0 2013-01-24 12:50 /user/hduser/examples
drwxr-xr-x   - hduser supergroup          0 2013-01-24 10:48 /user/hduser/result

hadoop dfs -put /home/hduser/hive_examples.csv examples/hive_examples.csv

cd /usr/local/warehouse/
hive> CREATE EXTERNAL TABLE htest
          (ID INT, NAME STRING)
          ROW FORMAT DELIMITED FIELDS
          TERMINATED BY '\t'
          LINES TERMINATED BY '\n'
          STORED AS TEXTFILE
          LOCATION '/user/hduser/examples'; --must be a directory

hive>select * from htest;

Comments

Popular posts from this blog

Offline AI Coding in VSCode: Continue + Ollama Complete Setup Guide

Want GitHub Copilot-level code assistance — but fully offline, air-gapped, and private? This guide walks you through setting up Continue (a VSCode extension) with Ollama (a local model runner) so you get chat, autocomplete, and inline editing powered entirely by models running on your own machine. No internet required at runtime. Table of Contents What Are Continue and Ollama? Prerequisites & Hardware Requirements Choosing the Right Models Step 1 — Installing Ollama & Pulling Models Step 2 — Installing Continue in VSCode (Offline) Step 3 — Configuring config.yaml Step 4 — Disabling Telemetry Step 5 — Usage & Shortcuts Troubleshooting What Are Continue and Ollama? Continue is an open-source VSCode (and JetBrains) extension that adds AI-powered coding features directly into your editor — think chat, inline edits, and tab autocomplete. By default it can connect to Claude, GPT-4, or any API. But it also supports local providers , which is exactly what we want here. Ollama i...

Local LLM on Ubuntu (CPU-Only): Ollama + Qwen Coder + Open WebUI + RAG Setup

Local LLM on Ubuntu (CPU-Only): Ollama + Qwen Coder + Open WebUI + RAG Run a private, high-performance internal AI coding assistant on your own hardware—no GPU required. Feb 13, 2026 Qwen 2.5 Coder RAG Enabled Enterprise Ready Keeping your code and documents on your own infrastructure is the gold standard for enterprise security. By combining Ollama , Qwen Coder , and Open WebUI , we can build a production-grade AI assistant that respects your privacy. Environment: CPU-only Ubuntu server (e.g., i9/Threadripper) with 64GB+ RAM for smooth 14B model inference. 1. System Preparation First, update your local environment and install necessary dependencies: sudo apt update && sudo apt upgrade -y sudo apt install -y curl git ca-certificates lscpu 2. Ollama & Model Tuning Install Ollama and optimize the configuration for CPU-only inference by setting the thread count: ...

Defining tomcat and mysql server Amazon EC2 instance

-- Create new amazon ec2 instance http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EC2_GetStarted.html -- Give permisson to pem file chmod 400 mycertificate.pem -- Connect to EC2 instance ssh -i mycertificate.pem ubuntu@ec2-51-51-51-51.eu-west-1.compute.amazonaws.com -- Installation Oracle Java 1.8 $ wget --no-check-certificate --no-cookies --header "Cookie: oraclelicense=accept-securebackup-cookie" http://download.oracle.com/otn-pub/java/jdk/8u92-b14/jdk-8u92-linux-x64.tar.gz $ tar -xzvf jdk-8u92-linux-x64.tar.gz $ sudo mkdir -p /usr/java/ $ sudo mv jdk1.8.0_92/ /usr/java/ $ sudo vim  /etc/profile         JAVA_HOME=/usr/java/jdk1.8.0_92         PATH=$PATH:$HOME/bin:$JAVA_HOME/bin         JRE_HOME=/usr/java/jdk1.8.0_92/jre         PATH=$PATH:$HOME/bin:$JRE_HOME/bin         export JAVA_HOME...