20xfzlOvosRH
生成数据 ./dbgen-vf-s100 处理数据，去除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'part.tbl sed-i's/|$//g'partsupp.tbl sed-i's/|$//g'nation.tbl sed-i's/|$//g'region.tbl 导入数据 loaddatainfile'/data/tpch/tpch100G/dbg...
mysql中的loaddata语句 建表语句如下： CREATETABLEinventory( inv_date_skbigint(11), inv_item_skbigint(11), inv_warehouse_skbigint(11), inv_quantity_on_handbigint(11) ); 通过loaddata的方式往数据库里面导入数据， 文件格式如下： 这时的loaddata语句可以这样写，如下： loaddatainfile'/root/inventory.dat'intotableinventoryfieldsterminatedby'|'; 如果文件的末...
dropallfromplancache; 编译缓存太小的时候，需要设置一下，然后删除掉原先的缓存 setpasswordfor'root'@'%'=password(''); 给数据库设置密码
安装opengauss 修改配置文件 vi/opt/huawei/install/data/dn/pg_hba.conf openGauss=showpassword_encryption_type; password_encryption_type -------------------------- 2 (1row) openGauss=altersystemsetpassword_encryption_type=1; ALTERSYSTEMSET openGauss= 重启数据库 [omm@node1]$gs_om-trestart Stoppingcluster. ...
kafka下载地址： http://archive.apache.org/dist/kafka/2.6.0/kafka_2.12-2.6.0.tgz 注：下载速度比较慢 zookeeper下载地址 https://archive.apache.org/dist/zookeeper/zookeeper-3.8.0/apache-zookeeper-3.8.0-bin.tar.gz 注：需要安装这个版本的zookeeper，一开始安装的是3.9.0，会出现报错 关闭防火墙 systemctlstopfirewalld.service 修改机器hostname hostnamectls...
1.建表语句 CREATETABLELINEITEM( L_ORDERKEYINTEGERNOTNULL, L_PARTKEYINTEGERNOTNULL, L_SUPPKEYINTEGERNOTNULL, L_LINENUMBERINTEGER, L_QUANTITYDECIMAL, L_EXTENDEDPRICEDECIMAL, L_DISCOUNTDECIMAL, L_TAXDECIMAL, L_RETURNFLAGCHAR(1), L_LINESTATUSCHAR(1), L_SHIPDATEDATE, L_COMMITDATEDATE, L_RECEIPTDATEDATE, L_S...
exportJAVA_HOME=/usr/local/java/jdk1.8.0_171 exportPATH=$JAVA_HOME/bin:$PATH exportCLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
安装环境 [root@cenots7]cat/etc/redhat-release CentOSLinuxrelease7.9.2009(Core) 准备工作 yum-yinstallepel-release yum-yinstallhttps://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm yumsearchpostgis-y 安装PostgreSQL10.22 yuminstall-ygccgcc-cunziplrzsz yuminsta...
txdb=showpassword_encryption_type;password_encryption_type-------------------------2(1row) txdb=altersystemsetpassword_encryption_type=1;ALTERSYSTEMSET 远程连接修改：[rapids@rapids01txdb]$viminstall/data/dn/pg_hba.confipv4增加host all all ...
vi/opt/pg14.5/data/pg_hba.conf hostallall0.0.0.0/0md5 编辑postgresql.conf，修改如下参数： listen_addresses='' createuserboraytestwithpassword'Boray@2022'; ALTERROLEboraytest CREATEROLESUPERUSER; 重启数据库
建表语句 -!/usr/bin/envbash -thissourcecodeformissubjecttothetermsofthemozillapublic -license,v.2.0.ifacopyofthemplwasnotdistributedwiththis -file,youcanobtainoneathttp://mozilla.org/mpl/2.0/. -copyright2017-2018monetdbsolutionsb.v. -sccsid:@()dss.ddl2.1.8.1 createtablenation(n_nationkeyintegernotnu...
代码如下，简单记录一下 packageorg.example; importjava.util.Properties; importorg.apache.kafka.clients.producer.KafkaProducer; importorg.apache.kafka.clients.producer.ProducerRecord; publicclasstest{ privatefinalKafkaProducer<String,String>producer; publicfinalstaticStringTOPIC="lijian12"; privatete...
!/bin/bash functiontimediff(){ timeformat:date+"%s.%N",suchas1502758855.907197692 start_time=$1 end_time=$2 start_s=${start_time%.} start_nanos=${start_time.} end_s=${end_time%.} end_nanos=${end_time.} end_nanos>start_nanos? Anotherway,thetimepartmaystartwith0,whichmeans itwillberegardedasoctf...
关闭防火墙 systemctlstopfirewalld.service 新建用户及组 groupaddgpadmin useraddgpadmin-r-m-ggpadmin chown-Rgpadmin:gpadmin/opt/greenplum-db 创建目录，并授权gpadmin mkdir-p/data/gpdata数据路径,自定义 mkdir/data/gpdata/master mkdir/data/gpdata/gp1 mkdir/data/gpdata/gp2 授权 chown-Rgpadmin:gpadmin/data/gpdata...
来自微软的官方教程 https://learn.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-ver15
[root@node218]hadoopfs-du-h/inventory5g 8.0G8.0G/inventory5g/inventory.dat 261.2M261.2M/inventory5g/inventory_1_30.dat 261.6M261.6M/inventory5g/inventory_2_30.dat 261.7M261.7M/inventory5g/inventory_3_30.dat 261.4M261.4M/inventory5g/inventory_4_30.dat 3.2G3.2G/inventory5g/store_returns.dat &...
配置java环境变量 wgethttps://repo.huaweicloud.com/java/jdk/8u202-b08/jdk-8u202-linux-x64.tar.gz mkdir-p/usr/local/java cd/usr/local/java tar-zxvfjdk-8u202-linux-x64.tar.gz vi/etc/profile 添加以下内容 exportJAVA_HOME=/usr/local/java/jdk1.8.0_202 exportPATH=$JAVA_HOME/bin:/usr/local/sbin:/usr/local/bin:...
查看是否有相应的包 yumsearchpython yuminstall-ypython36的命令安装 配置pip国内源 mkdir-p/.pip vi/.pip/pip.conf 添加以下内容 [global] index-url=https://pypi.tuna.tsinghua.edu.cn/simple [install] trusted-host=pypi.tuna.tsinghua.edu.cn 升级pip pip3install--upgradepip 安装 yuminstall-ygcc pipinsta...
建表语句 CREATETABLESPACEexample2relativelocation'tablespace2'; CREATETABLESPACEexample3relativelocation'tablespace3'; createtablebmsql_config( cfg_namevarchar(30), cfg_valuevarchar(50) ); createtablebmsql_warehouse( w_idintegernotnull, w_ytddecimal(12,2), w_taxdecimal(4,4), w_namevarchar(10),...