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&gt ...

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