Programming VIP

After the data warehouse is built, users can write Hive SQL statements to access them and analyze the data. In actual production, which statistical indicators are needed are usually proposed by the relevant departments of data demand, and new statistical requirements will continue to emerge. The following are some typical indicators in website ...

Download & Unzip Download Hive 1.2.1 from this address https://mirrors.tuna.tsinghua.edu.cn/apache/hive/hive-1.2.1/apache-hive-1.2.1-bin.tar.gz Then use the following command to extract it to the specified directory: tar -zxvf apache-hive-1.2.1-bin.tar.gz -C /root/apps/ Then change the name with the following command: mv apache-hive- ...

Xiao Bai used a relational database such as Oracle before, and summarized the knack of relational database optimization - see the explanation plan. Oracle is a mature product. Interpretation plans include many categories, real and virtual. By observing different kinds of interpreted plan data, we can grasp the vast majority of sql data from inp ...

The previous article introduced the business background of the website click stream data analysis project; this blogger will continue to share the relevant knowledge of website analysis. I. Overall technical process and architecture 1.1. Data Processing Flow This project is a pure data analysis project, and its overall process is basically b ...

There are several types of source file storage formats for the hit table: 1,TEXTFILE The default format is not specified when creating tables. When importing data, the data files will be copied directly to hdfs for processing. Source files can be viewed directly through Hadoop fs-cat 2. SEQUENCEFILE is a binary ...