AlexRogalskiy

/**
* NOTE: This class is auto generated by OpenAPI Generator (https://openapi-generator.tech) ({{{generatorVersion}}}).
* https://openapi-generator.tech
* Do not edit the class manually.
*/
package {{package}};

{{#imports}}import {{import}};
{{/imports}}
import io.swagger.annotations.*;

AlexRogalskiy

SELECT table,
    formatReadableSize(sum(bytes)) as size,
    min(min_date) as min_date,
    max(max_date) as max_date
    FROM system.parts
    WHERE active
GROUP BY table

AlexRogalskiy

import java.time.Duration;
import java.time.Instant;
import java.util.*;
import java.util.concurrent.ExecutionException;
import java.util.concurrent.Future;
import java.util.concurrent.TimeUnit;
import java.util.concurrent.TimeoutException;
import java.util.function.*;
import java.util.stream.Collector;

AlexRogalskiy

package examples;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@EnableAutoConfiguration
public class GatewayApplication {

AlexRogalskiy

{
  "info": {
    "name": "Camunda Rest API",
    "_postman_id": "11c80602-f965-2a40-f2a4-ca62e8f31218",
    "description": "",
    "schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json"
  },
  "item": [
    {
      "name": "/deployment",

AlexRogalskiy

FROM yandex/clickhouse-server:${CLICKHOUSE_VERSION:-latest}

USER root
ARG UBUNTU_NAME=focal
ARG UBUNTU_VERSION=20.04

RUN echo "Begin ODBC install" && \
    #MySQL repo
    wget -qO- "http://keyserver.ubuntu.com/pks/lookup?op=get&search=0xa4a9406876fcbd3c456770c88c718d3b5072e1f5" | apt-key add - && \
    echo "deb http://repo.mysql.com/apt/ubuntu/ ${UBUNTU_NAME} mysql-8.0" >/etc/apt/sources.list.d/mysql-oracle.list && \

AlexRogalskiy

git branch --set-upstream-to <remote-branch>
# example
git branch --set-upstream-to origin feature-branch

# show up which remote branch a local branch is tracking
git branch -vv

sets the default remote branch for the current local branch.

AlexRogalskiy

--==========================================================================================
SELECT * FROM customers AS c
WHERE EXISTS (
  SELECT * FROM orders AS o
  WHERE o.id = c.id
  AND o.date = (CURRENT_DATE - '3 MONTH'::INTERVAL) --DATE_SUB(curdate(), INTERVAL 3 MONTH)
  GROUP BY MONTH(o.date)
  HAVING COUNT(DISTINCT MONTH(o.date)) = 3;
);
--==========================================================================================

AlexRogalskiy

Intro

Normally the Jetbrains applications store their config and system in a directory in your home directory. That's fine except when you run out of space in your home directory, or they change the directory with an upgrade. For example, when you upgrade PhpStorm from 2016.3 to 2017.1, the config directory and systems directory changes as well. This means that 2017.1 doesn't have the plugins you installed with 2016.3

Somewhere buried deep in the knowledge base is an article that explains how you can fix this but putting it out here makes it easier to find.

Instructions

These instructions are written for Ubuntu, if you run another distro the locations and files might be different.

I'm assuming you config and system directory will be stored in /d1/config/{JetBrains App}/

AlexRogalskiy

layout	title	description	tags
default	SQL Style Guide	A guide to writing clean, clear, and consistent SQL.	data process

Purpose