Manually install hive 3 (taking hdp as an example, applicable to CentOS 8)
1 environment
Next, take the HDP Version (HDP-3.1.5.0-centos7-rpm.tar.gz) as an example to introduce the installation and configuration of hive 3 in detail. The environment can be CentOS 7 or CentOS 8 (although the tar package is CentOS 7, the build RPM used in this paper is still applicable to CentOS 8).
Before installation, manually ...
Posted by taddis on Thu, 07 Oct 2021 02:42:52 +0200
Hive3.X high availability deployment
1, Deployment planning
hadoop high availability cluster deployment reference: Hadoop 3. X distributed high availability cluster deployment
1.1 version description
Softwareeditionoperating systemCentOS Linux release 7.8.2003 (Core)JAVAjdk-8u271-linux-x64Hadoophadoop-3.2.2Hivehive-3.1.2
1.2 cluster planning
hive remote mode & & hivese ...
Posted by ernielou on Mon, 04 Oct 2021 19:56:52 +0200
spark related introduction - extract hive table
Environmental description of this document
centos The server
jupyter of scala nucleus spylon-kernel
spark-2.4.0
scala-2.11.12
hadoop-2.6.0
Main contents of this paper
spark reads the data of hive table, mainly including direct sql reading of hive table; Read hive table and hive partition table through hdfs file.Initialize the sparksession t ...
Posted by flash99 on Mon, 20 Sep 2021 18:18:29 +0200
Day44-45_Hive advanced
4, HQL (hive SQL)
https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/#
1) Add the following configuration information to the hive-site.xml file to display the header information of the current database and query table.
<property>
<name>hive.cli.print.header</name>
<value>true</value>
</property> ...
Posted by ibo on Fri, 17 Sep 2021 06:20:51 +0200
[source code analysis] Oozie history submission task
0x00 summary
Oozie is an open source framework based on workflow engine contributed by Cloudera company to Apache. It is an open source workflow scheduling engine of Hadoop platform, which is used to manage Hadoop jobs. This article, the first in a series, introduces oozie's task submission phase.
0x01 problem
We deduce the implementation f ...
Posted by cowboy_x on Tue, 30 Jun 2020 05:26:29 +0200
Hadoop 8-day course - day 6, MapReduce details
hive
About hive
A tool for translating sql statements into mapreduce programs.
Create table statement
CREATE TABLE page_view(viewTime INT, userid BIGINT,
page_url STRING, referrer_url STRING,
ip STRING COMMENT 'IP Address of the User')
COMMENT 'This is the page view table'
PARTITIONED BY(dt STRING, country STRING)
ROW FORMAT DELIMI ...
Posted by mainewoods on Wed, 29 Apr 2020 14:54:07 +0200
apache Impala detailed installation
Reference article: apache Impala detailed installation (lying in the most complete pit)
Apache impala detailed installation
impala is an efficient sql query tool provided by cloudera, which provides real-time query results. The official test performance is 10 to 100 times faster than hive, and its sql query is even faster than spark sql. imp ...
Posted by deth4uall on Tue, 21 Apr 2020 09:18:04 +0200
check the logs or run fsck in order to identify the missing blocks
hadoop version is 2.8.3
Today, I found a strange problem, as shown in List-1 below, indicating that two file blocks are missing
List-1
There are 2 missing blocks. The following files may be corrupted:
blk_1073857294 /tmp/xxx/b9a11fe8-306a-42cc-b49f-2a7f098ecb5a/hive-exec-2.1.1.jar
blk_1073857295 /tmp/xxx/b9a11fe8-306a-42cc-b49f-2a7f0 ...
Posted by tomfmason on Wed, 25 Mar 2020 15:31:06 +0100
Problems encountered in building large data infrastructure components (integration)
Article Directory
Hadoop
1. because hostname cannot be resolved
1.1 Cause
1.2 Solution
1.3 Reference
Hive
1. Cannot find hadoop installation: $HADOOP_HOME or $HADOOP_PREFIX must be set or hadoop must be in the path
1.1 Solution
2. Unable to instantiate org.a ...
Posted by a6000000 on Tue, 17 Mar 2020 02:31:41 +0100
Getting exception 'IllegalStateException: cannot perform this operation after onSaveInstanceState'
I have a Live Android application. I have received the following stack trace information from the market. I don't know why it happened in the application code instead of happening, but caused by some or other events in the application (assumed)
I don't use Fragments, but I still have a reference to the fragment manager. If someone can under ...
Posted by weemee500 on Sun, 01 Mar 2020 05:05:55 +0100