usage of Hive Beeline
Reprint: http://www.teckstory.com/hadoop-ecosystem/hive-new-cli-beeline-for-hive/
Hive is the Data Warehouse software of Hadoop ecosystem. It provides a mechanism to project structure onto large data sets stored in Hadoop. Hive allows to query this data
apache-hive-2.1.0 Installation
Installing Hive
Install the Namenode on Hadoop and copy the installation files to Linux/usr/hadoop/apache-hive-2.1.0-bin.tar.gz
Extract:
TAR–ZXVF apache-hive-2.1.0-bin.tar.gz
Add to environment variable
Vi/etc/profile
Edit
#hive
Export Hive_h
Hive in layman 's1. What is Hive1) What is hive?Here is an introduction to the Hive wiki:Hive is a data warehouse infrastructure built on top of Hadoop. IT provides tools to enable easy data ETL, a mechanism to put structures on the data, and the capability to querying and a Nalysis of large data sets stored in Hadoop files.
first, control the number of maps in the Hive task:1. Typically, the job produces one or more map tasks through the directory of input.The main determinants are: The total number of input files, the file size of input, the size of the file block set by the cluster (currently 128M, can be set dfs.block.size in hive; command to see, this parameter can not be customized modification);2. For example:A) Assuming
1. Hive IntroductionHive is an open-source hadoop-based data warehouse tool used to store and process massive structured data. It stores massive data in the hadoop file system instead of the database, but provides a data storage and processing mechanism for database-like databases, and uses HQL (SQL-like) the language automatically manages and processes the data. We can regard the volume of structured data in hive
Tags: store rewritten cat POS Log monitor Web page infhttp://blog.csdn.net/wtq1993/article/details/52435563 http://blog.csdn.net/yeruby/article/details/51448188Hive on Spark vs. Sparksql vs Hive on TezThe previous article has been completed Sparksql,sparksql also has Thriftserver service, here say why also choose to engage in Hive-on-spark:
Sparksql-thriftserver all the results of all memory, fast
DML mainly operates on the data in the Hive table, but because of the characteristics of Hadoop, the performance of a single modification and deletion is very low, so it does not support the level operation;Mainly describes the most common methods of BULK INSERT data:1. Loading data from a fileSyntax: LOAD [LOCAL] ' filepath ' [OVERWRITE] into TABLE [PARTITION (Partcol1=val1, partcol2=val2 ...) ]Cases:Load ' /opt/data.txt ' into Table table1; --If t
Label:After the configuration of the Hive ODBC driver is successful, it becomes easier to access it through C #, which is divided into query and update operations, directly attached to the test code. The target platform for C # Engineering compilation needs to be noted in this process
Read-Write access code example: Public classhiveodbcclient {///
///
///
Public Statichiveodbcclient Current {Get{return Newhiveodbcclie
Compared with many tutorials, Hive has introduced concepts first. I like to install them first, and then use examples to introduce concepts. Install Hive first. Check whether the corresponding yum source has been installed. If the yum source blog. csdn. netnsrainbowarticledetails42429339hive is not installed according to the yum source file written in this tutorial
Compared with many tutorials,
Label: First, an overview of the task map: The process is to first delete the files on HDFs with Thdfsdelete, then import the data from the organization tables in Oracle into HDFS, establish hive connection-"Hive Build Table-" Tjava Get system Time-" Thiveload Import the files on HDFs into the hive table. The settings for each of these components are described b
I. Installation of Hive
The components are arranged as follows:
172.16.57.75 bd-ops-test-75 mysql-server
172.16.57.77 bd-ops-test-77 Hiveserver2
1. Install Hive
Install the Hive on 77:
# Yum Install hive Hive-metastore
1. Typically, the job produces one or more map tasks through the directory of input.The main determinants are: The total number of input files, the file size of input, the size of the file block set by the cluster (currently 128M, can be set dfs.block.size in hive; command to see, this parameter can not be customized modification);2. For example:A) Assuming that the input directory has 1 file A and a size of 780M, then Hadoop separates the file a into
Hive is a framework that occupies and plays an important role in the ecosystem architecture of Hadoop, and it is used in many practical businesses, so that the popularity of Hadoop is largely due to the presence of hive. So what exactly is hive and why it occupies such an important position in the Hadoop family, this article will focus on Hive's architecture (arc
Hive Installation Deployment(Installation will have version issue hadoop1.0 version above please install hive-0.90 testhadoop2.0 above Please install hive-0.12.0 or the latest version of the test)Hive-0.9.0:http://pan.baidu.com/s/1rj6f8hive-0.12.0:http://mirrors.hust.edu.cn/apache/
[A "," B "," C "]
3
[D "," E "," F "]
4
[D "," E "," F "]
Add a lateral view:
Select mycol1, mycol2 from basetable lateral view explode (col1) mytable1 as mycol1 lateral view explode (col2) mytable2 as mycol2;
The execution result is:
Int mycol1
String mycol2
1
""
1
"B"
1
"C"
2
""
2
"B"
2
"C"
3
"D"
Union syntax
Select_statement Union all select_statement...
Union is used to combine the result sets of multiple select statements into an independent result set. Currently, only union all (BAG Union) is supported ). Duplicate rows are not eliminated. The number and name of columns returned by each select statement must be the same. Otherwise, a syntax error is thrown.
If some extra processing is required for the Union result, the entire statement can be embedded in the from clause, as
Label: Start Thriftserver in spark after modification and then connect in beeline mode under Spark's Bin or write a. sh file every time you execute it directly . sh file contents such as:./beeline-u jdbc:hive2://yangsy132:10000/default-n root-p YangsiyiSpark on Hive configures Hive's metastore to MySQL
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.