Hive installation and Basic Usage (part 2)
Hive must be installed on a Hadoop cluster as a data warehouse in a Hadoop cluster. Therefore, you need to have a Hadoop cluster.
Read More
Tag: Apache Hive
Hive from Start to End
February 6, 2024
by Joseph Young
No Comments
Is there any other solution to writing HIVE SQL statements on the HIVE CLI? Of course there are, and this article recommends some useful tools...
Read More
Hive shell Operation and Parameter Configuration (15)
February 6, 2024
by Charles Cervantes
No Comments
Hive in practice, also involves a lot of Shell related commands, here is a sample of some common Linux commands, you can better let you...
Read More
Hive user – Defined Functions (UDF)
February 6, 2024
by Yasmin Tiwari
No Comments
Hive has powerful built-in functions to implement data processing and analysis. However, some built-in functions are difficult to process or even cannot be handled by...
Read More
Hive: The Art of HiveQL Database Level DDL Design
February 6, 2024
by 楊佳慧
No Comments
How to create a database in Hive? Hive database DDL design
Read More
Hive series (7) : Common DML operations are performed in Hive
February 6, 2024
by Michael Horn
No Comments
The loading target can be a table or partition. If it is a partitioned table, you must specify the partition to load the data. The...
Read More
Big Data development Join operation principle _ Big data training
February 4, 2024
by Faiyaz Dugar
No Comments
This section describes Hive join process, that is, Hive converts SQL join to MapReduce for execution. The key words are execution plan, Shuffle Join, and...
Read More
Hive set Hive. Lzo. Paralle. Read. Index. The thread = 1000;
February 4, 2024
by Nina Butcher
No Comments
set hive.lzo.paralle.read.index.thread = 1000; If the source table is LZO and there are many small files, add this to speed up the process. To view
Read More
HIve Installation pit guide
February 3, 2024
by Eshani Sule
No Comments
This is the seventh day of my participation in the First Challenge 2022. For details: First Challenge 2022. Hive is a data warehouse tool based...
Read More
Hive: Details about compression usage and performance analysis
February 1, 2024
by Michael Stevens
No Comments
HIVE uses HDFS and MapReduce to store and compute data. HIVE can use InputFormat and Outputformat of Hadoop to read files from different data sources...
Read More
Running beyond physical memory limits. Current Usage: 2.0 GB of 2 GB…
February 1, 2024
by Hrishita Choudhary
No Comments
Running beyond Physical memory limits. Cu: Running beyond physical Memory limits. Cu: Running beyond physical memory limits
Read More
Hive: Create table,create table AS, and create like
February 1, 2024
by Shayak Krishnan
No Comments
Hive HQL is based on SQL, and THERE are several ways to create tables in SQL. Hive also supports creation of these tables.
Read More
Hive Series 1 – Hive introduction and core concepts
February 1, 2024
by Hrishita Koshy
No Comments
Hive is a data warehouse built on Hadoop. It maps structured data files into tables and provides SQL-like query functions. SQL statements used for query...
Read More
Snappy, YOU drag your vest and I still know you
February 1, 2024
by Stephen Smith
No Comments
Hive compresses both intermediate and final data. Snappy is the most commonly used compression method for big data storage because it can be decompressed quickly...
Read More
Hive Learning Notes (Version 2.3.5)
January 31, 2024
by 陶承翰
No Comments
Not everyone who does data analysis is a programmer, and MapReduce costs to write. In other words, SQL is used to analyze data in HDFS....
Read More
Hive UDF, right there
January 31, 2024
by Megan Norton
No Comments
What is Hive UDF? What's the use? How does it work? How does that work? This article starts from the use of UDF, a brief...
Read More
Learn Hive views and indexes
January 31, 2024
by Megan Davis
No Comments
For example, HQL processing is very complex and slow. At this time, we can use Hive to add an index to improve our speed. I...
Read More
Hive SQL optimization
January 31, 2024
by Brett Murray
No Comments
Hive optimization includes configuration optimization, SQL statement optimization, and task optimization. One of the main development process involved may be the SQL optimization. The core...
Read More
Data interaction between Hive and ElasticSearch
January 31, 2024
by Danielle Bowman
No Comments
This article will detail the use of ES and Hive direct data interaction; Using Hive external tables, you can quickly map ES index data to...
Read More
Hive series (6) – Hive views and indexes
January 31, 2024
by 路宇軒
No Comments
A view in Hive is the same concept as a view in an RDBMS. It is a logical representation of a set of data, essentially...
Read More
HiveSQL check
January 31, 2024
by Ritvik Sule
No Comments
Druid connection pool configuration of Hive.
Read More
Hive: Data type details!
January 29, 2024
by Eric Kelly
No Comments
Understanding Hive data types is the foundation of Hive programming. When using Hive to build tables, you must first understand the common data types and...
Read More
Hive (5) –Hive operation statement (1)
January 29, 2024
by Nitya Raval
No Comments
This is the 25th day of my participation in the November Update Challenge. The event details view: 2021 Last Update Challenge "Database level Statement show...
Read More
HIVE permission control and super administrator implementation
January 29, 2024
by John Ford
No Comments
From the remote Hive deployment and mysql metadata table dictionary, it is clear that Hive manages user permissions through information stored in metadata. The focus...
Read More
[Continuously Updated] Solution of Hive exception
January 29, 2024
by Brett Flynn
No Comments
View hive logs. 2. Failed to load data. 3
Read More
How many of the seven tuning strategies are common to Hive development?
January 29, 2024
by Robert Martin
No Comments
1. Enable the local mode. 2. Enable the strict mode. 3. The Fetch grab; 4. Enable parallel execution. 5. Column and column filtering and code...
Read More
What is the difference between Order BY, sort by, distribute by, cluster BY in Apache Hive?
January 29, 2024
by Robert Farrell
No Comments
What is the difference between order BY, sort BY, distribute by, and cluster BY in Apache Hive
Read More
Hive performance optimization and parameter tuning
January 29, 2024
by Roy Hughes
No Comments
Record yourself in the work often used in a few parameter Settings, from the adjustment of the actual effect or the effect. When running in...
Read More
Hive embedded functions: Conditional judgment functions IF, COALESCE, and CASE WHEN
January 29, 2024
by James Tucker
No Comments
Hive all conditional judgment embedded functions 2. Common conditional judgment functions demo 3. Case A when B THEN C 4 5. Is NULL and is...
Read More
Hive four By differences
January 29, 2024
by Donna Morgan
No Comments
If the Distribute BY and Sort BY fields are the same, you can use the Cluster by mode. In addition to being Distribute by, Cluster...
Read More