SQL-Server-R-Services-Samples/PredictiveMaintenance/SQLR/DataProcessing/create_table.sql at master · kashenfelter/SQL-Server-R-Services-Samples · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
DROP TABLE IF EXISTS PM_Train
GO

create table PM_Train
(
	id INT,
	cycle INT,
	setting1 float,
	setting2 float,
	setting3 float,
	s1 float,
	s2 float,
	s3 float,
	s4 float,
	s5 float,
	s6 float,
	s7 float,
	s8 float,
	s9 float,
	s10 float,
	s11 float,
	s12 float,
	s13 float,
	s14 float,
	s15 float,
	s16 float,
	s17 float,
	s18 float,
	s19 float,
	s20 float,
	s21 float
	)
CREATE CLUSTERED COLUMNSTORE INDEX [pm_train_cci] ON PM_Train WITH (DROP_EXISTING = OFF)

DROP TABLE IF EXISTS PM_Test
GO

create table PM_Test
(
	id INT,
	cycle INT,
	setting1 float,
	setting2 float,
	setting3 float,
	s1 float,
	s2 float,
	s3 float,
	s4 float,
	s5 float,
	s6 float,
	s7 float,
	s8 float,
	s9 float,
	s10 float,
	s11 float,
	s12 float,
	s13 float,
	s14 float,
	s15 float,
	s16 float,
	s17 float,
	s18 float,
	s19 float,
	s20 float,
	s21 float
	)
CREATE CLUSTERED COLUMNSTORE INDEX [pm_test_cci] ON PM_Test WITH (DROP_EXISTING = OFF)

DROP TABLE IF EXISTS PM_Truth
GO

create table PM_Truth
(
	RUL float,

	)
CREATE CLUSTERED COLUMNSTORE INDEX [pm_truth_cci] ON PM_Truth WITH (DROP_EXISTING = OFF)

DROP TABLE IF EXISTS PM_Models
GO

create table PM_Models
(
	model_name varchar(30) not null default('default model') primary key,
	model varbinary(max) not null
)