mysql中的load data语句建表语句如下：CREATE TABLE inventory ( inv_date_sk bigint(11), inv_item_sk bigint(11), inv_warehouse_sk bigint(11), inv_quantity_on_hand bigint(11) );通过load data的方式往数据库里面导入数
生成数据./dbgen -vf -s 100处理数据，去除tbl表中⾏后⾯的分隔符“|”sed -i 's/|$//g' supplier.tbl sed -i 's/|$//g' customer.tbl sed -i 's/|$//g' orders.tbl sed -i 's/|$//g' lineitem.tbl sed -i 's/|$//g' supplier.tbl sed -i '
两个表rapids> select * from Employee; +-------+--------+------------+--------+ | empId | name | supervisor | salary | +-------+--------+------------+--------+ | 1 | John | 3 | 1000
drop all from plancache;
JMeter访问opengauss
openGauss数据库tpch测试
安装hadoop的教程 验证yarn集群和hadoop集群是否成功启动yarn集群：访问master节点IP:8088hadoop集群: 访问master节点IP:50070
来自微软的官方教程 https://learn.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-ver15
软件地址： https://github.com/greenplum-db/gpdb/releases/download/6.22.0/6.22.0-src-full.tar.gz 前提条件 yum update -y yum -y install epel-release yum –y insta
关闭防火墙 systemctl stop firewalld.service #新建用户及组 groupadd gpadmin useradd gpadmin -r -m -g gpadmin chown -R gpadmin:gpadmin /opt/greenplum-db #创建目录，并授权g
export JAVA_HOME=/usr/local/java/jdk1.8.0_171 export PATH=$JAVA_HOME/bin:$PATH export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
#!/bin/bash function timediff() { # time format:date +"%s.%N", such as 1502758855.907197692 start_time=$1 end_time=$2 start_s=${start_time%.*} start_n
#因为同一个文件夹，压缩成tar格式，压缩后的文档比较大zip -r tpcds1107.zip ./*
代码如下，简单记录一下 package org.example; import java.util.Properties; import org.apache.kafka.clients.producer.KafkaProducer; import org.apache.kafka.clients.
安装教程 # 获取MySQL8.0源 wget https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm # 安装源 rpm -ivh mysql80-community-release-el7-2.noarch.rpm
建表语句 -- !/usr/bin/env bash -- this source code form is subject to the terms of the mozilla public -- license, v. 2.0. if a copy of the mpl was not dis
未设置远程访问，会报如下的错 [root@cenots7 ~]# mysql -h192.168.30.20 -uroot -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'192.168.30.90' (us
SELECT TIME,STATE,INFO FROM `information_schema`.`PROCESSLIST` WHERE `info` IS NOT NULL and TIME > 0\G
简单记录一下安装过程 conf/zoo.cfg末尾添加如下内容 server.0=192.168.30.125:2888:3888 server.1=192.168.30.151:2888:3888 server.2=192.168.30.206:2888:3888 在zookeeper的data目
hostnamectl set-hostname xxx
-- 启动 nohup bin/ignite.sh config/default.xml & ./control.sh --user ignite --password ignite --state./control.sh --user ignite --password ignite --base
vi /opt/pg14.5/data/pg_hba.conf host all all 0.0.0.0/0 md5 编辑postgresql.conf，修改如下参数： listen_addresses = '*' create user boraytest with password 'Boray
CREATE TABLE PART ( P_PARTKEY SERIAL, P_NAME VARCHAR(55), P_MFGR CHAR(25), P_BRAND CHAR(10), P_TYPE VARCHAR(25), P_SIZE INTEGER, P_CONTAINER CHAR(10),
java https://repo.huaweicloud.com/java/jdk/ postgresql各版本下载-国内高速镜像 腾讯下载镜像地址：https://mirrors.cloud.tencent.c
机器： hostnamectl set-hostname node1 编译安装python3 前提条件 yum install -y libaio-devel gcc gcc-c++ zlib-devel expect bzip2 [root@node1 ~]# mkdir -p /opt/soft
建表语句 CREATE TABLESPACE example2 relative location 'tablespace2'; CREATE TABLESPACE example3 relative location 'tablespace3'; create table bmsql_config
txdb=# show password_encryption_type; password_encryption_type 2(1 row) txdb=# alter system set password_encryption_type=1;ALTER SYSTEM SET 远程连接修改：[ra
安装环境 [root@cenots7 ~]# cat /etc/redhat-release CentOS Linux release 7.9.2009 (Core) 准备工作 yum -y install epel-release yum -y install https://download.p
查看是否有相应的包 yum search python yum install -y python36 的命令安装 配置pip国内源 mkdir -p ~/.pip vi ~/.pip/pip.conf 添加以下内容 [global] index-url = https://pypi.tuna.ts
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号
