com.clickhouse.client.ClickHouseRequest Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of clickhouse-client Show documentation
Show all versions of clickhouse-client Show documentation
Unified Java client for ClickHouse
package com.clickhouse.client;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Collections;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import java.util.Map.Entry;
import java.util.concurrent.CompletableFuture;
import java.util.concurrent.CompletionException;
import java.util.concurrent.atomic.AtomicReference;
import java.util.Optional;
import java.util.Properties;
import java.util.Set;
import java.util.function.BiConsumer;
import java.util.function.Function;
import com.clickhouse.client.config.ClickHouseClientOption;
import com.clickhouse.config.ClickHouseConfigChangeListener;
import com.clickhouse.config.ClickHouseOption;
import com.clickhouse.data.ClickHouseChecker;
import com.clickhouse.data.ClickHouseCompression;
import com.clickhouse.data.ClickHouseDeferredValue;
import com.clickhouse.data.ClickHouseExternalTable;
import com.clickhouse.data.ClickHouseFile;
import com.clickhouse.data.ClickHouseFormat;
import com.clickhouse.data.ClickHouseFreezableMap;
import com.clickhouse.data.ClickHouseInputStream;
import com.clickhouse.data.ClickHouseOutputStream;
import com.clickhouse.data.ClickHousePassThruStream;
import com.clickhouse.data.ClickHouseUtils;
import com.clickhouse.data.ClickHouseValue;
import com.clickhouse.data.ClickHouseValues;
import com.clickhouse.data.ClickHouseWriter;
/**
* Request object holding references to {@link ClickHouseClient},
* {@link ClickHouseNode}, format, sql, options and settings etc. for execution.
*/
@SuppressWarnings("squid:S119")
public class ClickHouseRequest> implements Serializable {
private static final Set SPECIAL_SETTINGS;
static final String PARAM_SETTING = "setting";
static {
Set set = new HashSet<>();
set.add(ClickHouseClientOption.QUERY_ID.getKey());
set.add(ClickHouseClientOption.SESSION_ID.getKey());
set.add(ClickHouseClientOption.SESSION_CHECK.getKey());
set.add(ClickHouseClientOption.SESSION_TIMEOUT.getKey());
SPECIAL_SETTINGS = Collections.unmodifiableSet(set);
}
static class PipedWriter implements ClickHouseWriter {
private final ClickHouseDeferredValue input;
PipedWriter(ClickHouseDeferredValue input) {
this.input = input;
}
@Override
public void write(ClickHouseOutputStream output) throws IOException {
ClickHouseInputStream in = input.get();
if (in != null) {
in.pipe(output);
}
}
}
/**
* Mutation request.
*/
public static class Mutation extends ClickHouseRequest {
protected Mutation(ClickHouseRequest request, boolean sealed) {
super(request.getClient(), request.server, request.serverRef, request.options, sealed);
if (request.options.isFreezed()) {
this.options.freeze();
}
// use headless format if possible
if (!sealed) {
format(request.getFormat().defaultInputFormat());
}
this.settings.putAll(request.settings);
if (request.settings.isFreezed()) {
this.settings.freeze();
}
this.txRef.set(request.txRef.get());
this.changeListener = request.changeListener;
this.serverListener = request.serverListener;
}
@Override
protected String getQuery() {
if (input != null && sql != null) {
int tmp = 0;
int len = sql.length();
int index = len;
while ((tmp = ClickHouseUtils.skipContentsUntil(sql, tmp, sql.length(), "format", false)) < len) {
index = tmp;
}
StringBuilder builder = new StringBuilder();
boolean spaces = false;
for (; index < len; index++) {
char ch = sql.charAt(index);
if (ClickHouseUtils.isQuote(ch) || ClickHouseUtils.isOpenBracket(ch)) {
break;
} else if (Character.isWhitespace(ch)) {
if (builder.length() > 0) {
spaces = true;
}
} else if (index + 1 < len) {
char nextCh = sql.charAt(index + 1);
if (ch == '-' && nextCh == '-') {
index = ClickHouseUtils.skipSingleLineComment(sql, index + 2, len) - 1;
} else if (ch == '/' && nextCh == '*') {
index = ClickHouseUtils.skipMultiLineComment(sql, index + 2, len) - 1;
} else if (ch == '\\') {
index++;
} else {
if (spaces) {
break;
} else {
builder.append(ch);
}
}
} else {
if (spaces) {
break;
} else {
builder.append(ch);
}
}
}
return builder.length() > 0 && index == len ? sql
: new StringBuilder().append(sql).append("\n FORMAT ").append(getFormat().name()).toString();
}
return super.getQuery();
}
@Override
public Mutation format(ClickHouseFormat format) {
if (!ClickHouseChecker.nonNull(format, "format").supportsInput()) {
throw new IllegalArgumentException("Only input format is allowed for mutation.");
}
return super.format(format);
}
/**
* Sets custom writer for writing uncompressed data, use
* {@link #data(ClickHousePassThruStream)} when the data is compressed. This
* will remove input stream set by other {@code data(...)} methods.
*
* @param writer writer
* @return mutation request
*/
public Mutation data(ClickHouseWriter writer) {
checkSealed();
this.writer = changeProperty(PROP_WRITER, this.writer,
ClickHouseChecker.nonNull(writer, ClickHouseWriter.TYPE_NAME));
this.input = changeProperty(PROP_DATA, this.input,
ClickHouseDeferredValue.of(() -> ClickHouseInputStream.of(getConfig(), writer)));
return this;
}
/**
* Loads data from the given pass-thru stream which may or may not be
* compressed. This will not only remove custom writer set by
* {@link #data(ClickHouseWriter)}, but may also update compression and format.
*
* @param stream pass-thru stream, could be a file and may or may not be
* compressed
* @return mutation request
*/
public Mutation data(ClickHousePassThruStream stream) {
checkSealed();
if (!ClickHouseChecker.nonNull(stream, ClickHousePassThruStream.TYPE_NAME).hasInput()) {
throw new IllegalArgumentException(ClickHousePassThruStream.ERROR_NO_INPUT);
}
final ClickHouseConfig c = getConfig();
if (stream.hasCompression()) {
decompressClientRequest(stream.isCompressed(), stream.getCompressionAlgorithm(),
stream.getCompressionLevel());
} else if (c.isRequestCompressed()) {
decompressClientRequest(false);
}
if (stream.hasFormat()) {
format(stream.getFormat());
}
final int bufferSize = c.getReadBufferSize();
this.input = changeProperty(PROP_DATA, this.input, ClickHouseDeferredValue
.of(() -> ClickHouseInputStream.of(stream, bufferSize, null)));
this.writer = changeProperty(PROP_WRITER, this.writer, new PipedWriter(this.input));
return this;
}
/**
* Loads data from the given file. It's same as
* {@code data(ClickHouseFile.of(file))} if the file name implies compression
* algorithm and/or format(e.g. {@code some_file.csv.gz}). It fall back to
* {@link #data(InputStream)} if no clue. This will remove custom writer set by
* {@link #data(ClickHouseWriter)}.
*
* @param file absolute or relative path of the file, file extension will be
* used to determine if it's compressed or not
* @return mutation request
*/
public Mutation data(String file) {
ClickHouseFile f = ClickHouseFile.of(file);
return f.isRecognized() ? data(f) : data(f.getInputStream());
}
/**
* Loads compressed data from the given file. This will remove custom writer set
* by {@link #data(ClickHouseWriter)}.
*
* @param file absolute or relative path of the file
* @param compression compression algorithm, null or
* {@link ClickHouseCompression#NONE} means no compression
* @return mutation request
*/
public Mutation data(String file, ClickHouseCompression compression) {
return data(ClickHouseFile.of(file, compression,
(int) ClickHouseClientOption.DECOMPRESS_LEVEL.getDefaultValue(), null));
}
/**
* Loads compressed data from the given file. This will remove custom writer set
* by {@link #data(ClickHouseWriter)}.
*
* @param file absolute or relative path of the file
* @param compression compression algorithm, null or
* {@link ClickHouseCompression#NONE} means no
* compression
* @param compressionLevel compression level, use
* {@code com.clickhouse.data.ClickHouseDataConfig#DEFAULT_READ_COMPRESS_LEVEL}
* to use recommended level for the algorithm
* @return mutation request
*/
public Mutation data(String file, ClickHouseCompression compression, int compressionLevel) {
return data(ClickHouseFile.of(file, compression, compressionLevel, null));
}
/**
* Loads data from input stream. This will remove custom writer set by
* {@link #data(ClickHouseWriter)}.
*
* @param input input stream
* @return mutation request
*/
public Mutation data(InputStream input) {
return data(ClickHouseInputStream.of(input));
}
/**
* Loads data from input stream. This will remove custom writer set by
* {@link #data(ClickHouseWriter)}.
*
* @param input input stream
* @return mutation request
*/
public Mutation data(ClickHouseInputStream input) {
if (ClickHouseChecker.nonNull(input, ClickHouseInputStream.TYPE_NAME).hasUnderlyingStream()) {
return data(input.getUnderlyingStream());
}
checkSealed();
this.input = changeProperty(PROP_DATA, this.input,
ClickHouseDeferredValue.of(input, ClickHouseInputStream.class));
this.writer = changeProperty(PROP_WRITER, this.writer, new PipedWriter(this.input));
return this;
}
/**
* Loads data from deferred input stream. This will remove custom writer set by
* {@link #data(ClickHouseWriter)}.
*
* @param input input stream
* @return mutation request
*/
public Mutation data(ClickHouseDeferredValue input) {
checkSealed();
this.input = changeProperty(PROP_DATA, this.input, input);
this.writer = changeProperty(PROP_WRITER, this.writer, input != null ? new PipedWriter(input) : null);
return this;
}
@Override
public Mutation table(String table, String queryId) {
checkSealed();
return super.query("INSERT INTO " + ClickHouseChecker.nonBlank(table, "table"), queryId);
}
@Override
public Mutation seal() {
Mutation req = this;
if (!isSealed()) {
// no idea which node we'll connect to until now
req = new Mutation(this, true);
req.externalTables.addAll(externalTables);
req.options.putAll(options);
if (options.isFreezed()) {
req.options.freeze();
}
req.settings.putAll(settings);
if (settings.isFreezed()) {
req.settings.freeze();
}
req.namedParameters.putAll(namedParameters);
req.input = input;
req.writer = writer;
req.queryId = queryId;
req.sql = sql;
req.preparedQuery = preparedQuery;
req.managerRef.set(managerRef.get());
req.txRef.set(txRef.get());
}
return req;
}
}
private static final long serialVersionUID = 4990313525960702287L;
static final String PROP_DATA = "data";
static final String PROP_MANAGER = "manager";
static final String PROP_OUTPUT = "output";
static final String PROP_PREPARED_QUERY = "preparedQuery";
static final String PROP_QUERY = "query";
static final String PROP_QUERY_ID = "queryId";
static final String PROP_TRANSACTION = "transaction";
static final String PROP_WRITER = "writer";
private final boolean sealed;
private final ClickHouseClient client;
protected final AtomicReference managerRef;
protected final Function server;
protected final AtomicReference serverRef;
protected final AtomicReference txRef;
protected final List externalTables;
protected final ClickHouseFreezableMap options;
protected final ClickHouseFreezableMap settings;
protected final Map namedParameters;
protected transient ClickHouseWriter writer;
protected transient ClickHouseDeferredValue input;
protected transient ClickHouseDeferredValue output;
protected String queryId;
protected String sql;
protected ClickHouseParameterizedQuery preparedQuery;
protected transient ClickHouseConfigChangeListener> changeListener;
protected transient BiConsumer serverListener;
// cache
protected transient ClickHouseConfig config;
protected transient List statements;
@SuppressWarnings("squid:S1905")
protected ClickHouseRequest(ClickHouseClient client, Function server,
AtomicReference ref, Map options, boolean sealed) {
if (client == null || server == null) {
throw new IllegalArgumentException("Non-null client and server are required");
}
this.client = client;
this.managerRef = new AtomicReference<>(null);
this.server = (Function & Serializable) server;
this.serverRef = ref == null ? new AtomicReference<>(null) : ref;
this.txRef = new AtomicReference<>(null);
this.externalTables = new LinkedList<>();
// TODO configurable whitelist? maybe later
this.options = ClickHouseFreezableMap.of(new HashMap<>(), ClickHouseClientOption.SESSION_ID);
this.settings = ClickHouseFreezableMap.of(new LinkedHashMap<>(client.getConfig().getCustomSettings()),
ClickHouseTransaction.SETTING_IMPLICIT_TRANSACTION);
options(options);
this.namedParameters = new HashMap<>();
this.sealed = sealed;
}
protected T changeProperty(String property, T oldValue, T newValue) {
if (changeListener != null && !Objects.equals(oldValue, newValue)) {
changeListener.propertyChanged(this, property, oldValue, newValue);
}
return newValue;
}
protected ClickHouseNode changeServer(ClickHouseNode currentServer, ClickHouseNode newServer) {
if (!serverRef.compareAndSet(currentServer, newServer)) {
newServer = getServer();
} else if (serverListener != null) {
serverListener.accept(currentServer, newServer);
}
return newServer;
}
protected void checkSealed() {
if (sealed) {
throw new IllegalStateException("Sealed request is immutable");
}
}
/**
* Gets client associated with the request.
*
* @return non-null client
*/
protected ClickHouseClient getClient() {
if (client != null) {
return client;
}
ClickHouseNode node = getServer();
return ClickHouseClient.newInstance(node.getCredentials().orElse(null), node.getProtocol());
}
/**
* Gets query, either set by {@code query()} or {@code table()}.
*
* @return sql query
*/
protected String getQuery() {
return this.sql;
}
protected void resetCache() {
if (config != null) {
config = null;
}
if (statements != null) {
statements = null;
}
}
/**
* Creates a copy of this request including listeners. Please pay attention that
* the same node reference (returned from {@link #getServer()}) will be copied
* to the new request as well, meaning failover will change node for both
* requests.
*
* @return copy of this request
*/
public ClickHouseRequest copy() {
ClickHouseRequest req = new ClickHouseRequest<>(getClient(), server, serverRef, options, false);
if (options.isFreezed()) {
req.options.freeze();
}
req.externalTables.addAll(externalTables);
req.settings.putAll(settings);
if (settings.isFreezed()) {
req.settings.freeze();
}
req.namedParameters.putAll(namedParameters);
req.input = input;
req.writer = writer;
req.output = output;
req.queryId = queryId;
req.sql = sql;
req.preparedQuery = preparedQuery;
req.managerRef.set(managerRef.get());
req.txRef.set(txRef.get());
req.changeListener = changeListener;
req.serverListener = serverListener;
return req;
}
/**
* Gets manager for the request, which defaults to
* {@link ClickHouseRequestManager#getInstance()}.
*
* @return non-null request manager
*/
public ClickHouseRequestManager getManager() {
ClickHouseRequestManager m = managerRef.get();
if (m == null) {
m = ClickHouseRequestManager.getInstance();
if (!managerRef.compareAndSet(null, m)) {
m = managerRef.get();
}
}
return m;
}
/**
* Checks if the request is sealed(immutable).
*
* @return true if the request is sealed; false otherwise
*/
public boolean isSealed() {
return this.sealed;
}
/**
* Checks if the request is bounded with a transaction.
*
* @return true if the request is bounded with a transaction; false otherwise
*/
public boolean isTransactional() {
return txRef.get() != null;
}
/**
* Checks if the request contains any input stream or custom writer.
*
* @return true if there's input stream or customer writer; false otherwise
*/
public boolean hasInputStream() {
return this.input != null || this.writer != null || !this.externalTables.isEmpty();
}
/**
* Checks if the response should be redirected to an output stream, which was
* defined by one of {@code output(*)} methods.
*
* @return true if response should be redirected to an output stream; false
* otherwise
*/
public boolean hasOutputStream() {
return this.output != null;
}
/**
* Gets the server currently connected to. The initial value was determined by
* the {@link java.util.function.Function} passed to constructor, and it may be
* changed over time when failover is enabled.
*
* @return non-null node
*/
public final ClickHouseNode getServer() {
ClickHouseNode node = serverRef.get();
if (node == null) {
node = server.apply(getClient().getConfig().getNodeSelector());
if (!serverRef.compareAndSet(null, node)) {
node = serverRef.get();
}
}
return node;
}
/**
* Gets request configuration.
*
* @return request configuration
*/
public ClickHouseConfig getConfig() {
if (config == null) {
ClickHouseConfig clientConfig = getClient().getConfig();
ClickHouseNode node = getServer();
if (options.isEmpty()
&& clientConfig.getDefaultCredentials().equals(node.getCredentials(clientConfig))) {
config = clientConfig;
} else {
Map merged = new HashMap<>();
merged.putAll(clientConfig.getAllOptions());
merged.putAll(options);
config = new ClickHouseConfig(merged, node.getCredentials(clientConfig),
clientConfig.getNodeSelector(), clientConfig.getMetricRegistry().orElse(null));
}
}
return config;
}
public ClickHouseTransaction getTransaction() {
return txRef.get();
}
public final ClickHouseConfigChangeListener> getChangeListener() {
return this.changeListener;
}
public final BiConsumer getServerListener() {
return this.serverListener;
}
/**
* Gets input stream.
*
* @return input stream
*/
public Optional getInputStream() {
return input != null ? input.getOptional() : Optional.empty();
}
/**
* Gets custom writer for writing raw request.
*
* @return custom writer
*/
public Optional getWriter() {
return Optional.ofNullable(this.writer);
}
/**
* Gets output stream.
*
* @return output stream
*/
public Optional getOutputStream() {
return output != null ? output.getOptional() : Optional.empty();
}
/**
* Gets immutable list of external tables.
*
* @return immutable list of external tables
*/
public List getExternalTables() {
return Collections.unmodifiableList(externalTables);
}
/**
* Gets data format used for communication between server and client.
*
* @return data format used for communication between server and client
*/
public ClickHouseFormat getFormat() {
return getConfig().getFormat();
}
/**
* Gets query id.
*
* @return query id
*/
public Optional getQueryId() {
return ClickHouseChecker.isNullOrEmpty(queryId) ? Optional.empty() : Optional.of(queryId);
}
/**
* Gets prepared query, which is a loosely parsed query with the origianl query
* and list of parameters.
*
* @return prepared query
*/
public ClickHouseParameterizedQuery getPreparedQuery() {
if (preparedQuery == null) {
preparedQuery = changeProperty(PROP_PREPARED_QUERY, preparedQuery,
ClickHouseParameterizedQuery.of(getConfig(), getQuery()));
}
return preparedQuery;
}
/**
* Freezes settings to discard future changes.
*
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT freezeSettings() {
settings.freeze();
return (SelfT) this;
}
/**
* Unfreezes settings to accept future changes.
*
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT unfreezeSettings() {
settings.unfreeze();
return (SelfT) this;
}
/**
* Gets typed setting value.
*
* @param type of the setting value
* @param setting non-null setting key
* @param valueType non-null value type
* @return non-null value
*/
public T getSetting(String setting, Class valueType) {
Serializable value = settings.get(ClickHouseChecker.nonBlank(setting, PARAM_SETTING));
return ClickHouseOption.fromString(value == null ? "" : value.toString(), valueType);
}
/**
* Gets typed setting value.
*
* @param type of the setting value
* @param setting non-null setting key
* @param defaultValue non-null default value
* @return non-null value
*/
public T getSetting(String setting, T defaultValue) {
Serializable value = settings.get(ClickHouseChecker.nonBlank(setting, PARAM_SETTING));
ClickHouseChecker.nonNull(defaultValue, "defaultValue");
if (value == null) {
return defaultValue;
}
return (T) ClickHouseOption.fromString(value.toString(), defaultValue.getClass());
}
/**
* Checks if a setting has been defined or not.
*
* @param setting setting
* @return true if the setting has been defined; false otherwise
*/
public boolean hasSetting(String setting) {
return settings.containsKey(setting);
}
/**
* Gets immutable settings.
*
* @return immutable settings
*/
public Map getSettings() {
return Collections.unmodifiableMap(settings);
}
/**
* Gets session id.
*
* @return session id
*/
public Optional getSessionId() {
String sessionId = getConfig().getStrOption(ClickHouseClientOption.SESSION_ID);
return ClickHouseChecker.isNullOrEmpty(sessionId) ? Optional.empty() : Optional.of(sessionId);
}
/**
* Gets list of SQL statements. Same as {@code getStatements(true)}.
*
* @return list of SQL statements
*/
public List getStatements() {
return getStatements(true);
}
/**
* Gets list of SQL statements.
*
* @param withSettings true to treat settings as SQL statement; false otherwise
* @return list of SQL statements
*/
public List getStatements(boolean withSettings) {
if (statements == null) {
statements = new ArrayList<>();
if (withSettings) {
for (Entry entry : settings.entrySet()) {
Serializable value = entry.getValue();
StringBuilder sb = new StringBuilder().append("SET ").append(entry.getKey()).append('=');
if (value instanceof String) {
sb.append('\'').append(value).append('\'');
} else if (value instanceof Boolean) {
sb.append((boolean) value ? 1 : 0);
} else {
sb.append(value);
}
statements.add(sb.toString());
}
}
String stmt = getQuery();
if (!ClickHouseChecker.isNullOrEmpty(stmt)) {
StringBuilder builder = new StringBuilder();
if (preparedQuery == null) {
ClickHouseParameterizedQuery.apply(builder, stmt, namedParameters);
} else {
preparedQuery.apply(builder, namedParameters);
}
statements.add(builder.toString());
}
}
return Collections.unmodifiableList(statements);
}
/**
* Enable or disable compression of server response. Pay attention that
* {@link ClickHouseClientOption#COMPRESS_ALGORITHM} and
* {@link ClickHouseClientOption#COMPRESS_LEVEL} will be used.
*
* @param enable true to enable compression of server response; false otherwise
* @return the request itself
*/
public SelfT compressServerResponse(boolean enable) {
return compressServerResponse(enable, null,
(int) ClickHouseClientOption.COMPRESS_LEVEL.getEffectiveDefaultValue());
}
/**
* Enable or disable compression of server response. Pay attention that
* {@link ClickHouseClientOption#COMPRESS_ALGORITHM} and
* {@link ClickHouseClientOption#COMPRESS_LEVEL} will be used.
*
* @param compressAlgorithm compression algorihtm, null or
* {@link ClickHouseCompression#NONE} means no
* compression
* @return the request itself
*/
public SelfT compressServerResponse(ClickHouseCompression compressAlgorithm) {
return compressServerResponse(compressAlgorithm != null && compressAlgorithm != ClickHouseCompression.NONE,
compressAlgorithm, (int) ClickHouseClientOption.COMPRESS_LEVEL.getEffectiveDefaultValue());
}
/**
* Enable or disable compression of server response. Pay attention that
* {@link ClickHouseClientOption#COMPRESS_LEVEL} will be used.
*
* @param enable true to enable compression of server response; false
* otherwise
* @param compressAlgorithm compression algorithm, null is treated as
* {@link ClickHouseCompression#NONE} or
* {@link ClickHouseClientOption#COMPRESS_ALGORITHM}
* depending on whether enabled
* @return the request itself
*/
public SelfT compressServerResponse(boolean enable, ClickHouseCompression compressAlgorithm) {
return compressServerResponse(enable, compressAlgorithm,
(int) ClickHouseClientOption.COMPRESS_LEVEL.getEffectiveDefaultValue());
}
/**
* Enable or disable compression of server response.
*
* @param enable true to enable compression of server response; false
* otherwise
* @param compressAlgorithm compression algorithm, null is treated as
* {@link ClickHouseCompression#NONE} or
* {@link ClickHouseClientOption#COMPRESS_ALGORITHM}
* depending on whether enabled
* @param compressLevel compression level
* @return the request itself
*/
public SelfT compressServerResponse(boolean enable, ClickHouseCompression compressAlgorithm, int compressLevel) {
checkSealed();
if (compressAlgorithm == null) {
compressAlgorithm = enable
? (ClickHouseCompression) ClickHouseClientOption.COMPRESS_ALGORITHM.getEffectiveDefaultValue()
: ClickHouseCompression.NONE;
}
return option(ClickHouseClientOption.COMPRESS, enable)
.option(ClickHouseClientOption.COMPRESS_ALGORITHM, compressAlgorithm)
.option(ClickHouseClientOption.COMPRESS_LEVEL, compressLevel);
}
/**
* Enable or disable compression of client request. Pay attention that
* {@link ClickHouseClientOption#DECOMPRESS_ALGORITHM} and
* {@link ClickHouseClientOption#DECOMPRESS_LEVEL} will be used.
*
* @param enable true to enable compression of client request; false otherwise
* @return the request itself
*/
public SelfT decompressClientRequest(boolean enable) {
return decompressClientRequest(enable, null,
(int) ClickHouseClientOption.DECOMPRESS_LEVEL.getEffectiveDefaultValue());
}
/**
* Enable or disable compression of client request. Pay attention that
* {@link ClickHouseClientOption#DECOMPRESS_LEVEL} will be used.
*
* @param compressAlgorithm compression algorithm, null is treated as
* {@link ClickHouseCompression#NONE} or
* {@link ClickHouseClientOption#DECOMPRESS_ALGORITHM}
* depending on whether enabled
* @return the request itself
*/
public SelfT decompressClientRequest(ClickHouseCompression compressAlgorithm) {
return decompressClientRequest(compressAlgorithm != null && compressAlgorithm != ClickHouseCompression.NONE,
compressAlgorithm, (int) ClickHouseClientOption.DECOMPRESS_LEVEL.getEffectiveDefaultValue());
}
/**
* Enable or disable compression of client request. Pay attention that
* {@link ClickHouseClientOption#DECOMPRESS_LEVEL} will be used.
*
* @param enable true to enable compression of client request; false
* otherwise
* @param compressAlgorithm compression algorithm, null is treated as
* {@link ClickHouseCompression#NONE} or
* {@link ClickHouseClientOption#DECOMPRESS_ALGORITHM}
* depending on whether enabled
* @return the request itself
*/
public SelfT decompressClientRequest(boolean enable, ClickHouseCompression compressAlgorithm) {
return decompressClientRequest(enable, compressAlgorithm,
(int) ClickHouseClientOption.DECOMPRESS_LEVEL.getEffectiveDefaultValue());
}
/**
* Enable or disable compression of client request.
*
* @param enable true to enable compression of client request; false
* otherwise
* @param compressAlgorithm compression algorithm, null is treated as
* {@link ClickHouseCompression#NONE}
* @param compressLevel compression level
* @return the request itself
*/
public SelfT decompressClientRequest(boolean enable, ClickHouseCompression compressAlgorithm, int compressLevel) {
checkSealed();
if (compressAlgorithm == null) {
compressAlgorithm = enable
? (ClickHouseCompression) ClickHouseClientOption.DECOMPRESS_ALGORITHM.getEffectiveDefaultValue()
: ClickHouseCompression.NONE;
}
return option(ClickHouseClientOption.DECOMPRESS, enable)
.option(ClickHouseClientOption.DECOMPRESS_ALGORITHM, compressAlgorithm)
.option(ClickHouseClientOption.DECOMPRESS_LEVEL, compressLevel);
}
/**
* Adds an external table.
*
* @param table non-null external table
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT addExternal(ClickHouseExternalTable table) {
checkSealed();
if (externalTables.add(ClickHouseChecker.nonNull(table, ClickHouseExternalTable.TYPE_NAME))) {
resetCache();
}
return (SelfT) this;
}
/**
* Sets one or more external tables.
*
* @param table non-null external table
* @param more more external tables
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT external(ClickHouseExternalTable table, ClickHouseExternalTable... more) {
checkSealed();
externalTables.clear();
externalTables.add(ClickHouseChecker.nonNull(table, ClickHouseExternalTable.TYPE_NAME));
if (more != null) {
for (ClickHouseExternalTable e : more) {
externalTables.add(ClickHouseChecker.nonNull(e, ClickHouseExternalTable.TYPE_NAME));
}
}
return (SelfT) this;
}
/**
* Sets external tables.
*
* @param tables non-null external tables
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT external(Collection tables) {
checkSealed();
externalTables.clear();
if (tables != null) {
for (ClickHouseExternalTable e : tables) {
externalTables.add(ClickHouseChecker.nonNull(e, ClickHouseExternalTable.TYPE_NAME));
}
}
return (SelfT) this;
}
/**
* Sets format to be used for communication between server and client.
*
* @param format preferred format, {@code null} means reset to default
* @return the request itself
*/
public SelfT format(ClickHouseFormat format) {
checkSealed();
return option(ClickHouseClientOption.FORMAT, format);
}
/**
* Sets request manager which is responsible for generating query ID and session
* ID, as well as transaction creation.
*
* @param manager request manager
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT manager(ClickHouseRequestManager manager) {
checkSealed();
ClickHouseRequestManager current = managerRef.get();
if (!Objects.equals(current, manager) && managerRef.compareAndSet(current, manager)) {
changeProperty(PROP_MANAGER, current, manager);
}
return (SelfT) this;
}
/**
* Freezes options to discard future changes.
*
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT freezeOptions() {
options.freeze();
return (SelfT) this;
}
/**
* Unfreezes options to accept future changes.
*
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT unfreezeOptions() {
options.unfreeze();
return (SelfT) this;
}
/**
* Sets an option. {@code option} is for configuring client's behaviour, while
* {@code setting} is for server.
*
* @param option option
* @param value value
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT option(ClickHouseOption option, Serializable value) {
checkSealed();
if (value == null) {
return removeOption(option);
} else if (option != null && option.getValueType() != value.getClass()) {
value = ClickHouseOption.fromString(value.toString(), option.getValueType());
}
if (option == ClickHouseClientOption.CUSTOM_SETTINGS) {
for (Entry entry : ClickHouseOption.toKeyValuePairs(value.toString()).entrySet()) {
set(entry.getKey(), entry.getValue());
}
} else {
Serializable oldValue = options.put(ClickHouseChecker.nonNull(option, ClickHouseConfig.PARAM_OPTION),
value); // NOSONAR
if (oldValue == null || !oldValue.equals(value)) {
if (changeListener != null) {
changeListener.optionChanged(this, option, oldValue, value);
}
resetCache();
}
}
return (SelfT) this;
}
/**
* Sets all options. {@code option} is for configuring client's behaviour, while
* {@code setting} is for server.
*
* @param options options
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT options(Map options) {
checkSealed();
if (changeListener == null) {
this.options.clear();
if (options != null) {
for (Entry e : options.entrySet()) {
option(e.getKey(), e.getValue());
}
}
resetCache();
} else {
Map m = new HashMap<>();
m.putAll(this.options);
if (options != null) {
for (Entry e : options.entrySet()) {
option(e.getKey(), e.getValue());
m.remove(e.getKey());
}
}
for (ClickHouseOption o : m.keySet()) {
removeOption(o);
}
}
return (SelfT) this;
}
/**
* Sets all options. {@code option} is for configuring client's behaviour, while
* {@code setting} is for server.
*
* @param options options
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT options(Properties options) {
checkSealed();
Map m = new HashMap<>();
m.putAll(this.options);
if (options != null) {
for (Entry e : options.entrySet()) {
Object key = e.getKey();
Object value = e.getValue();
if (key == null || value == null) {
continue;
}
ClickHouseClientOption o = ClickHouseClientOption.fromKey(key.toString());
if (o != null) {
option(o, ClickHouseOption.fromString(value.toString(), o.getValueType()));
m.remove(o);
}
}
}
for (ClickHouseOption o : m.keySet()) {
removeOption(o);
}
return (SelfT) this;
}
/**
* Checks if a option has been defined or not.
*
* @param option option
* @return true if the option has been defined; false otherwise
*/
public boolean hasOption(ClickHouseOption option) {
return options.containsKey(option);
}
/**
* Checks if a option has been defined or not.
*
* @param key key of the option
* @return true if the option has been defined; false otherwise
*/
public boolean hasOption(String key) {
return options.containsKey(ClickHouseClientOption.fromKey(key));
}
/**
* Sets pass-thru stream, to which response will be redirected.
*
* @param stream non-null pass-thru stream
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT output(ClickHousePassThruStream stream) {
checkSealed();
if (!ClickHouseChecker.nonNull(stream, ClickHousePassThruStream.TYPE_NAME).hasOutput()) {
throw new IllegalArgumentException(ClickHousePassThruStream.ERROR_NO_OUTPUT);
}
final ClickHouseConfig c = getConfig();
if (stream.hasCompression()) {
compressServerResponse(stream.isCompressed(), stream.getCompressionAlgorithm(),
stream.getCompressionLevel());
} else if (c.isResponseCompressed()) {
compressServerResponse(false);
}
if (stream.hasFormat()) {
format(stream.getFormat());
}
final int bufferSize = c.getWriteBufferSize();
this.output = changeProperty(PROP_OUTPUT, this.output, ClickHouseDeferredValue
.of(() -> ClickHouseOutputStream.of(stream, bufferSize, null)));
return (SelfT) this;
}
/**
* Sets output file, to which response will be redirected.
*
* @param file non-empty path to the file
* @return the request itself
*/
public SelfT output(String file) {
return output(ClickHouseFile.of(file));
}
/**
* Sets compressed output file, to which response will be redirected.
*
* @param file non-empty path to the file
* @param compression compression algorithm, {@code null} or
* {@link ClickHouseCompression#NONE} means no compression
* @return the request itself
*/
public SelfT output(String file, ClickHouseCompression compression) {
return output(ClickHouseFile.of(file, compression,
(int) ClickHouseClientOption.COMPRESS_LEVEL.getDefaultValue(), null));
}
/**
* Sets compressed output file, to which response will be redirected.
*
* @param file non-empty path to the file
* @param compression compression algorithm, {@code null} or
* {@link ClickHouseCompression#NONE} means no
* compression
* @param compressionLevel compression level
* @return the request itself
*/
public SelfT output(String file, ClickHouseCompression compression, int compressionLevel) {
return output(ClickHouseFile.of(file, compression, compressionLevel, null));
}
/**
* Sets output stream, to which response will be redirected.
*
* @param output non-null output stream
* @return the request itself
*/
public SelfT output(OutputStream output) {
return output(ClickHouseOutputStream.of(output));
}
/**
* Sets output stream, to which response will be redirected.
*
* @param output non-null output stream
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT output(ClickHouseOutputStream output) {
ClickHousePassThruStream stream = ClickHouseChecker.nonNull(output, ClickHouseOutputStream.TYPE_NAME)
.getUnderlyingStream();
if (stream.hasOutput()) {
return output(stream);
}
checkSealed();
this.output = changeProperty(PROP_OUTPUT, this.output,
ClickHouseDeferredValue.of(output, ClickHouseOutputStream.class));
return (SelfT) this;
}
/**
* Sets output stream, to which response will be redirected.
*
* @param output non-null output stream
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT output(ClickHouseDeferredValue output) {
checkSealed();
this.output = changeProperty(PROP_OUTPUT, this.output, output);
return (SelfT) this;
}
/**
* Sets stringified parameters. Be aware of SQL injection risk as mentioned in
* {@link #params(String, String...)}.
*
* @param values stringified parameters
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT params(Collection values) {
checkSealed();
namedParameters.clear();
if (values != null && !values.isEmpty()) {
List names = getPreparedQuery().getParameters();
int size = names.size();
int index = 0;
for (String v : values) {
namedParameters.put(names.get(index), v);
if (++index >= size) {
break;
}
}
}
resetCache();
return (SelfT) this;
}
/**
* Sets parameters wrapped by {@link ClickHouseValue}. Safer but a bit slower
* than {@link #params(String, String...)}. Consider to reuse ClickHouseValue
* object and its update methods for less overhead in batch processing.
*
* @param value parameter
* @param more more parameters
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT params(ClickHouseValue value, ClickHouseValue... more) {
checkSealed();
namedParameters.clear();
if (value != null) { // it doesn't make sense to pass null as first parameter
List names = getPreparedQuery().getParameters();
int size = names.size();
int index = 0;
namedParameters.put(names.get(index++), value.toSqlExpression());
if (more != null && more.length > 0) {
for (ClickHouseValue v : more) {
if (index >= size) {
break;
}
namedParameters.put(names.get(index++),
v != null ? v.toSqlExpression() : ClickHouseValues.NULL_EXPR);
}
}
}
resetCache();
return (SelfT) this;
}
/**
* Sets parameters wrapped by {@link ClickHouseValue}. Safer but a bit slower
* than {@link #params(String, String...)}. Consider to reuse ClickHouseValue
* object and its update methods for less overhead in batch processing.
*
* @param values parameters
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT params(ClickHouseValue[] values) {
checkSealed();
namedParameters.clear();
if (values != null && values.length > 0) {
List names = getPreparedQuery().getParameters();
int size = names.size();
int index = 0;
for (ClickHouseValue v : values) {
namedParameters.put(names.get(index), v != null ? v.toSqlExpression() : ClickHouseValues.NULL_EXPR);
if (++index >= size) {
break;
}
}
}
resetCache();
return (SelfT) this;
}
/**
* Sets stringified parameters which are used to substitude named parameters in
* SQL query without further transformation and validation. Keep in mind that
* stringified parameter is a SQL expression, meaning it could be a
* sub-query(SQL injection) in addition to value like number and string.
*
* @param value stringified parameter
* @param more more stringified parameters
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT params(String value, String... more) {
checkSealed();
namedParameters.clear();
List names = getPreparedQuery().getParameters();
int size = names.size();
if (size > 0) {
int index = 0;
namedParameters.put(names.get(index++), value);
if (more != null && more.length > 0) {
for (String v : more) {
if (index >= size) {
break;
}
namedParameters.put(names.get(index++), v);
}
}
}
resetCache();
return (SelfT) this;
}
/**
* Sets stringified parameters which are used to substitude named parameters in
* SQL query without further transformation and validation. Keep in mind that
* stringified parameter is a SQL expression, meaning it could be a
* sub-query(SQL injection) in addition to value like number and string.
*
* @param values stringified parameters
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT params(String[] values) {
checkSealed();
namedParameters.clear();
if (values != null && values.length > 0) {
List names = getPreparedQuery().getParameters();
int size = names.size();
int index = 0;
for (String v : values) {
namedParameters.put(names.get(index), v);
if (++index >= size) {
break;
}
}
}
resetCache();
return (SelfT) this;
}
/**
* Set raw parameters, which will later be stringified using
* {@link ClickHouseValues#convertToSqlExpression(Object)}. Although it is
* convenient to use, it's NOT recommended in most cases except for a few
* parameters and/or testing.
*
* @param value raw parameter
* @param more more raw parameters
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT params(Object value, Object... more) {
checkSealed();
namedParameters.clear();
List names = getPreparedQuery().getParameters();
int size = names.size();
int index = 0;
namedParameters.put(names.get(index++), ClickHouseValues.convertToSqlExpression(value));
if (more != null && more.length > 0) {
for (Object v : more) {
if (index >= size) {
break;
}
namedParameters.put(names.get(index++), ClickHouseValues.convertToSqlExpression(v));
}
}
resetCache();
return (SelfT) this;
}
/**
* Set raw parameters, which will later be stringified using
* {@link ClickHouseValues#convertToSqlExpression(Object)}. Although it is
* convenient to use, it's NOT recommended in most cases except for a few
* parameters and/or testing.
*
* @param values raw parameters
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT params(Object[] values) {
checkSealed();
namedParameters.clear();
if (values != null && values.length > 0) {
List names = getPreparedQuery().getParameters();
int size = names.size();
int index = 0;
for (Object v : values) {
namedParameters.put(names.get(index), ClickHouseValues.convertToSqlExpression(v));
if (++index >= size) {
break;
}
}
}
resetCache();
return (SelfT) this;
}
/**
* Sets named parameters. Be aware of SQL injection risk as mentioned in
* {@link #params(String, String...)}.
*
* @param namedParams named parameters
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT params(Map namedParams) {
checkSealed();
namedParameters.clear();
if (namedParams != null) {
namedParameters.putAll(namedParams);
}
resetCache();
return (SelfT) this;
}
/**
* Sets parameterized query. Same as {@code query(query, null)}.
*
* @param query non-null parameterized query
* @return the request itself
*/
public SelfT query(ClickHouseParameterizedQuery query) {
return query(query, null);
}
/**
* Sets query. Same as {@code query(sql, null)}.
*
* @param sql non-empty query
* @return the request itself
*/
public SelfT query(String sql) {
return query(sql, null);
}
/**
* Sets parameterized query and optionally query id.
*
* @param query non-null parameterized query
* @param queryId query id, null means no query id
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT query(ClickHouseParameterizedQuery query, String queryId) {
checkSealed();
if (!ClickHouseChecker.nonNull(query, PROP_QUERY).equals(this.preparedQuery)) {
this.preparedQuery = changeProperty(PROP_PREPARED_QUERY, this.preparedQuery, query);
this.sql = changeProperty(PROP_QUERY, this.sql, query.getOriginalQuery());
resetCache();
}
this.queryId = changeProperty(PROP_QUERY_ID, this.queryId, queryId);
return (SelfT) this;
}
/**
* Sets query and optionally query id.
*
* @param query non-empty query
* @param queryId query id, null means no query id
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT query(String query, String queryId) {
checkSealed();
if (!ClickHouseChecker.nonBlank(query, PROP_QUERY).equals(this.sql)) {
this.sql = changeProperty(PROP_QUERY, this.sql, query);
this.preparedQuery = changeProperty(PROP_PREPARED_QUERY, this.preparedQuery, null);
resetCache();
}
this.queryId = changeProperty(PROP_QUERY_ID, this.queryId, queryId);
return (SelfT) this;
}
/**
* Sets all server settings. When {@code settings} is null or empty, it's same
* as {@link #clearSettings()}.
*
* @param settings settings
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT settings(Map settings) {
checkSealed();
if (changeListener == null) {
this.settings.clear();
if (settings != null) {
for (Entry e : settings.entrySet()) {
set(e.getKey(), e.getValue());
}
}
resetCache();
} else {
Map m = new HashMap<>();
m.putAll(this.settings);
if (settings != null) {
for (Entry e : settings.entrySet()) {
set(e.getKey(), e.getValue());
m.remove(e.getKey());
}
}
for (String s : m.keySet()) {
removeSetting(s);
}
}
return (SelfT) this;
}
/**
* Clears server settings.
*
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT clearSettings() {
checkSealed();
if (!this.settings.isEmpty()) {
if (changeListener == null) {
this.settings.clear();
resetCache();
} else {
for (Iterator it = settings.keySet().iterator(); it.hasNext();) {
removeSetting(it.next());
}
}
}
return (SelfT) this;
}
/**
* Clears session configuration including session id, session check(whether to
* validate the id), and session timeout. Transaction will be removed as well.
*
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT clearSession() {
checkSealed();
removeOption(ClickHouseClientOption.SESSION_ID);
removeOption(ClickHouseClientOption.SESSION_CHECK);
removeOption(ClickHouseClientOption.SESSION_TIMEOUT);
// assume the transaction is managed somewhere else
ClickHouseTransaction tx = txRef.get();
if (tx != null && txRef.compareAndSet(tx, null)) {
changeProperty(PROP_TRANSACTION, tx, null);
}
return (SelfT) this;
}
/**
* Sets current session using custom id. Same as
* {@code session(sessionId, null, null)}.
*
* @param sessionId session id, null means no session
* @return the request itself
*/
public SelfT session(String sessionId) {
return session(sessionId, null, null);
}
/**
* Sets session. Same as {@code session(sessionId, check, null)}.
*
* @param sessionId session id, null means no session
* @param check whether the server should check if the session id exists or
* not
* @return the request itself
*/
public SelfT session(String sessionId, Boolean check) {
return session(sessionId, check, null);
}
/**
* Sets current session. Same as {@code session(sessionId, null, timeout)}.
*
* @param sessionId session id, null means no session
* @param timeout timeout in seconds
* @return the request itself
*/
public SelfT session(String sessionId, Integer timeout) {
return session(sessionId, null, timeout);
}
/**
* Sets current session.
*
* @param sessionId session id, null means no session
* @param check whether the server should check if the session id exists or
* not
* @param timeout timeout in seconds
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT session(String sessionId, Boolean check, Integer timeout) {
checkSealed();
ClickHouseTransaction tx = txRef.get();
if (tx != null) {
throw new IllegalArgumentException(ClickHouseUtils.format(
"Please complete %s (or clear session) before changing session to (id=%s, check=%s, timeout=%s)",
tx, sessionId, check, timeout));
} else {
option(ClickHouseClientOption.SESSION_ID, sessionId);
option(ClickHouseClientOption.SESSION_CHECK, check);
option(ClickHouseClientOption.SESSION_TIMEOUT, timeout);
}
return (SelfT) this;
}
/**
* Sets a setting. See
* https://clickhouse.tech/docs/en/operations/settings/settings/ for more
* information.
*
* @param setting non-empty setting to set
* @param value value of the setting
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT set(String setting, Serializable value) {
checkSealed();
if (SPECIAL_SETTINGS.contains(ClickHouseChecker.nonBlank(setting, PARAM_SETTING))) {
return option(ClickHouseClientOption.fromKey(setting), value);
} else if (value == null) {
return removeSetting(setting);
}
Serializable oldValue = settings.put(setting, value);
if (oldValue == null || !oldValue.equals(value)) {
if (changeListener != null) {
changeListener.settingChanged(this, setting, oldValue, value);
}
resetCache();
}
return (SelfT) this;
}
/**
* Sets a setting. See
* https://clickhouse.tech/docs/en/operations/settings/settings/ for more
* information.
*
* @param setting non-empty setting to set
* @param value value of the setting
* @return the request itself
*/
public SelfT set(String setting, String value) {
checkSealed();
return set(setting, (Serializable) ClickHouseUtils.escape(value, '\''));
}
/**
* Sets thread-safe change listener. Please keep in mind that the same listener
* might be shared by multiple requests.
*
* @param listener thread-safe change listener which may or may not be null
* @return the request itself
*/
@SuppressWarnings("unchecked")
public final SelfT setChangeListener(ClickHouseConfigChangeListener> listener) {
this.changeListener = listener;
return (SelfT) this;
}
/**
* Sets thread-safe server change listener. Please keep in mind that the same
* listener might be shared by multiple requests.
*
* @param listener thread-safe server listener which may or may not be null
* @return the request itself
*/
@SuppressWarnings("unchecked")
public final SelfT setServerListener(BiConsumer listener) {
this.serverListener = listener;
return (SelfT) this;
}
/**
* Sets target table. Same as {@code table(table, null)}.
*
* @param table non-empty table name
* @return the request itself
*/
public SelfT table(String table) {
return table(table, null);
}
/**
* Sets target table and optionally query id. This will generate a query like
* {@code SELECT * FROM [table]} and override the one set by
* {@link #query(String, String)}.
*
* @param table non-empty table name
* @param queryId query id, null means no query id
* @return the request itself
*/
public SelfT table(String table, String queryId) {
return query("SELECT * FROM ".concat(ClickHouseChecker.nonBlank(table, "table")), queryId);
}
/**
* Creates and starts a transaction. Same as {@code transaction(0)}.
*
* @return the request itself
* @throws ClickHouseException when failed to start or reuse transaction
*/
public SelfT transaction() throws ClickHouseException {
return transaction(0);
}
/**
* Creates and starts a transaction immediately. Please pay attention that
* unlike other methods in this class, it will connect to ClickHouse server,
* allocate session and start transaction right away.
*
* @param timeout transaction timeout in seconds, zero or negative means
* same as session timeout
* @return the request itself
* @throws ClickHouseException when failed to start or reuse transaction
*/
@SuppressWarnings("unchecked")
public SelfT transaction(int timeout) throws ClickHouseException {
ClickHouseTransaction tx = txRef.get();
if (tx != null && tx.getTimeout() == (timeout < 0 ? 0 : timeout)) {
return (SelfT) this;
}
return transaction(getManager().getOrStartTransaction(this, timeout));
}
/**
* Sets transaction. Any existing transaction, regardless its state, will be
* replaced by the given one.
*
* @param transaction transaction
* @return the request itself
* @throws ClickHouseException when failed to set transaction
*/
@SuppressWarnings("unchecked")
public SelfT transaction(ClickHouseTransaction transaction) throws ClickHouseException {
checkSealed();
try {
txRef.updateAndGet(x -> {
if (changeProperty(PROP_TRANSACTION, x, transaction) != null) {
final ClickHouseNode currentServer = getServer();
final ClickHouseNode txServer = transaction.getServer();
// there's no global transaction and ReplicateMergeTree is not supported
if (!currentServer.isSameEndpoint(txServer) && changeServer(currentServer, txServer) != txServer) {
throw new IllegalStateException(ClickHouseUtils
.format("Failed to change current server from %s to %s", currentServer, txServer));
}
// skip the check in session method
option(ClickHouseClientOption.SESSION_ID, transaction.getSessionId());
option(ClickHouseClientOption.SESSION_CHECK, true);
option(ClickHouseClientOption.SESSION_TIMEOUT,
transaction.getTimeout() < 1 ? null : transaction.getTimeout());
removeSetting(ClickHouseTransaction.SETTING_IMPLICIT_TRANSACTION);
} else if (x != null) {
clearSession();
}
return transaction;
});
} catch (IllegalStateException e) {
throw ClickHouseException.of(e.getMessage(), getServer());
}
return (SelfT) this;
}
/**
* Changes current database.
*
* @param database database name, {@code null} means reset to default
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT use(String database) {
checkSealed();
option(ClickHouseClientOption.DATABASE, database);
return (SelfT) this;
}
/**
* Removes an external table.
*
* @param external non-null external table
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT removeExternal(ClickHouseExternalTable external) {
checkSealed();
if (externalTables.remove(ClickHouseChecker.nonNull(external, ClickHouseExternalTable.TYPE_NAME))) {
resetCache();
}
return (SelfT) this;
}
/**
* Removes an external table by name.
*
* @param name non-empty external table name
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT removeExternal(String name) {
checkSealed();
if (!ClickHouseChecker.isNullOrEmpty(name)) {
boolean removed = false;
Iterator i = externalTables.iterator();
while (i.hasNext()) {
ClickHouseExternalTable e = i.next();
if (name.equals(e.getName())) {
i.remove();
removed = true;
}
}
if (removed) {
resetCache();
}
}
return (SelfT) this;
}
/**
* Removes an option.
*
* @param option option to be removed
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT removeOption(ClickHouseOption option) {
checkSealed();
Serializable oldValue = options.remove(ClickHouseChecker.nonNull(option, ClickHouseConfig.PARAM_OPTION));
if (oldValue != null) {
if (changeListener != null) {
changeListener.optionChanged(this, option, oldValue, null);
}
if (option == ClickHouseClientOption.CUSTOM_SETTINGS) {
for (String key : ClickHouseOption.toKeyValuePairs(oldValue.toString()).keySet()) {
removeSetting(key);
if (SPECIAL_SETTINGS.contains(key)) {
removeOption(ClickHouseClientOption.fromKey(key));
}
}
}
resetCache();
}
return (SelfT) this;
}
/**
* Removes a setting.
*
* @param setting name of the setting
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT removeSetting(String setting) {
checkSealed();
Serializable oldValue = settings.remove(ClickHouseChecker.nonBlank(setting, PARAM_SETTING));
if (oldValue != null) {
if (changeListener != null) {
changeListener.settingChanged(this, setting, oldValue, null);
}
resetCache();
}
return (SelfT) this;
}
/**
* Resets the request to start all over.
*
* @return the request itself
*/
@SuppressWarnings("unchecked")
public SelfT reset() {
checkSealed();
this.externalTables.clear();
this.namedParameters.clear();
this.serverListener = null;
if (changeListener == null) {
this.options.clear();
this.settings.clear();
} else {
for (Iterator it = this.options.keySet().iterator(); it.hasNext();) {
removeOption(it.next());
}
for (Iterator it = this.settings.keySet().iterator(); it.hasNext();) {
removeSetting(it.next());
}
}
this.input = changeProperty(PROP_DATA, this.input, null);
this.writer = changeProperty(PROP_WRITER, this.writer, null);
this.output = changeProperty(PROP_OUTPUT, this.output, null);
this.sql = changeProperty(PROP_QUERY, this.sql, null);
this.preparedQuery = changeProperty(PROP_PREPARED_QUERY, this.preparedQuery, null);
this.queryId = changeProperty(PROP_QUERY_ID, this.queryId, null);
ClickHouseRequestManager current = managerRef.get();
if (current != null && managerRef.compareAndSet(current, null)) {
changeProperty(PROP_MANAGER, current, null);
}
ClickHouseTransaction tx = txRef.get();
if (tx != null && txRef.compareAndSet(tx, null)) {
changeProperty(PROP_TRANSACTION, tx, null);
}
this.changeListener = null;
resetCache();
return (SelfT) this;
}
/**
* Creates a sealed request, which is an immutable copy of the current request.
* Listeners won't be copied to the sealed instance, because it's immutable.
*
* @return sealed request, an immutable copy of the current request
*/
public ClickHouseRequest seal() {
ClickHouseRequest req = this;
if (!isSealed()) {
// no idea which node we'll connect to until now
req = new ClickHouseRequest<>(client, getServer(), serverRef, options, true);
if (options.isFreezed()) {
req.options.freeze();
}
req.externalTables.addAll(externalTables);
req.settings.putAll(settings);
if (settings.isFreezed()) {
req.settings.freeze();
}
req.namedParameters.putAll(namedParameters);
req.input = input;
req.writer = writer;
req.output = output;
req.queryId = queryId;
req.sql = sql;
req.preparedQuery = preparedQuery;
req.managerRef.set(managerRef.get());
req.txRef.set(txRef.get());
}
return req;
}
/**
* Creates a new request for mutation.
*
* @return request for mutation
*/
public Mutation write() {
checkSealed();
return new Mutation(this, false);
}
/**
* Executes the request. Same as {@code client.execute(request.seal())}.
*
* @return non-null future to get response
* @throws CompletionException when error occurred during execution
*/
public CompletableFuture execute() {
return getClient().execute(this);
}
/**
* Synchronous version of {@link #execute()}.
*
* @return non-null response
* @throws ClickHouseException when error occurred during execution
*/
public ClickHouseResponse executeAndWait() throws ClickHouseException {
return getClient().executeAndWait(this);
}
/**
* Executes the request within an implicit transaction. New transaction will be
* always created and started right before the query, and it will be committed
* or rolled back afterwards automatically.
*
* @return non-null response
* @throws ClickHouseException when error occurred during execution
*/
public ClickHouseResponse executeWithinTransaction() throws ClickHouseException {
return executeWithinTransaction(false);
}
/**
* Executes the request within an implicit transaction. When
* {@code useImplicitTransaction} is set to {@code true}, it enforces the client
* to use {@code implicit_transaction} setting which is only available in
* ClickHouse 22.7+. Otherwise, new transaction will be always created and
* started right before the query, and it will be committed or rolled back
* afterwards automatically.
*
* @param useImplicitTransaction {@code true} to use native implicit transaction
* requiring ClickHouse 22.7+ with minimum
* overhead(no session on server side and no
* additional objects on client side); false to
* use auto-commit transaction
* @return non-null response
* @throws ClickHouseException when error occurred during execution
* @deprecated will be removed in the future, once the minimum supported version
* of ClickHouse is 22.7 or above
*/
@Deprecated
public ClickHouseResponse executeWithinTransaction(boolean useImplicitTransaction) throws ClickHouseException {
if (useImplicitTransaction) {
return set(ClickHouseTransaction.SETTING_IMPLICIT_TRANSACTION, 1).transaction(null).executeAndWait();
}
ClickHouseTransaction tx = null;
try {
tx = getManager().createImplicitTransaction(this);
// transaction will be committed only when the response is fully consumed
return getClient().executeAndWait(transaction(tx));
} catch (Exception e) {
if (tx != null) {
try {
tx.rollback();
} catch (Exception ex) {
// ignore
}
}
throw ClickHouseException.of(e, getServer());
} finally {
transaction(null);
}
}
}