-
Notifications
You must be signed in to change notification settings - Fork 0
/
log
127 lines (120 loc) · 12.9 KB
/
log
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
hdfs://localhost:54310/data-re//file0.csv,hdfs://localhost:54310/data-re//file1.csv,hdfs://localhost:54310/data-re//file2.csv,hdfs://localhost:54310/data-re//file3.csv,hdfs://localhost:54310/data-re//file4.csv,hdfs://localhost:54310/data-re//file5.csv,hdfs://localhost:54310/data-re//file6.csv,hdfs://localhost:54310/data-re//file7.csv,hdfs://localhost:54310/data-re//file8.csv,hdfs://localhost:54310/data-re//file9.csv,hdfs://localhost:54310/data-re//file10.csv,hdfs://localhost:54310/data-re//file11.csv,hdfs://localhost:54310/data-re//file12.csv,hdfs://localhost:54310/data-re//file13.csv,hdfs://localhost:54310/data-re//file14.csv,hdfs://localhost:54310/data-re//file15.csv,hdfs://localhost:54310/data-re//file16.csv,hdfs://localhost:54310/data-re//file17.csv,hdfs://localhost:54310/data-re//file18.csv,hdfs://localhost:54310/data-re//file19.csv,hdfs://localhost:54310/data-re//file20.csv,hdfs://localhost:54310/data-re//file21.csv,hdfs://localhost:54310/data-re//file22.csv,hdfs://localhost:54310/data-re//file23.csv,hdfs://localhost:54310/data-re//file24.csv,hdfs://localhost:54310/data-re//file25.csv,hdfs://localhost:54310/data-re//file26.csv,hdfs://localhost:54310/data-re//file27.csv,hdfs://localhost:54310/data-re//file28.csv,hdfs://localhost:54310/data-re//file29.csv,hdfs://localhost:54310/data-re//file30.csv,hdfs://localhost:54310/data-re//file31.csv,hdfs://localhost:54310/data-re//file32.csv,hdfs://localhost:54310/data-re//file33.csv,hdfs://localhost:54310/data-re//file34.csv,hdfs://localhost:54310/data-re//file35.csv,hdfs://localhost:54310/data-re//file36.csv,hdfs://localhost:54310/data-re//file37.csv,hdfs://localhost:54310/data-re//file38.csv,hdfs://localhost:54310/data-re//file39.csv,hdfs://localhost:54310/data-re//file40.csv,hdfs://localhost:54310/data-re//file41.csv,hdfs://localhost:54310/data-re//file42.csv,hdfs://localhost:54310/data-re//file43.csv,hdfs://localhost:54310/data-re//file44.csv,hdfs://localhost:54310/data-re//file45.csv,hdfs://localhost:54310/data-re//file46.csv,hdfs://localhost:54310/data-re//file47.csv,hdfs://localhost:54310/data-re//file48.csv,hdfs://localhost:54310/data-re//file49.csv,hdfs://localhost:54310/data-re//file50.csv
hdfs://localhost:54310/data-re//file0.csv
hdfs://localhost:54310/data-re//file1.csv
hdfs://localhost:54310/data-re//file2.csv
hdfs://localhost:54310/data-re//file3.csv
hdfs://localhost:54310/data-re//file4.csv
hdfs://localhost:54310/data-re//file5.csv
hdfs://localhost:54310/data-re//file6.csv
hdfs://localhost:54310/data-re//file7.csv
hdfs://localhost:54310/data-re//file8.csv
hdfs://localhost:54310/data-re//file9.csv
hdfs://localhost:54310/data-re//file10.csv
hdfs://localhost:54310/data-re//file11.csv
hdfs://localhost:54310/data-re//file12.csv
hdfs://localhost:54310/data-re//file13.csv
hdfs://localhost:54310/data-re//file14.csv
hdfs://localhost:54310/data-re//file15.csv
hdfs://localhost:54310/data-re//file16.csv
hdfs://localhost:54310/data-re//file17.csv
hdfs://localhost:54310/data-re//file18.csv
hdfs://localhost:54310/data-re//file19.csv
hdfs://localhost:54310/data-re//file20.csv
hdfs://localhost:54310/data-re//file21.csv
hdfs://localhost:54310/data-re//file22.csv
hdfs://localhost:54310/data-re//file23.csv
hdfs://localhost:54310/data-re//file24.csv
hdfs://localhost:54310/data-re//file25.csv
hdfs://localhost:54310/data-re//file26.csv
hdfs://localhost:54310/data-re//file27.csv
hdfs://localhost:54310/data-re//file28.csv
hdfs://localhost:54310/data-re//file29.csv
hdfs://localhost:54310/data-re//file30.csv
hdfs://localhost:54310/data-re//file31.csv
hdfs://localhost:54310/data-re//file32.csv
hdfs://localhost:54310/data-re//file33.csv
hdfs://localhost:54310/data-re//file34.csv
hdfs://localhost:54310/data-re//file35.csv
hdfs://localhost:54310/data-re//file36.csv
hdfs://localhost:54310/data-re//file37.csv
hdfs://localhost:54310/data-re//file38.csv
hdfs://localhost:54310/data-re//file39.csv
hdfs://localhost:54310/data-re//file40.csv
hdfs://localhost:54310/data-re//file41.csv
hdfs://localhost:54310/data-re//file42.csv
hdfs://localhost:54310/data-re//file43.csv
hdfs://localhost:54310/data-re//file44.csv
hdfs://localhost:54310/data-re//file45.csv
hdfs://localhost:54310/data-re//file46.csv
hdfs://localhost:54310/data-re//file47.csv
hdfs://localhost:54310/data-re//file48.csv
hdfs://localhost:54310/data-re//file49.csv
hdfs://localhost:54310/data-re//file50.csv
1661526
['query1;file0.csv;32575;43799;1661526', 'query1;file1.csv;32656;43800;1661526', 'query1;file2.csv;32574;43800;1661526', 'query1;file3.csv;32611;43800;1661526', 'query1;file4.csv;32637;43800;1661526', 'query1;file5.csv;32599;43800;1661526', 'query1;file6.csv;32518;43800;1661526', 'query1;file7.csv;32590;43800;1661526', 'query1;file8.csv;32636;43800;1661526', 'query1;file9.csv;32741;43800;1661526', 'query1;file10.csv;32552;43800;1661526', 'query1;file11.csv;32561;43800;1661526', 'query1;file12.csv;32383;43800;1661526', 'query1;file13.csv;32610;43800;1661526', 'query1;file14.csv;32726;43800;1661526', 'query1;file15.csv;32547;43800;1661526', 'query1;file16.csv;32595;43800;1661526', 'query1;file17.csv;32497;43800;1661526', 'query1;file18.csv;32545;43800;1661526', 'query1;file19.csv;32586;43800;1661526', 'query1;file20.csv;32429;43800;1661526', 'query1;file21.csv;32670;43800;1661526', 'query1;file22.csv;32604;43800;1661526', 'query1;file23.csv;32819;43800;1661526', 'query1;file24.csv;32616;43800;1661526', 'query1;file25.csv;32423;43800;1661526', 'query1;file26.csv;32641;43800;1661526', 'query1;file27.csv;32418;43800;1661526', 'query1;file28.csv;32593;43800;1661526', 'query1;file29.csv;32468;43800;1661526', 'query1;file30.csv;32580;43800;1661526', 'query1;file31.csv;32463;43800;1661526', 'query1;file32.csv;32490;43800;1661526', 'query1;file33.csv;32559;43800;1661526', 'query1;file34.csv;32628;43800;1661526', 'query1;file35.csv;32645;43800;1661526', 'query1;file36.csv;32545;43800;1661526', 'query1;file37.csv;32571;43800;1661526', 'query1;file38.csv;32646;43800;1661526', 'query1;file39.csv;32592;43800;1661526', 'query1;file40.csv;32505;43800;1661526', 'query1;file41.csv;32383;43800;1661526', 'query1;file42.csv;32685;43800;1661526', 'query1;file43.csv;32619;43800;1661526', 'query1;file44.csv;32588;43800;1661526', 'query1;file45.csv;32578;43800;1661526', 'query1;file46.csv;32575;43800;1661526', 'query1;file47.csv;32608;43800;1661526', 'query1;file48.csv;32586;43800;1661526', 'query1;file49.csv;32681;43800;1661526', 'query1;file50.csv;32579;43800;1661526']
dgdfgdfdfdf
SELECT SUM(measurement) FROM indexes WHERE measurement > 0.1 AND measurement < 0.4
1488
+-----------------+
| sum(measurement)|
+-----------------+
|481974.3183853589|
+-----------------+
Executed Query 1
measurement and $gt and 0.5
hdfs://localhost:54310/data-re//file0.csv,hdfs://localhost:54310/data-re//file1.csv,hdfs://localhost:54310/data-re//file2.csv,hdfs://localhost:54310/data-re//file3.csv,hdfs://localhost:54310/data-re//file4.csv,hdfs://localhost:54310/data-re//file5.csv,hdfs://localhost:54310/data-re//file6.csv,hdfs://localhost:54310/data-re//file7.csv,hdfs://localhost:54310/data-re//file8.csv,hdfs://localhost:54310/data-re//file9.csv,hdfs://localhost:54310/data-re//file10.csv,hdfs://localhost:54310/data-re//file11.csv,hdfs://localhost:54310/data-re//file12.csv,hdfs://localhost:54310/data-re//file13.csv,hdfs://localhost:54310/data-re//file14.csv,hdfs://localhost:54310/data-re//file15.csv,hdfs://localhost:54310/data-re//file16.csv,hdfs://localhost:54310/data-re//file17.csv,hdfs://localhost:54310/data-re//file18.csv,hdfs://localhost:54310/data-re//file19.csv,hdfs://localhost:54310/data-re//file20.csv,hdfs://localhost:54310/data-re//file21.csv,hdfs://localhost:54310/data-re//file22.csv,hdfs://localhost:54310/data-re//file23.csv,hdfs://localhost:54310/data-re//file24.csv,hdfs://localhost:54310/data-re//file25.csv,hdfs://localhost:54310/data-re//file26.csv,hdfs://localhost:54310/data-re//file27.csv,hdfs://localhost:54310/data-re//file28.csv,hdfs://localhost:54310/data-re//file29.csv,hdfs://localhost:54310/data-re//file30.csv,hdfs://localhost:54310/data-re//file31.csv,hdfs://localhost:54310/data-re//file32.csv,hdfs://localhost:54310/data-re//file33.csv,hdfs://localhost:54310/data-re//file34.csv,hdfs://localhost:54310/data-re//file35.csv,hdfs://localhost:54310/data-re//file36.csv,hdfs://localhost:54310/data-re//file37.csv,hdfs://localhost:54310/data-re//file38.csv,hdfs://localhost:54310/data-re//file39.csv,hdfs://localhost:54310/data-re//file40.csv,hdfs://localhost:54310/data-re//file41.csv,hdfs://localhost:54310/data-re//file42.csv,hdfs://localhost:54310/data-re//file43.csv,hdfs://localhost:54310/data-re//file44.csv,hdfs://localhost:54310/data-re//file45.csv,hdfs://localhost:54310/data-re//file46.csv,hdfs://localhost:54310/data-re//file47.csv,hdfs://localhost:54310/data-re//file48.csv,hdfs://localhost:54310/data-re//file49.csv,hdfs://localhost:54310/data-re//file50.csv
hdfs://localhost:54310/data-re//file0.csv
hdfs://localhost:54310/data-re//file1.csv
hdfs://localhost:54310/data-re//file2.csv
hdfs://localhost:54310/data-re//file3.csv
hdfs://localhost:54310/data-re//file4.csv
hdfs://localhost:54310/data-re//file5.csv
hdfs://localhost:54310/data-re//file6.csv
hdfs://localhost:54310/data-re//file7.csv
hdfs://localhost:54310/data-re//file8.csv
hdfs://localhost:54310/data-re//file9.csv
hdfs://localhost:54310/data-re//file10.csv
hdfs://localhost:54310/data-re//file11.csv
hdfs://localhost:54310/data-re//file12.csv
hdfs://localhost:54310/data-re//file13.csv
hdfs://localhost:54310/data-re//file14.csv
hdfs://localhost:54310/data-re//file15.csv
hdfs://localhost:54310/data-re//file16.csv
hdfs://localhost:54310/data-re//file17.csv
hdfs://localhost:54310/data-re//file18.csv
hdfs://localhost:54310/data-re//file19.csv
hdfs://localhost:54310/data-re//file20.csv
hdfs://localhost:54310/data-re//file21.csv
hdfs://localhost:54310/data-re//file22.csv
hdfs://localhost:54310/data-re//file23.csv
hdfs://localhost:54310/data-re//file24.csv
hdfs://localhost:54310/data-re//file25.csv
hdfs://localhost:54310/data-re//file26.csv
hdfs://localhost:54310/data-re//file27.csv
hdfs://localhost:54310/data-re//file28.csv
hdfs://localhost:54310/data-re//file29.csv
hdfs://localhost:54310/data-re//file30.csv
hdfs://localhost:54310/data-re//file31.csv
hdfs://localhost:54310/data-re//file32.csv
hdfs://localhost:54310/data-re//file33.csv
hdfs://localhost:54310/data-re//file34.csv
hdfs://localhost:54310/data-re//file35.csv
hdfs://localhost:54310/data-re//file36.csv
hdfs://localhost:54310/data-re//file37.csv
hdfs://localhost:54310/data-re//file38.csv
hdfs://localhost:54310/data-re//file39.csv
hdfs://localhost:54310/data-re//file40.csv
hdfs://localhost:54310/data-re//file41.csv
hdfs://localhost:54310/data-re//file42.csv
hdfs://localhost:54310/data-re//file43.csv
hdfs://localhost:54310/data-re//file44.csv
hdfs://localhost:54310/data-re//file45.csv
hdfs://localhost:54310/data-re//file46.csv
hdfs://localhost:54310/data-re//file47.csv
hdfs://localhost:54310/data-re//file48.csv
hdfs://localhost:54310/data-re//file49.csv
hdfs://localhost:54310/data-re//file50.csv
['query2;file0.csv;1580;43799;80025', 'query2;file1.csv;1524;43800;80025', 'query2;file2.csv;1614;43800;80025', 'query2;file3.csv;1505;43800;80025', 'query2;file4.csv;1582;43800;80025', 'query2;file5.csv;1531;43800;80025', 'query2;file6.csv;1534;43800;80025', 'query2;file7.csv;1617;43800;80025', 'query2;file8.csv;1480;43800;80025', 'query2;file9.csv;1534;43800;80025', 'query2;file10.csv;1530;43800;80025', 'query2;file11.csv;1623;43800;80025', 'query2;file12.csv;1536;43800;80025', 'query2;file13.csv;1543;43800;80025', 'query2;file14.csv;1559;43800;80025', 'query2;file15.csv;1632;43800;80025', 'query2;file16.csv;1588;43800;80025', 'query2;file17.csv;1580;43800;80025', 'query2;file18.csv;1578;43800;80025', 'query2;file19.csv;1501;43800;80025', 'query2;file20.csv;1636;43800;80025', 'query2;file21.csv;1545;43800;80025', 'query2;file22.csv;1645;43800;80025', 'query2;file23.csv;1484;43800;80025', 'query2;file24.csv;1533;43800;80025', 'query2;file25.csv;1585;43800;80025', 'query2;file26.csv;1591;43800;80025', 'query2;file27.csv;1513;43800;80025', 'query2;file28.csv;1531;43800;80025', 'query2;file29.csv;1648;43800;80025', 'query2;file30.csv;1607;43800;80025', 'query2;file31.csv;1586;43800;80025', 'query2;file32.csv;1613;43800;80025', 'query2;file33.csv;1585;43800;80025', 'query2;file34.csv;1574;43800;80025', 'query2;file35.csv;1595;43800;80025', 'query2;file36.csv;1626;43800;80025', 'query2;file37.csv;1600;43800;80025', 'query2;file38.csv;1506;43800;80025', 'query2;file39.csv;1612;43800;80025', 'query2;file40.csv;1538;43800;80025', 'query2;file41.csv;1599;43800;80025', 'query2;file42.csv;1576;43800;80025', 'query2;file43.csv;1559;43800;80025', 'query2;file44.csv;1578;43800;80025', 'query2;file45.csv;1583;43800;80025', 'query2;file46.csv;1517;43800;80025', 'query2;file47.csv;1632;43800;80025', 'query2;file48.csv;1537;43800;80025', 'query2;file49.csv;1549;43800;80025', 'query2;file50.csv;1571;43800;80025']
dgdfgdfdfdf
SELECT SUM(measurement) FROM indexes WHERE measurement > 0.5 AND date > timestamp '2013-03-01 17:00:00' AND date < timestamp '2013-05-01 17:00:00'
77