Hive configuration and internal functions
If (a=b) then c [when d then e]* [else f] end = c (a=b
Read More
Tag: hive
Hive window function/analysis function detailed analysis
December 14, 2023
by Janet Lord
No Comments
In SQL, there are a class of functions called aggregate functions, such as sum(), avg(), Max (), etc. These functions can regularly aggregate multiple rows...
Read More
6. Introduction of Hive Partition Table and Bucket Table
December 14, 2023
by Jessica Hoffman
No Comments
1. The partition table in Hive is a subdirectory, which divides a large data set into smaller data sets according to the business needs. For...
Read More
Hive tuning
December 14, 2023
by Dishani Gandhi
No Comments
Import HiveUDF functions: Most of them are, one in one out, UDAF many in one out, such as: aggregate function UDTF one in many out,...
Read More
Hive Core Principles (HIVE-3.1.2)
December 14, 2023
by 邵雅涵
No Comments
Hive is a Hadoop based data warehouse tool that can map structured data files into a table, and provide SQL-like query functions. Hive is a...
Read More
Hive + Tableau Calculates Retention Calculates Retention Numbers
December 14, 2023
by Miss Anne Moore
No Comments
Hive + Tableau Calculates Retention Rate Calculates Retention Number Background: We need to calculate the monthly retention data of the APP in the last 2...
Read More
Hive number warehouse zipper table principle
December 14, 2023
by Lagan Datta
No Comments
In the process of data model design of data warehouse, such requirements are often encountered :(1) the amount of data is relatively large. (2) Some...
Read More
Hive Enterprise Performance Optimization
December 14, 2023
by Michelle Love
No Comments
However, it is difficult to build a perfect database if we are limited to using Hive without considering performance issues, so Hive performance tuning is...
Read More
CloudQuery v1.4.0 released | a new starting point of the whole stack data control platform
December 14, 2023
by Joanne Jackson
No Comments
New features in V1.4.0 include the Scheduling Center module, DTS (Database Tools Service) data export, visual query builder, and Hive data sources.
Read More
Self-built Hive data warehouse migrated across versions to AliCloud Databricks data insights
December 14, 2023
by Wendy Thomas-Wade
No Comments
Brief introduction: The client built the data warehouse and analysis system in the Hadoop cluster of IDC or the public cloud environment, purchased the AliCloud...
Read More
Hive parameter configuration tuning
December 14, 2023
by Aarush Rao
No Comments
Hive achieves parallel processing by dividing a query into one or more MapReduce tasks. Each task may have multiple mapper and reducer tasks, at least...
Read More
Hive installation and deployment operations
December 14, 2023
by Alexis Lewis
No Comments
Hive is a Hadoop based data warehouse tool that maps structured data files into a database table and provides simple SQL queries that convert SQL...
Read More
SQOOP incremental import, data duplication problem
December 14, 2023
by Shelley Chapman-Williams
No Comments
Original link: [Link] Duplicates when importing data according to auto-increment ID, Incremental importsSQOOP provides an Incremental import mode which can be used to. Incremental importsSQOOP...
Read More
Complete all Hive SQL (20000 words)
December 14, 2023
by 黃思穎
No Comments
This article covers all of the SQL that Hive uses on a daily basis. Because there are too many SQL statements, it is classified as...
Read More
Hive+ SQOOP Shallow Learning Guide
December 14, 2023
by James Ball
No Comments
Business requirements: HDFS Hive Data Cleanup (ETL) is used to describe the process of extracting, transforming, and loading data from the source end to the...
Read More
| Apache Flink 1.13.0 is officially released, making streaming applications easier and more efficient!
December 14, 2023
by Jonathan Johnson
No Comments
Summary: Flink 1.13.0 makes the use of streaming applications as simple and natural as a normal application, and allows users to better understand the performance...
Read More
DataWorks Moving-Station Solution: Azkaban jobs migrated to DataWorks
December 14, 2023
by Jessica Daniels
No Comments
Description: DataWorks Migration Assistant provides the ability to quickly migrate tasks from open source scheduling engines Oozie, Azkaban, and Airflow to DataWorks. This article focuses...
Read More
DataWorks Moving-Station Solution: AirFlow operations are migrated to DataWorks
December 14, 2023
by Amanda Ochoa
No Comments
Summary: DataWorks provides the ability to quickly migrate tasks from open source scheduling engines Oozie, Azkaban, and Airflow to DataWorks. This article focuses on how...
Read More
Car Home: A Lake-Warehouse Architecture Practice based on Flink + Iceberg
December 14, 2023
by 周琬婷
No Comments
Introduction: Di Xingxing, the person in charge of Autohome real-time computing platform, shared on Meetup of Shanghai website on April 17, the integrated architecture practice...
Read More
SQOOP imports MySQL data into HBase, Hive Blood and Tears
December 14, 2023
by Nichole Pope MD
No Comments
Error during import: 1, Error during import: No primary key could be found for table * No primary key could be found for table *...
Read More
Interview Questions for Big Data Engineer (1)
December 14, 2023
by Kathy Owens
No Comments
Optimized compression of shuffle in Hive reduces the amount of data stored on disk and improves query speed by reducing I/O. Enable compression for a...
Read More
Hive statistics function a few tricks
December 13, 2023
by Matiu Bell-Gilbert
No Comments
In the end, with CUBE can be added to make statistics based on several combinations of dimensions of multidimensional, and all data of a certain...
Read More
The underlying principles of Hive: Explain the execution plan
December 13, 2023
by Thomas Schmidt
No Comments
If you don't know how to explain in Hive, it will be very convenient for you to use Hive in your work. This section introduces...
Read More
Hive Modeling Analysis
December 13, 2023
by Brooke Miller
No Comments
The modeling analysis is based on the case of the visitor system to discuss the modeling analysis. The purpose of the modeling analysis is to...
Read More