io.druid.metadata.storage.postgresql

Class PostgreSQLConnector

java.lang.Object

io.druid.metadata.SQLMetadataConnector

io.druid.metadata.storage.postgresql.PostgreSQLConnector

All Implemented Interfaces:

MetadataStorageConnector

public class PostgreSQLConnector
extends SQLMetadataConnector

Constructor Summary

Constructors

Constructor and Description
PostgreSQLConnector(com.google.common.base.Supplier<MetadataStorageConnectorConfig> config, com.google.common.base.Supplier<MetadataStorageTablesConfig> dbTables)

Method Summary

Methods

Modifier and Type	Method and Description
org.skife.jdbi.v2.DBI	getDBI()
protected String	getPayloadType() SQL type to use for payload data (e.g.
protected String	getSerialType() Auto-incrementing SQL type to use for IDs Must be an integer type, which values will be automatically set by the database The resulting string will be interpolated into the table creation statement, e.g.
Void	insertOrUpdate(String tableName, String keyColumn, String valueColumn, String key, byte[] value)
boolean	tableExists(org.skife.jdbi.v2.Handle handle, String tableName)

Methods inherited from class io.druid.metadata.SQLMetadataConnector

createConfigTable, createConfigTable, createEntryTable, createLockTable, createLogTable, createRulesTable, createRulesTable, createSegmentTable, createSegmentTable, createTable, createTaskTables, getConfig, getDatasource, getValidationQuery, isTransientException, lookup

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PostgreSQLConnector

@Inject
public PostgreSQLConnector(com.google.common.base.Supplier<MetadataStorageConnectorConfig> config,
                          com.google.common.base.Supplier<MetadataStorageTablesConfig> dbTables)

Method Detail

getPayloadType

protected String getPayloadType()

Description copied from class: SQLMetadataConnector

SQL type to use for payload data (e.g. JSON blobs). Must be a binary type, which values can be accessed using ResultSet.getBytes() The resulting string will be interpolated into the table creation statement, e.g. CREATE TABLE druid_table ( payload NOT NULL, ... )

Overrides:

getPayloadType in class SQLMetadataConnector

Returns:

String representing the SQL type

getSerialType

protected String getSerialType()

Description copied from class: SQLMetadataConnector

Auto-incrementing SQL type to use for IDs Must be an integer type, which values will be automatically set by the database The resulting string will be interpolated into the table creation statement, e.g. CREATE TABLE druid_table ( id NOT NULL, ... )

Specified by:

getSerialType in class SQLMetadataConnector

Returns:

String representing the SQL type and auto-increment statement

tableExists

public boolean tableExists(org.skife.jdbi.v2.Handle handle,
                  String tableName)

Specified by:

tableExists in class SQLMetadataConnector

insertOrUpdate

public Void insertOrUpdate(String tableName,
                  String keyColumn,
                  String valueColumn,
                  String key,
                  byte[] value)
                    throws Exception

Specified by:

insertOrUpdate in interface MetadataStorageConnector

Overrides:

insertOrUpdate in class SQLMetadataConnector

Throws:

Exception

getDBI

public org.skife.jdbi.v2.DBI getDBI()

Specified by:

getDBI in class SQLMetadataConnector