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
Post a Comment