Hive code analysis report: semantic analysis ④

2021SC@SDUSC catalogue Overview & & Review Code analysis: method of generating QB Summary: Overview & & Review As for the generation of QB by semantic parsing AST, we have always focused on code reading, and the content is scattered and split. Now, after reviewing the flow chart of HIVE compiler, we can see that semantic ...

Posted by julieb on Tue, 23 Nov 2021 17:55:20 +0100

Install Hive3.1.2 Tutorial under Ubuntu

Preface The installation of Hive needs to be built on top of Hadoop (similar to Hbase), and two other blogs by the author can be referenced for standalone and pseudo-distributed installations of Hadoop: Detailed tutorial on single installation of Hadoop under Ubuntu (with required installation package downloads)Detailed tutorial on pseu ...

Posted by shiggins on Mon, 22 Nov 2021 18:08:39 +0100

Configure Hadoop 2.7.1 + HBase 1.1.5 + mysql8.0.27 + hive1.2.1 + sqoop1.4.6 experimental environment in docker

preface Recently, a course experiment needs to be configured with the environment shown in the title, so the author takes this opportunity to use docker to build a returnable container experiment environment to complete the experiment, and also records some errors encountered in the construction process. 1, Environmental description ...

Posted by porco on Sun, 21 Nov 2021 00:36:54 +0100

JAVA foundation - API exception handling, take a good look and learn

JAVA----API 1, API 1. Basic use of scanner API Explanation: The full name is application programming interface(Application Programming Interface), Originally meant to mean JDK Various classes and interfaces provided For example: Scanner Get string public String nextLine(); Get the string entered by the user and get the whole line of data. ...

Posted by luminous on Fri, 19 Nov 2021 17:36:42 +0100

Hive code analysis report: semantic analysis ③

2021SC@SDUSC catalogue summary Semantic analyzer class analysis: ① From analyzeInternal(ASTNode ast) to genResolvedParseTree(ASTNode, planercontext) summary Earlier, I made a simple analysis of the basesemanticananalyzer class and learned that this class is the base class of each semantic analyzer, and its derived subclasses include sema ...

Posted by Ludo Lambrechts on Tue, 16 Nov 2021 10:57:20 +0100

Meaning of spark.sql.hive.caseSensitiveInferenceMode parameter of spark

This paper combs and summarizes the parameter meaning and use of spark.sql.hive.caseSensitiveInferenceMode of spark 1. Parameter meaning Spark 2.1.1 introduces a new configuration item: spark.sql.hive.caseSensitiveInferenceMode. The default value is NEVER_INFER, maintain behavior consistent with spark 2.1.0. However, Spark 2.2.0 changes the de ...

Posted by kate_rose on Fri, 12 Nov 2021 18:22:59 +0100

Hive based on big data -- hive actual combat (various problems of statistical film ranking)

Author: duktig Blog: https://duktig.cn (first article) Excellent still work hard. May you enjoy what you give and enjoy what you get. See github knowledge base for more articles: https://github.com/duktig666/knowledge background After learning Hadoop, do you feel that writing a MapReduce program is very complex, and it requires a lot ...

Posted by IceD on Tue, 02 Nov 2021 06:06:37 +0100

Hive of big data foundation -- DDL statement and DML statement

Author: duktig Blog: https://duktig.cn (first article) Excellent still work hard. May you enjoy what you give and enjoy what you get. See github knowledge base for more articles: https://github.com/duktig666/knowledge background After learning Hadoop, do you feel that writing a MapReduce program is very complex, and it requires a lot ...

Posted by KindMan on Tue, 02 Nov 2021 05:46:50 +0100

Basic operation of Hive

3, Query operation ▎ [3.1] which databases in hive are queried show databases; Before creating other databases, hive will provide a default database for us to use default   When operating HiveQL, all operations are performed in the default data without specifying the database. The database name and table name of hive are not case sensi ...

Posted by danwatt on Mon, 01 Nov 2021 00:56:00 +0100

Hive common functions

1. Writing order -select -from -join -on -where -group by -having -order by -limit 2. Execution sequence - from - where - join - on - select - group by - having - distinct - order by - limit - union / union on 3.Hive relational operator [common] !=Not equal to<> Not equal to==Wait for=be equal to+plus-reduce*ride/ex ...

Posted by sp2hari on Sun, 10 Oct 2021 15:07:31 +0200