linux -- operation text
Article directory
Special characters in shell
regular expression
Basic regular
POSIX character class
Meta character
Procedures for manipulating text
grep: row searcher
cut: operate by column
Sort: sort
uniq: de duplication
wc: count
tee: bidirectional reorientation
tr: delete or replace text
join ...
Posted on Fri, 06 Mar 2020 01:42:15 -0500 by daboymac
GreenPlum installation details (CENTOS 6.x)
GreenPlum cluster setup and installation steps
Additional reference:
https://gp-docs-cn.github.io/docs/best_practices/sysconfig.html,
https://blog.csdn.net/king13127/article/details/83989704
1, Installation instructions
1.1 environmental description
Operating system: CentOS 6.x 64bit
Greenplum:Greenplum ...
Posted on Fri, 28 Feb 2020 01:53:24 -0500 by imi_99
Greenplus-cc-web4.0 monitoring installation
Original reprint address: https://www.cnblogs.com/zhang-ke/p/9009531.html
Introduction:
This article is based on greenplus 5.7, greenplus-cc-web4.0 installation.
1, Install the database monitored by greenplus and create users (install under gpadmin user)
1. Open the greenplus database
[gpadmin@master ~]$ gpstart -a
2. Ins ...
Posted on Sun, 05 Jan 2020 14:59:23 -0500 by rodolp13
The first article of the year begins with [Greenplum 6.0] 1 minute installation
Greenplum has iterated several small versions at present in version 6. With the update of the version, bug s are constantly fixed.
Friends who are going to try it can start. As the first post of the first working day of the new year, it must start from the "groundbreaking" 6.0. The following content is relatively simple, suitable for ...
Posted on Fri, 03 Jan 2020 11:01:52 -0500 by freddyatlantis
Greenplum large width table OR hierarchical relationship - a large number of nestloop to compensate for performance loss of other fields
Label
PostgreSQL, Greenplum, wide table, relationship, loop, performance
background
In GPDB, do you use relational storage or large wide tables?
Relational storage, when querying the contents of other tables, needs JOIN completion. JOIN may need to redistribute data. Dimension tables can solve the problem of redistributing a large number of ...
Posted on Thu, 21 Nov 2019 13:10:03 -0500 by catnip_uk
GreenPlum's events II: GreenPlum starts reporting errors
Labels (space delimited): GreenPlum
In the process of configuring GreenPlum, you need to pay attention to the following points:
Find the installation package
Installation dependency, Gun version needs attention
Detailed installation procedure reference Greenplum installation introduction
I am a computer virtual machine insta ...
Posted on Sun, 10 Nov 2019 14:42:13 -0500 by antisback
Backup and Recovery of Greenplum
11. Backup and Recovery
This chapter describes backup and recovery of database and user data in GPDB system.
GP recommends backing up the database regularly. Backup can be used to restore and rebuild the GPDB system in case of system failure or data corruption. In addition, you can use backup to migrate GPDB data from one system to another.
Pa ...
Posted on Sat, 22 Jun 2019 14:37:45 -0400 by lrsdsout
Deepgreen & Greenplum DBA White Popularization Course (General Question Answer)
If you want to be a qualified database administrator, you should first have solid basic knowledge and problem-solving ability. Referring to Pivotal's official FAQ, this article answers some common questions that are often encountered in the use and management of Deepgreen & Greenplum. I hope it will be helpful to you. If you have more quest ...
Posted on Mon, 17 Jun 2019 21:02:58 -0400 by girlzz
Using SQL to Play Data Mining MADlib (1) - Installation
Introduction to MADlibMADlib is an open source machine learning library cooperated by Pivotal and the University of Berkeley. It provides precise data parallel implementation, statistics and machine learning methods to analyze structured and unstructured data. The main purpose is to expand the analytical capability of the database, which can be ...
Posted on Mon, 17 Jun 2019 20:57:48 -0400 by djg_uk
Deepgreen & Greenplum DBA Small White Popularization Lesson Two (Management Question Answer)
If you want to be a qualified database administrator, you must first have solid basic knowledge and problem handling ability.Referring to Pivotal's official FAQ, this paper provides ideas/answers to common problems encountered in the management of Deepgreen & Greenplum.I hope it will help you. If you have more questions to share with your ...
Posted on Mon, 17 Jun 2019 13:21:50 -0400 by nickman013