Skip to content

Instantly share code, notes, and snippets.

View chaudum's full-sized avatar
🏠
Working from home

Christian Haudum chaudum

🏠
Working from home
View GitHub Profile
ack
adduser
apt
apt-transport-https
apt-utils
arc-theme
audacious-plugins
audacity
base-files
base-passwd
## 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
package main
import (
"context"
"log"
"strconv"
"github.com/jackc/pgx"
"github.com/jackc/pgx/pgtype"
)
#!/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:
[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
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

FT vs OBJ

Query 1: STRING column with fulltext

SELECT COUNT(*), SUM(EnergyUsageDelta) AS EnergyUsage
FROM ...
WHERE
  DateTime >= '2018-01-01T00:00:00'
  AND DateTime < '2018-01-07T00:00:00'
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)
+----------+
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, [], '');
import java.util.Arrays;
import java.util.List;
import java.util.Locale;
public class EnumBenchmark {
private static State state;
enum State {
GRANT,