SELECT COUNT(*), SUM(EnergyUsageDelta) AS EnergyUsage
FROM ...
WHERE
DateTime >= '2018-01-01T00:00:00'
AND DateTime < '2018-01-07T00:00:00'
This file contains hidden or 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
ack | |
adduser | |
apt | |
apt-transport-https | |
apt-utils | |
arc-theme | |
audacious-plugins | |
audacity | |
base-files | |
base-passwd |
This file contains hidden or 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
## Test 1: file.managed | |
## SUCCESS | |
2018-06-19 08:16:52,107 [salt.minion :1428][INFO ][30764] User sudo_admin Executing command state.apply with jid 20180619081652084078 | |
2018-06-19 08:16:52,108 [salt.minion :1435][DEBUG ][30764] Command details {u'tgt_type': u'glob', u'jid': u'20180619081652084078', u'tgt': u'st*', u'ret': u'', u'user': u'sudo_admin', u'arg': [u'crate_demo_cluster.test_success', {u'test': True, u'__kwarg__': True}], u'fun': u'state.apply'} | |
2018-06-19 08:16:52,117 [salt.minion :1563][INFO ][428] Starting a new job with PID 428 | |
2018-06-19 08:16:52,122 [salt.utils.lazy :100 ][DEBUG ][428] LazyLoaded state.apply | |
2018-06-19 08:16:52,123 [salt.utils.lazy :100 ][DEBUG ][428] LazyLoaded direct_call.execute | |
2018-06-19 08:16:52,126 [salt.utils.lazy :100 ][DEBUG ][428] LazyLoaded saltutil.is_running | |
2018-06-19 08:16:52,127 [salt.utils.lazy :100 ][DEBUG ][428] LazyLoaded grains.get |
This file contains hidden or 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
package main | |
import ( | |
"context" | |
"log" | |
"strconv" | |
"github.com/jackc/pgx" | |
"github.com/jackc/pgx/pgtype" | |
) |
This file contains hidden or 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
#!/usr/bin/env python3 | |
import sys | |
from datetime import datetime | |
from crate.client import connect | |
def main(): | |
now = datetime.utcnow() | |
with connect('localhost:4200') as conn: |
This file contains hidden or 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
[jenkins@jenkins01 workspace]$ tail -n 100 CrateDB/crate_test_hourly_stable/blackbox/tmp/crate/logs/Testing57319.log | |
at org.elasticsearch.common.util.concurrent.PrioritizedEsThreadPoolExecutor$TieBreakingPrioritizedRunnable.runAndClean(PrioritizedEsThreadPoolExecutor.java:247) [crate-app-2.3.7-dc80da6.jar:2.3.7-dc80da6] | |
at org.elasticsearch.common.util.concurrent.PrioritizedEsThreadPoolExecutor$TieBreakingPrioritizedRunnable.run(PrioritizedEsThreadPoolExecutor.java:210) [crate-app-2.3.7-dc80da6.jar:2.3.7-dc80da6] | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_161] | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_161] | |
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_161] | |
[2018-05-03T16:03:55,589][WARN ][o.e.c.s.ClusterService ] [crate] failed to notify ClusterStateListener | |
java.lang.IllegalStateException: environment is not locked | |
at org.elasticsearch.env.NodeEnvironment.assertEnvIsLocked(NodeEnvironment.java:946 |
This file contains hidden or 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
c_bool => True | |
c_bool_arr => [True, False] | |
c_byte => 127 | |
c_byte_arr => [-128, 127] | |
c_double => 0.3333333333333333 | |
c_double_arr => [0.5, 0.3333333333333333, 0.25] | |
c_float => 0.5 | |
c_float_arr => [0.5, 0.33333334, 0.25] | |
c_geo_point => [9.74379, 47.4124] | |
c_geo_shape => {'coordinates': [[[16.979667, 48.123497], [16.903754, 47.714866], [16.340584, 47.712902], [16.534268, 47.496171], [16.202298, 46.852386], [16.011664, 46.683611], [15.137092, 46.658703], [14.632472, 46.431817], [13.806475, 46.509306], [12.376485, 46.767559], [12.153088, 47.115393], [11.164828, 46.941579], [11.048556, 46.751359], [10.442701, 46.893546], [9.932448, 46.920728], [9.47997, 47.10281], [9.632932, 47.347601], [9.594226, 47.525058], [9.896068, 47.580197], [10.402084, 47.302488], [10.544504, 47.566399], [11.426414, 47.523766], [12.141357, 47.703083], [12.62076, 47.672388], [12.932627, 47.467646], [13.025851, 47.637584], [12.884103, 48.289146], [13.243357, 48.416115], [13.595946, 48.877172], [14.338898, 48.555305], [14.901447, 48.964402], [15.2 |
This file contains hidden or 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
CONNECT OK | |
CREATE OK, 0 rows affected (0.002 sec) | |
DELETE OK, 5 rows affected (0.064 sec) | |
INSERT OK, 1 row affected (0.036 sec) | |
INSERT OK, 1 row affected (0.031 sec) | |
INSERT OK, 1 row affected (0.028 sec) | |
INSERT OK, 1 row affected (0.029 sec) | |
INSERT OK, 1 row affected (0.030 sec) | |
REFRESH OK, 1 row affected (0.012 sec) | |
+----------+ |
This file contains hidden or 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 TABLE IF NOT EXISTS any_vs_match ( | |
id INTEGER, | |
col_a ARRAY(STRING), | |
col_b STRING INDEX USING FULLTEXT | |
); | |
DELETE FROM any_vs_match; | |
INSERT INTO any_vs_match (id, col_a, col_b) VALUES (5, NULL, NULL); | |
INSERT INTO any_vs_match (id, col_a, col_b) VALUES (1, [], ''); |
This file contains hidden or 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
import java.util.Arrays; | |
import java.util.List; | |
import java.util.Locale; | |
public class EnumBenchmark { | |
private static State state; | |
enum State { | |
GRANT, |