clickhouse export or import data

-

Export data from clickhouse into csv file:

:) SELECT * FROM table INTO OUTFILE 'file'

Import data from csv file:

clickhouse-client -q "INSERT INTO database.tablename FORMAT CSV" < tablename.csv

Comments

Post a Comment

Popular posts from this blog

BdsDex: failed to load Boot0001 "UEFI BHYVE SATA DISK BHYVE-OABE-20A5-E582" from PciRoot(0x0)/Pci (0x2, 0x0)/Stat(0x0,0xFFFF,0x0) : Not Found

-
Image
When you start Debian Linux after you installed Debian with UEFI bhyve on FreeBSD and rebooted FreeBSD, you will get the error message as follows: BdsDex: failed to load Boot0001 "UEFI BHYVE SATA DISK BHYVE-OABE-20A5-E582" from PciRoot(0x0)/Pci (0x2, 0x0)/Stat(0x0,0xFFFF,0x0) : Not Found   Description It will try other way to start system, but it will failed finally. At the last, it will come to UEFI  Shell . How to access the Debian Guest VM? 1. Enter exit get out of the UEFI Shell (you will come to BHYVE panel) 2. Choose Boot Maintenance Manager 3. (In the Boot Maintenace Manager ) Choose Boot From File 4. (In File Explorer) NO VOLUME LABEL, [PciRoot(0x0)/ Pci()]  press Enter 5. (Still in the File Explorer) Choose <EFI> 6. (Still in the File Explorer) Choose debian   7. (Still in the File Explorer) Choose grubx64.efi 8. Then you will get into the system How can you fix it: 1) Get access inside your Debian Guest VM. 2) as root: cd /boot/efi/ 3) mkdir -p EFI/BOOT
Read more

How to Dockerizing LEMP Stack with Docker-Compose

-
Image
LEMP: Linux, Nginx, PHP, MySQL Nginx Create docker-compose.yml in a directory(lemp) is as follows: version: '3.8' services:   nginx:     image: nginx:1.20.2     ports:       - 80:80 Let's test this out .   $ docker-compose up -d  The -d option indicates that run the containers in the background. It might take a little while as the Nginx image will first be downloaded from Docker Hub. When it is done, open localhost in your browser, which should display Nginx's welcome page: Welcome to nginx! If you see this page, the nginx web server is successfully installed and working. Further configuration is required. For online documentation and support please refer to nginx.org . Commercial support is available at nginx.com . Thank you for using nginx. To stop the container, simply run: $ docker-compose stop  PHP Replace the content of docker-compose.yml with this one: version: '3.8' services:   nginx:     image: nginx:1.20.2     ports:       - 80:80     volumes:
Read more

How To Install Nginx, MySQL and PHP (FEMP) Stack on FreeBSD 13.0

-
Image
1. First, update your FreeBSD system. # freebsd-update fetch # freebsd-update install   2. Install Nginx. # pkg install nginx Enable Nginx: # sysrc nginx_enable=yes   Start Nginx: # service nginx start Check if nginx is running normally? It worked. 3. Install MySQL # pkg install mysql80-client mysql80-server   Enable MySQL: # sysrc mysql_enable=yes   Start MySQL: # service mysql-server start  Starting mysql.   4. Install PHP The following command to install php8.0 and commonly used modules: # pkg install php74 php74-mysqli php74-mbstring php74-zlib php74-curl php74-gd php74-json 5. Configure Nginx and PHP to make them work together   Edit Nginx's config file  /usr/local/etc/nginx/nginx.conf  uncomment or modify or add config as follows: user  www; error_log  /var/log/nginx/error.log;   http block: access_log  /var/log/nginx/access.log;  location ~ \.php$ {     root           /usr/local/www/nginx;     fastcgi_pass   127.0.0.1:9000;     fastcgi_index  index.php;     fastcgi_param  S
Read more