jodok

/*
 * This file is part of a module with proprietary Enterprise Features.
 *
 * Licensed to Crate.io Inc. ("Crate.io") under one or more contributor 
 * license agreements.  See the NOTICE file distributed with this work for
 * additional information regarding copyright ownership.
 *
 * Unauthorized copying of this file, via any medium is strictly prohibited.
 *
 * To use this file, Crate.io must have given you permission to enable and

jodok

/*
 * Licensed to Crate.io Inc. ("Crate.io") under one or more contributor
 * license agreements.  See the NOTICE file distributed with this work for
 * additional information regarding copyright ownership.  Crate.io licenses 
 * this file to you under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.  You may
 * obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *

jodok

CrateDB
Copyright 2013-2017 Crate.io Inc. ("Crate.io")


Third party dependencies:

=========================================================================

Lucene
http://lucene.apache.org/

jodok

CrateDB
Copyright 2013-2017 Crate.io Inc. ("Crate.io")


Licensed to Crate.io Inc. ("Crate.io") under one or more contributor license
agreements.  See the NOTICE file distributed with this work for additional
information regarding copyright ownership.  Crate.io licenses this file to
you under the Apache License, Version 2.0 (the "License"); you may not use
this file except in compliance with the License.  You may obtain a copy of
the License at

jodok

CrateDB Sample Enterprise Module
Copyright 2013-2017 Crate.io Inc. ("Crate.io")

This module contains proprietary Enterprise Features.

Licensed to Crate.io Inc. ("Crate.io") under one or more contributor license
agreements.  See the NOTICE file distributed with this work for additional
information regarding copyright ownership.

Unauthorized copying, via any medium is strictly prohibited.

jodok

hierarchy = [
    {'config/global.toml': '*'},
    {'config/tenants.toml': tenant},
    {'config/hosts-{}.toml'.format(tenant): hostname}]

for level in hierarchy:
    for path, section in level.items():
        with open(path) as config_file:
            config = toml.loads(config_file.read())
            # go one level down if section is defined

jodok

[2016-09-21 10:57:21,335][TRACE][tasks                    ] [Kuchenspitze] register 163 [transport] [crate_sql] []
[2016-09-21 10:57:21,336][DEBUG][io.crate.action.sql.SQLOperations] method=parse stmtName= query=select cast(sum(num_docs) as long), schema_name, table_name from sys.shards group by 2, 3 paramTypes=[]
[2016-09-21 10:57:21,338][DEBUG][io.crate.action.sql.SQLOperations] method=bind portalName= statementName= params=[]
[2016-09-21 10:57:21,339][DEBUG][io.crate.action.sql.SQLOperations] method=describe type=P portalOrStatement=
[2016-09-21 10:57:21,339][DEBUG][io.crate.action.sql.SQLOperations] method=execute portalName= maxRows=0
[2016-09-21 10:57:21,339][DEBUG][io.crate.action.sql.SQLOperations] method=sync
[2016-09-21 10:57:21,340][TRACE][io.crate.protocols.postgres.SimplePortal] method=resumeIfSuspended
[2016-09-21 10:57:21,340][TRACE][io.crate.operation.NodeOperation] Phase uses SAME_NODE downstream, reason: ON HANDLER, executionNodes: [yedBYmDFQcOcu86ylhgUQw], phase: RoutedCollectPhase{name=col

jodok

[2016-09-20 23:37:11,550][TRACE][io.crate.protocols.postgres.ConnectionContext] Received SSL negotiation pkg
[2016-09-20 23:37:11,550][TRACE][io.crate.protocols.postgres.ConnectionContext] sent SSL neg: N
[2016-09-20 23:37:11,676][TRACE][io.crate.protocols.postgres.ConnectionContext] channelDisconnected
[2016-09-20 23:37:11,807][TRACE][io.crate.protocols.postgres.ConnectionContext] Header pkgLength: 99
[2016-09-20 23:37:11,807][TRACE][io.crate.protocols.postgres.ConnectionContext] protocol 3.0
[2016-09-20 23:37:11,807][TRACE][io.crate.protocols.postgres.ConnectionContext] payload: key=user value=xxx
[2016-09-20 23:37:11,807][TRACE][io.crate.protocols.postgres.ConnectionContext] payload: key=database value=tweets
[2016-09-20 23:37:11,807][TRACE][io.crate.protocols.postgres.ConnectionContext] payload: key=client_encoding value=UTF8
[2016-09-20 23:37:11,807][TRACE][io.crate.protocols.postgres.ConnectionContext] payload: key=DateStyle value=ISO
[2016-09-20 23:37:11,807][TRACE][io.crate.protocols.postgres.Connecti

jodok

######################### Crate Configuration Example #########################

# The default configuration offers the ability to use Crate right away.
# The purpose of this file is to give operators an overview of the various
# different configuration settings. To read the full documentation go to
# <https://docs.crate.io/>

# As mentioned bemfore, you can use Crate right away. For fine-tuning consider
# to configure Crate as you need or want it to behave.
# Use this file to fine-tune your Crate cluster. If you have any questions

jodok

CREATE TABLE steps (
    username STRING,
    ts TIMESTAMP,
    num_steps INTEGER,
    month_partition STRING,
    payload OBJECT(dynamic)
) CLUSTERED BY (username) INTO 12 shards
  PARTITIONED BY (month_partition)
  WITH (number_of_replicas = 1, refresh_interval = 0);