This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE hellomemsql; | |
USE hellomemsql; | |
CREATE TABLE test ( | |
message text NOT NULL | |
); | |
INSERT INTO test (message) VALUES ('this is a sample message'); | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Vagrant.configure("2") do |config| | |
config.vm.box = "generic/ubuntu1904" | |
# set the provider | |
config.vm.provider "virtualbox" | |
# configure the provider | |
config.vm.provider "virtualbox" do |v| | |
v.cpus = 4 | |
v.memory = 4096 | |
end |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
apiVersion: apps/v1 | |
kind: Deployment | |
metadata: | |
name: myapp | |
labels: | |
app: myapp | |
spec: | |
replicas: 3 | |
template: | |
metadata: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
apiVersion: apps/v1 | |
kind: Deployment | |
metadata: | |
name: memsql-operator-envvar | |
namespace: memsql | |
spec: | |
replicas: 1 | |
selector: | |
matchLabels: | |
name: memsql-operator-envvar |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- create a database | |
create database cosmeticshop; | |
-- create a table | |
use cosmeticshop; | |
create table cosmeticshopfunnel | |
( | |
event_time TIMESTAMP, | |
event_type CHAR(18), | |
product_id CHAR(10), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- create a database with 2 master partitions | |
create database thedb partitions 2; | |
-- create sample data | |
use thedb; | |
create table data (msg varchar(200)); | |
insert into data (msg) values ('the data'); | |
-- notice how we're not using the database efficiently | |
show partitions; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create database 'tpc_h'; | |
use 'tpc_h'; | |
CREATE TABLE IF NOT EXISTS `lineitem` ( | |
`l_orderkey` bigint(11) NOT NULL, | |
`l_partkey` int(11) NOT NULL, | |
`l_suppkey` int(11) NOT NULL, | |
`l_linenumber` int(11) NOT NULL, | |
`l_quantity` decimal(15,2) NOT NULL, | |
`l_extendedprice` decimal(15,2) NOT NULL, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create database acme; | |
use acme; | |
create table customer ( | |
id int, | |
name varchar(200), | |
properties json not null, | |
key (id) using clustered columnstore | |
); |