Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
ru.yandex.clickhouse.ClickHouseDatabaseMetadata Maven / Gradle / Ivy
package ru.yandex.clickhouse;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.RowIdLifetime;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Iterator;
import java.util.List;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import ru.yandex.clickhouse.response.ClickHouseResultBuilder;
import ru.yandex.clickhouse.util.ClickHouseVersionNumberUtil;
import ru.yandex.clickhouse.util.TypeUtils;
import static ru.yandex.clickhouse.util.TypeUtils.NULLABLE_YES;
public class ClickHouseDatabaseMetadata implements DatabaseMetaData {
static final String DEFAULT_CAT = "default";
private static final Logger log = LoggerFactory.getLogger(ClickHouseDatabaseMetadata.class);
private final String url;
private final ClickHouseConnection connection;
public ClickHouseDatabaseMetadata(String url, ClickHouseConnection connection) {
this.url = url;
this.connection = connection;
}
@Override
public boolean allProceduresAreCallable() throws SQLException {
return true;
}
@Override
public boolean allTablesAreSelectable() throws SQLException {
return true;
}
@Override
public String getURL() throws SQLException {
return url;
}
@Override
public String getUserName() throws SQLException {
return null;
}
@Override
public boolean isReadOnly() throws SQLException {
return true;
}
@Override
public boolean nullsAreSortedHigh() throws SQLException {
return true;
}
@Override
public boolean nullsAreSortedLow() throws SQLException {
return false;
}
@Override
public boolean nullsAreSortedAtStart() throws SQLException {
return true;
}
@Override
public boolean nullsAreSortedAtEnd() throws SQLException {
return false;
}
@Override
public String getDatabaseProductName() throws SQLException {
return "ClickHouse";
}
@Override
public String getDatabaseProductVersion() throws SQLException {
return connection.getServerVersion();
}
@Override
public String getDriverName() throws SQLException {
return "ru.yandex.clickhouse-jdbc";
}
@Override
public String getDriverVersion() throws SQLException {
String driverVersion = getClass().getPackage().getImplementationVersion();
return driverVersion != null ? driverVersion : "0.1";
}
@Override
public int getDriverMajorVersion() {
String v;
try {
v = getDriverVersion();
} catch (SQLException sqle) {
log.warn("Error determining driver major version", sqle);
return 0;
}
return ClickHouseVersionNumberUtil.getMajorVersion(v);
}
@Override
public int getDriverMinorVersion() {
String v;
try {
v = getDriverVersion();
} catch (SQLException sqle) {
log.warn("Error determining driver minor version", sqle);
return 0;
}
return ClickHouseVersionNumberUtil.getMinorVersion(v);
}
@Override
public boolean usesLocalFiles() throws SQLException {
return false;
}
@Override
public boolean usesLocalFilePerTable() throws SQLException {
return false;
}
@Override
public boolean supportsMixedCaseIdentifiers() throws SQLException {
return true;
}
@Override
public boolean storesUpperCaseIdentifiers() throws SQLException {
return false;
}
@Override
public boolean storesLowerCaseIdentifiers() throws SQLException {
return false;
}
@Override
public boolean storesMixedCaseIdentifiers() throws SQLException {
return true;
}
@Override
public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException {
return true;
}
@Override
public boolean storesUpperCaseQuotedIdentifiers() throws SQLException {
return false;
}
@Override
public boolean storesLowerCaseQuotedIdentifiers() throws SQLException {
return false;
}
@Override
public boolean storesMixedCaseQuotedIdentifiers() throws SQLException {
return true;
}
@Override
public String getIdentifierQuoteString() throws SQLException {
return "`";
}
@Override
public String getSQLKeywords() throws SQLException {
return "GLOBAL,ARRAY";
}
@Override
public String getNumericFunctions() throws SQLException {
return "";
}
@Override
public String getStringFunctions() throws SQLException {
return "";
}
@Override
public String getSystemFunctions() throws SQLException {
return "";
}
@Override
public String getTimeDateFunctions() throws SQLException {
return "";
}
@Override
public String getSearchStringEscape() throws SQLException {
return "\\";
}
@Override
public String getExtraNameCharacters() throws SQLException {
return "";
}
@Override
public boolean supportsAlterTableWithAddColumn() throws SQLException {
return true;
}
@Override
public boolean supportsAlterTableWithDropColumn() throws SQLException {
return true;
}
@Override
public boolean supportsColumnAliasing() throws SQLException {
return true;
}
@Override
public boolean nullPlusNonNullIsNull() throws SQLException {
return true;
}
@Override
public boolean supportsConvert() throws SQLException {
return false;
}
@Override
public boolean supportsConvert(int fromType, int toType) throws SQLException {
return false;
}
@Override
public boolean supportsTableCorrelationNames() throws SQLException {
return false;
}
@Override
public boolean supportsDifferentTableCorrelationNames() throws SQLException {
return false;
}
@Override
public boolean supportsExpressionsInOrderBy() throws SQLException {
return true;
}
@Override
public boolean supportsOrderByUnrelated() throws SQLException {
return true;
}
@Override
public boolean supportsGroupBy() throws SQLException {
return true;
}
@Override
public boolean supportsGroupByUnrelated() throws SQLException {
return true;
}
@Override
public boolean supportsGroupByBeyondSelect() throws SQLException {
return true;
}
@Override
public boolean supportsLikeEscapeClause() throws SQLException {
return true;
}
@Override
public boolean supportsMultipleResultSets() throws SQLException {
return false;
}
@Override
public boolean supportsMultipleTransactions() throws SQLException {
return false;
}
@Override
public boolean supportsNonNullableColumns() throws SQLException {
return true;
}
@Override
public boolean supportsMinimumSQLGrammar() throws SQLException {
return false;
}
@Override
public boolean supportsCoreSQLGrammar() throws SQLException {
return false;
}
@Override
public boolean supportsExtendedSQLGrammar() throws SQLException {
return false;
}
@Override
public boolean supportsANSI92EntryLevelSQL() throws SQLException {
return false;
}
@Override
public boolean supportsANSI92IntermediateSQL() throws SQLException {
return false;
}
@Override
public boolean supportsANSI92FullSQL() throws SQLException {
return false;
}
@Override
public boolean supportsIntegrityEnhancementFacility() throws SQLException {
return false;
}
@Override
public boolean supportsOuterJoins() throws SQLException {
return true;
}
@Override
public boolean supportsFullOuterJoins() throws SQLException {
return false;
}
@Override
public boolean supportsLimitedOuterJoins() throws SQLException {
return true;
}
@Override
public String getSchemaTerm() throws SQLException {
return "database";
}
@Override
public String getProcedureTerm() throws SQLException {
return "procedure";
}
@Override
public String getCatalogTerm() throws SQLException {
return "catalog";
}
@Override
public boolean isCatalogAtStart() throws SQLException {
return false;
}
@Override
public String getCatalogSeparator() throws SQLException {
return ".";
}
@Override
public boolean supportsSchemasInDataManipulation() throws SQLException {
return true;
}
@Override
public boolean supportsSchemasInProcedureCalls() throws SQLException {
return true;
}
@Override
public boolean supportsSchemasInTableDefinitions() throws SQLException {
return true;
}
@Override
public boolean supportsSchemasInIndexDefinitions() throws SQLException {
return true;
}
@Override
public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException {
return true;
}
@Override
public boolean supportsCatalogsInDataManipulation() throws SQLException {
return false;
}
@Override
public boolean supportsCatalogsInProcedureCalls() throws SQLException {
return false;
}
@Override
public boolean supportsCatalogsInTableDefinitions() throws SQLException {
return false;
}
@Override
public boolean supportsCatalogsInIndexDefinitions() throws SQLException {
return false;
}
@Override
public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException {
return false;
}
@Override
public boolean supportsPositionedDelete() throws SQLException {
return false;
}
@Override
public boolean supportsPositionedUpdate() throws SQLException {
return false;
}
@Override
public boolean supportsSelectForUpdate() throws SQLException {
return false;
}
@Override
public boolean supportsStoredProcedures() throws SQLException {
return false;
}
@Override
public boolean supportsSubqueriesInComparisons() throws SQLException {
return true;
}
@Override
public boolean supportsSubqueriesInExists() throws SQLException {
return false;
}
@Override
public boolean supportsSubqueriesInIns() throws SQLException {
return true;
}
@Override
public boolean supportsSubqueriesInQuantifieds() throws SQLException {
return false;
}
@Override
public boolean supportsCorrelatedSubqueries() throws SQLException {
return false;
}
@Override
public boolean supportsUnion() throws SQLException {
return true;
}
@Override
public boolean supportsUnionAll() throws SQLException {
return true;
}
@Override
public boolean supportsOpenCursorsAcrossCommit() throws SQLException {
return false;
}
@Override
public boolean supportsOpenCursorsAcrossRollback() throws SQLException {
return false;
}
@Override
public boolean supportsOpenStatementsAcrossCommit() throws SQLException {
return false;
}
@Override
public boolean supportsOpenStatementsAcrossRollback() throws SQLException {
return false;
}
@Override
public int getMaxBinaryLiteralLength() throws SQLException {
return 0;
}
@Override
public int getMaxCharLiteralLength() throws SQLException {
return 0;
}
@Override
public int getMaxColumnNameLength() throws SQLException {
return 0;
}
@Override
public int getMaxColumnsInGroupBy() throws SQLException {
return 0;
}
@Override
public int getMaxColumnsInIndex() throws SQLException {
return 0;
}
@Override
public int getMaxColumnsInOrderBy() throws SQLException {
return 0;
}
@Override
public int getMaxColumnsInSelect() throws SQLException {
return 0;
}
@Override
public int getMaxColumnsInTable() throws SQLException {
return 0;
}
@Override
public int getMaxConnections() throws SQLException {
return 0;
}
@Override
public int getMaxCursorNameLength() throws SQLException {
return 0;
}
@Override
public int getMaxIndexLength() throws SQLException {
return 0;
}
@Override
public int getMaxSchemaNameLength() throws SQLException {
return 0;
}
@Override
public int getMaxProcedureNameLength() throws SQLException {
return 0;
}
@Override
public int getMaxCatalogNameLength() throws SQLException {
return 0;
}
@Override
public int getMaxRowSize() throws SQLException {
return 0;
}
@Override
public boolean doesMaxRowSizeIncludeBlobs() throws SQLException {
return false;
}
@Override
public int getMaxStatementLength() throws SQLException {
return 0;
}
@Override
public int getMaxStatements() throws SQLException {
return 0;
}
@Override
public int getMaxTableNameLength() throws SQLException {
return 0;
}
@Override
public int getMaxTablesInSelect() throws SQLException {
return 0;
}
@Override
public int getMaxUserNameLength() throws SQLException {
return 0;
}
@Override
public int getDefaultTransactionIsolation() throws SQLException {
return Connection.TRANSACTION_NONE;
}
@Override
public boolean supportsTransactions() throws SQLException {
return false;
}
@Override
public boolean supportsTransactionIsolationLevel(int level) throws SQLException {
return level == Connection.TRANSACTION_NONE;
}
@Override
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException {
return false;
}
@Override
public boolean supportsDataManipulationTransactionsOnly() throws SQLException {
return false;
}
@Override
public boolean dataDefinitionCausesTransactionCommit() throws SQLException {
return false;
}
@Override
public boolean dataDefinitionIgnoredInTransactions() throws SQLException {
return false;
}
private ResultSet request(String sql) throws SQLException {
Statement statement = connection.createStatement();
return statement.executeQuery(sql);
}
@Override
public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException {
ClickHouseResultBuilder builder = ClickHouseResultBuilder.builder(9);
builder.names(
"PROCEDURE_CAT",
"PROCEDURE_SCHEM",
"PROCEDURE_NAME",
"RES_1",
"RES_2",
"RES_3",
"REMARKS",
"PROCEDURE_TYPE",
"SPECIFIC_NAME"
);
builder.types(
"String",
"String",
"String",
"String",
"String",
"String",
"String",
"UInt8",
"String"
);
return builder.build();
}
@Override
public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException {
ClickHouseResultBuilder builder = ClickHouseResultBuilder.builder(20);
builder.names("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20");
builder.types("UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32", "UInt32");
return builder.build();
}
@Override
public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException {
/*
TABLE_CAT String => table catalog (may be null)
TABLE_SCHEM String => table schema (may be null)
TABLE_NAME String => table name
TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
REMARKS String => explanatory comment on the table
TYPE_CAT String => the types catalog (may be null)
TYPE_SCHEM String => the types schema (may be null)
TYPE_NAME String => type name (may be null)
SELF_REFERENCING_COL_NAME String => name of the designated "identifier" column of a typed table (may be null)
REF_GENERATION String => specifies how values in SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER", "DERIVED". (may be null)
*/
String sql = "select " +
"database, name, engine " +
"from system.tables " +
"where 1 = 1";
if (schemaPattern != null) {
sql += " and database like '" + schemaPattern + "'";
}
if (tableNamePattern != null) {
sql += " and name like '" + tableNamePattern + "'";
}
sql += " order by database, name";
ResultSet result = request(sql);
ClickHouseResultBuilder builder = ClickHouseResultBuilder.builder(10);
builder.names("TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "TABLE_TYPE", "REMARKS", "TYPE_CAT", "TYPE_SCHEM", "TYPE_NAME", "SELF_REFERENCING_COL_NAME", "REF_GENERATION");
builder.types("String", "String", "String", "String", "String", "String", "String", "String", "String", "String");
List typeList = types != null ? Arrays.asList(types) : null;
while (result.next()) {
List row = new ArrayList();
row.add(DEFAULT_CAT);
row.add(result.getString(1));
row.add(result.getString(2));
String type, e = result.getString(3).intern();
if (e == "View" || e == "MaterializedView" || e == "Merge" || e == "Distributed" || e == "Null") {
type = "VIEW"; // some kind of view
} else if (e == "Set" || e == "Join" || e == "Buffer") {
type = "OTHER"; // not a real table
} else {
type = "TABLE";
}
row.add(type);
for (int i = 3; i < 9; i++) {
row.add(null);
}
if (typeList == null || typeList.contains(type)) {
builder.addRow(row);
}
}
result.close();
return builder.build();
}
@Override
public ResultSet getSchemas() throws SQLException {
return getSchemas(null, null);
}
@Override
public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException {
String sql = "select name as TABLE_SCHEM, '" +
DEFAULT_CAT + "' as TABLE_CATALOG from system.databases";
if (catalog != null) {
sql += " where TABLE_CATALOG = '" + catalog + '\'';
}
if (schemaPattern != null) {
if (catalog != null) {
sql += " and ";
} else {
sql += " where ";
}
sql += "name LIKE '" + schemaPattern + '\'';
}
return request(sql);
}
@Override
public ResultSet getCatalogs() throws SQLException {
ClickHouseResultBuilder builder = ClickHouseResultBuilder.builder(1);
builder.names("TABLE_CAT");
builder.types("String");
builder.addRow(DEFAULT_CAT);
return builder.build();
}
@Override
public ResultSet getTableTypes() throws SQLException {
ClickHouseResultBuilder builder = ClickHouseResultBuilder.builder(1);
builder.names("TABLE_TYPE");
builder.types("String");
builder.addRow("TABLE");
builder.addRow("VIEW");
builder.addRow("OTHER");
return builder.build();
}
private static void buildAndCondition(StringBuilder dest, List conditions) {
Iterator iter = conditions.iterator();
if (iter.hasNext()) {
String entry = iter.next();
dest.append(entry);
}
while (iter.hasNext()) {
String entry = iter.next();
dest.append(" AND ").append(entry);
}
}
@Override
public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException {
StringBuilder query;
if (connection.getServerVersion().compareTo("1.1.54237") > 0) {
query = new StringBuilder("SELECT database, table, name, type, default_kind, default_expression ");
} else {
query = new StringBuilder("SELECT database, table, name, type, default_type, default_expression ");
}
query.append("FROM system.columns ");
List predicates = new ArrayList();
if (schemaPattern != null) {
predicates.add("database LIKE '" + schemaPattern + "' ");
}
if (tableNamePattern != null) {
predicates.add("table LIKE '" + tableNamePattern + "' ");
}
if (columnNamePattern != null) {
predicates.add("name LIKE '" + columnNamePattern + "' ");
}
if (!predicates.isEmpty()) {
query.append(" WHERE ");
buildAndCondition(query, predicates);
}
ClickHouseResultBuilder builder = getClickHouseResultBuilderForGetColumns();
ResultSet descTable = request(query.toString());
int colNum = 1;
while (descTable.next()) {
List row = new ArrayList();
//catalog name
row.add(DEFAULT_CAT);
//database name
row.add(descTable.getString(1));
//table name
row.add(descTable.getString(2));
//column name
row.add(descTable.getString(3));
String type = descTable.getString(4);
String isNullableType = TypeUtils.isTypeNull(type);
int sqlType = TypeUtils.toSqlType(type);
//data type
row.add(Integer.toString(sqlType));
//type name
row.add(TypeUtils.unwrapNullableIfApplicable(type));
// column size / precision
row.add(Integer.toString(TypeUtils.getColumnSize(type)));
//buffer length
row.add("0");
// decimal digits
row.add(Integer.toString(TypeUtils.getDecimalDigits(type)));
// radix
row.add("10");
// nullable
row.add(String.valueOf(isNullableType == NULLABLE_YES ? columnNullable : columnNoNulls));
//remarks
row.add(null);
// COLUMN_DEF
if ( descTable.getString( 5 ).equals( "DEFAULT" ) ) {
row.add( descTable.getString( 6 ) );
} else {
row.add( null );
}
//"SQL_DATA_TYPE", unused per JavaDoc
row.add(null);
//"SQL_DATETIME_SUB", unused per JavaDoc
row.add(null);
// char octet length
row.add("0");
// ordinal
row.add(String.valueOf(colNum));
colNum += 1;
//IS_NULLABLE
row.add(isNullableType);
//"SCOPE_CATALOG",
row.add(null);
//"SCOPE_SCHEMA",
row.add(null);
//"SCOPE_TABLE",
row.add(null);
//"SOURCE_DATA_TYPE",
row.add(null);
//"IS_AUTOINCREMENT"
row.add("NO");
//"IS_GENERATEDCOLUMN"
row.add("NO");
builder.addRow(row);
}
descTable.close();
return builder.build();
}
private ClickHouseResultBuilder getClickHouseResultBuilderForGetColumns() {
ClickHouseResultBuilder builder = ClickHouseResultBuilder.builder(24);
builder.names(
"TABLE_CAT",
"TABLE_SCHEM",
"TABLE_NAME",
"COLUMN_NAME",
"DATA_TYPE",
"TYPE_NAME",
"COLUMN_SIZE",
"BUFFER_LENGTH",
"DECIMAL_DIGITS",
"NUM_PREC_RADIX",
"NULLABLE",
"REMARKS",
"COLUMN_DEF",
"SQL_DATA_TYPE",
"SQL_DATETIME_SUB",
"CHAR_OCTET_LENGTH",
"ORDINAL_POSITION",
"IS_NULLABLE",
"SCOPE_CATALOG",
"SCOPE_SCHEMA",
"SCOPE_TABLE",
"SOURCE_DATA_TYPE",
"IS_AUTOINCREMENT",
"IS_GENERATEDCOLUMN"
);
builder.types(
"String",
"String",
"String",
"String",
"Int32",
"String",
"Int32",
"Int32",
"Int32",
"Int32",
"Int32",
"String",
"String",
"Int32",
"Int32",
"Int32",
"Int32",
"String",
"String",
"String",
"String",
"Int32",
"String",
"String"
);
return builder;
}
private ResultSet getEmptyResultSet() {
return ClickHouseResultBuilder.builder(1).names("some").types("String").build();
}
@Override
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getTypeInfo() throws SQLException {
ClickHouseResultBuilder builder = ClickHouseResultBuilder.builder(18);
builder.names(
"TYPE_NAME",
"DATA_TYPE",
"PRECISION",
"LITERAL_PREFIX",
"LITERAL_SUFFIX",
"CREATE_PARAMS",
"NULLABLE",
"CASE_SENSITIVE",
"SEARCHABLE",
"UNSIGNED_ATTRIBUTE",
"FIXED_PREC_SCALE",
"AUTO_INCREMENT",
"LOCAL_TYPE_NAME",
"MINIMUM_SCALE",
"MAXIMUM_SCALE",
"SQL_DATA_TYPE",
"SQL_DATETIME_SUB",
"NUM_PREC_RADIX"
);
builder.types(
"String",
"Int32",
"Int32",
"String",
"String",
"String",
"Int32",
"Int8",
"Int32",
"Int8",
"Int8",
"Int8",
"String",
"Int32",
"Int32",
"Int32",
"Int32",
"Int32"
);
builder.addRow(
"String", Types.VARCHAR,
null, // precision - todo
'\'', '\'', null,
typeNoNulls, true, typeSearchable,
true, // unsigned
true, // fixed precision (money)
false, //auto-incr
null,
null, null, // scale - should be fixed
null, null,
10
);
int[] sizes = { 8, 16, 32, 64 };
boolean[] signed = { true, false };
for (int size : sizes) {
for (boolean b: signed) {
String name = (b ? "" : "U") + "Int" + size;
builder.addRow(
name, (size <= 16 ? Types.INTEGER : Types.BIGINT),
null, // precision - todo
null, null, null,
typeNoNulls, true, typePredBasic,
!b, // unsigned
true, // fixed precision (money)
false, //auto-incr
null,
null, null, // scale - should be fixed
null, null,
10
);
}
}
int[] floatSizes = { 32, 64 };
for (int floatSize : floatSizes) {
String name = "Float" + floatSize;
builder.addRow(
name, Types.FLOAT,
null, // precision - todo
null, null, null,
typeNoNulls, true, typePredBasic,
false, // unsigned
true, // fixed precision (money)
false, //auto-incr
null,
null, null, // scale - should be fixed
null, null,
10
);
}
builder.addRow(
"Date", Types.DATE,
null, // precision - todo
null, null, null,
typeNoNulls, true, typePredBasic,
false, // unsigned
true, // fixed precision (money)
false, //auto-incr
null,
null, null, // scale - should be fixed
null, null,
10
);
builder.addRow(
"DateTime", Types.TIMESTAMP,
null, // precision - todo
null, null, null,
typeNoNulls, true, typePredBasic,
false, // unsigned
true, // fixed precision (money)
false, //auto-incr
null,
null, null, // scale - should be fixed
null, null,
10
);
return builder.build();
}
@Override
public ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException {
return getEmptyResultSet();
}
@Override
public boolean supportsResultSetType(int type) throws SQLException {
int[] types = TypeUtils.supportedTypes();
for (int i : types) {
if (i == type) {
return true;
}
}
return false;
}
@Override
public boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLException {
return false;
}
@Override
public boolean ownUpdatesAreVisible(int type) throws SQLException {
return true;
}
@Override
public boolean ownDeletesAreVisible(int type) throws SQLException {
return true;
}
@Override
public boolean ownInsertsAreVisible(int type) throws SQLException {
return true;
}
@Override
public boolean othersUpdatesAreVisible(int type) throws SQLException {
return true;
}
@Override
public boolean othersDeletesAreVisible(int type) throws SQLException {
return true;
}
@Override
public boolean othersInsertsAreVisible(int type) throws SQLException {
return true;
}
@Override
public boolean updatesAreDetected(int type) throws SQLException {
return false;
}
@Override
public boolean deletesAreDetected(int type) throws SQLException {
return false;
}
@Override
public boolean insertsAreDetected(int type) throws SQLException {
return false;
}
@Override
public boolean supportsBatchUpdates() throws SQLException {
return true;
}
@Override
public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException {
return getEmptyResultSet();
}
@Override
public Connection getConnection() throws SQLException {
return connection;
}
@Override
public boolean supportsSavepoints() throws SQLException {
return false;
}
@Override
public boolean supportsNamedParameters() throws SQLException {
return false;
}
@Override
public boolean supportsMultipleOpenResults() throws SQLException {
return false;
}
@Override
public boolean supportsGetGeneratedKeys() throws SQLException {
return false;
}
@Override
public ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException {
return getEmptyResultSet();
}
@Override
public boolean supportsResultSetHoldability(int holdability) throws SQLException {
return false;
}
@Override
public int getResultSetHoldability() throws SQLException {
return 0;
}
@Override
public int getDatabaseMajorVersion() throws SQLException {
return ClickHouseVersionNumberUtil.getMajorVersion(
connection.getServerVersion());
}
@Override
public int getDatabaseMinorVersion() throws SQLException {
return ClickHouseVersionNumberUtil.getMinorVersion(
connection.getServerVersion());
}
@Override
public int getJDBCMajorVersion() throws SQLException {
return 0;
}
@Override
public int getJDBCMinorVersion() throws SQLException {
return 1;
}
@Override
public int getSQLStateType() throws SQLException {
return sqlStateSQL;
}
@Override
public boolean locatorsUpdateCopy() throws SQLException {
return false;
}
@Override
public boolean supportsStatementPooling() throws SQLException {
return false;
}
@Override
public RowIdLifetime getRowIdLifetime() throws SQLException {
return RowIdLifetime.ROWID_UNSUPPORTED;
}
@Override
public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException {
return false;
}
@Override
public boolean autoCommitFailureClosesAllResultSets() throws SQLException {
return false;
}
@Override
public ResultSet getClientInfoProperties() throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException {
return getEmptyResultSet();
}
@Override
public ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException {
return getEmptyResultSet();
}
@Override
public T unwrap(Class iface) throws SQLException {
if (iface.isAssignableFrom(getClass())) {
return iface.cast(this);
}
throw new SQLException("Cannot unwrap to " + iface.getName());
}
@Override
public boolean isWrapperFor(Class iface) throws SQLException {
return iface.isAssignableFrom(getClass());
}
public ResultSet getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException {
return null;
}
public boolean generatedKeyAlwaysReturned() throws SQLException {
return false;
}
}
