SnappyDataBaseDialect

Instance Constructors

new SnappyDataBaseDialect()

Abstract Value Members

abstract def canHandle(url: String): Boolean

Check if this dialect instance can handle a certain jdbc url.
Check if this dialect instance can handle a certain jdbc url.
url
the jdbc url.
returns
True if the dialect can be applied on the given jdbc url.

Definition Classes
JdbcDialect
Exceptions thrown
NullPointerException if the url is null.

Concrete Value Members

final def !=(arg0: Any): Boolean

Definition Classes
AnyRef → Any
final def ##(): Int

Definition Classes
AnyRef → Any
final def ==(arg0: Any): Boolean

Definition Classes
AnyRef → Any
def addExtraDriverProperties(isLoner: Boolean, props: Properties): Unit

Definition Classes
JdbcExtendedDialect
final def asInstanceOf[T0]: T0

Definition Classes
Any
def beforeFetch(connection: Connection, properties: Map[String, String]): Unit

Override connection specific properties to run before a select is made.
Override connection specific properties to run before a select is made. This is in place to allow dialects that need special treatment to optimize behavior.
connection
The connection object
properties
The connection properties. This is passed through from the relation.

Definition Classes
JdbcDialect
def clone(): AnyRef

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( ... )
def createSchema(schemaName: String, conn: Connection): Unit

Create a new schema.
Create a new schema.

Definition Classes
SnappyDataBaseDialect → JdbcExtendedDialect
def dropTable(tableName: String, conn: Connection, context: SQLContext, ifExists: Boolean): Unit

Definition Classes
SnappyDataBaseDialect → JdbcExtendedDialect
final def eq(arg0: AnyRef): Boolean

Definition Classes
AnyRef
def equals(arg0: Any): Boolean

Definition Classes
AnyRef → Any
def finalize(): Unit

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( classOf[java.lang.Throwable] )
def getCatalystType(sqlType: Int, typeName: String, size: Int, md: MetadataBuilder, session: Option[SparkSession]): Option[DataType]
def getCatalystType(sqlType: Int, typeName: String, size: Int, md: MetadataBuilder): Option[DataType]

Get the custom datatype mapping for the given jdbc meta information.
Get the custom datatype mapping for the given jdbc meta information.
sqlType
The sql type (see java.sql.Types)
typeName
The sql type name (e.g. "BIGINT UNSIGNED")
size
The size of the type.
md
Result metadata associated with this type.
returns
The actual DataType (subclasses of org.apache.spark.sql.types.DataType) or null if the default type mapping should be used.

Definition Classes
SnappyDataBaseDialect → JdbcDialect
final def getClass(): Class[_]

Definition Classes
AnyRef → Any
def getJDBCMetadata(dt: DataType, md: Metadata, forTableDefn: Boolean): (DataType, String, Int, Int, Int)

Get JDBC metadata for a catalyst column representation.
Get JDBC metadata for a catalyst column representation.
See SPARK-10101 issue for similar problem. If the PR raised is merged we can update VARCHAR handling here accordingly. [UPDATE] related PRs have been merged and SPARK-10101 closed but it is only for passing through full types in CREATE TABLE and not when reading unlike what is reauired for SnappyData.
dt
the DataType of the column
md
any additional Metadata for the column
forTableDefn
if true then the type name string returned will be suitable for column definition in CREATE TABLE etc; the differences being that it will include size definitions for CHAR/VARCHAR and complex types will be mapped to underlying storage format rather than for display (i.e. BLOB)
def getJDBCType(dt: DataType, md: Metadata): Option[JdbcType]

Look SPARK-10101 issue for similar problem.
Look SPARK-10101 issue for similar problem. If the PR raised is ever merged we can remove this method here.
md
The metadata
returns
The new JdbcType if there is an override for this DataType

Definition Classes
SnappyDataBaseDialect → JdbcExtendedDialect
def getJDBCType(dt: DataType): Option[JdbcType]

Retrieve the jdbc / sql type for a given datatype.
Retrieve the jdbc / sql type for a given datatype.
dt
The datatype (e.g. org.apache.spark.sql.types.StringType)
returns
The new JdbcType if there is an override for this DataType

Definition Classes
SnappyDataBaseDialect → JdbcDialect
def getPartitionByClause(col: String): String

Definition Classes
SnappyDataBaseDialect → JdbcExtendedDialect
def getSchemaQuery(table: String): String

The SQL query that should be used to discover the schema of a table.
The SQL query that should be used to discover the schema of a table. It only needs to ensure that the result set has the same schema as the table, such as by calling "SELECT * ...". Dialects can override this method to return a query that works best in a particular database.
table
The name of the table.
returns
The SQL query to use for discovering the schema.

Definition Classes
SnappyDataBaseDialect → JdbcDialect
def getTableExistsQuery(table: String): String

Get the SQL query that should be used to find if the given table exists.
Get the SQL query that should be used to find if the given table exists. Dialects can override this method to return a query that works best in a particular database.
table
The name of the table.
returns
The SQL query to use for checking the table.

Definition Classes
SnappyDataBaseDialect → JdbcDialect
def hashCode(): Int

Definition Classes
AnyRef → Any
def initializeTable(tableName: String, caseSensitive: Boolean, conn: Connection): Unit

Definition Classes
SnappyDataBaseDialect → JdbcExtendedDialect
def isCascadingTruncateTable(): Option[Boolean]

Return Some[true] iff TRUNCATE TABLE causes cascading default.
Return Some[true] iff TRUNCATE TABLE causes cascading default. Some[true] : TRUNCATE TABLE causes cascading. Some[false] : TRUNCATE TABLE does not cause cascading. None: The behavior of TRUNCATE TABLE is unknown (default).

Definition Classes
JdbcDialect
final def isInstanceOf[T0]: Boolean

Definition Classes
Any
final def ne(arg0: AnyRef): Boolean

Definition Classes
AnyRef
final def notify(): Unit

Definition Classes
AnyRef
final def notifyAll(): Unit

Definition Classes
AnyRef
def quoteIdentifier(colName: String): String

Quotes the identifier.
Quotes the identifier. This is used to put quotes around the identifier in case the column name is a reserved keyword, or in case it contains characters that require quotes (e.g. space).

Definition Classes
JdbcDialect
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
def tableExists(table: String, conn: Connection, context: SQLContext): Boolean

Query string to check for existence of a table
Query string to check for existence of a table

Definition Classes
SnappyDataBaseDialect → JdbcExtendedDialect
def toString(): String

Definition Classes
AnyRef → Any
def truncateTable(tableName: String): String

Get the DDL to truncate a table, or null/empty if truncate is not supported.
Get the DDL to truncate a table, or null/empty if truncate is not supported.

Definition Classes
JdbcExtendedDialect
final def wait(): Unit

Definition Classes
AnyRef
Annotations
@throws( ... )
final def wait(arg0: Long, arg1: Int): Unit

Definition Classes
AnyRef
Annotations
@throws( ... )
final def wait(arg0: Long): Unit

Definition Classes
AnyRef
Annotations
@throws( ... )

Related Doc: package sql

abstract class SnappyDataBaseDialect extends JdbcExtendedDialect

Instance Constructors

new SnappyDataBaseDialect()

Abstract Value Members

abstract def canHandle(url: String): Boolean

Concrete Value Members

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

def addExtraDriverProperties(isLoner: Boolean, props: Properties): Unit

final def asInstanceOf[T0]: T0

def beforeFetch(connection: Connection, properties: Map[String, String]): Unit

def clone(): AnyRef

def createSchema(schemaName: String, conn: Connection): Unit

def dropTable(tableName: String, conn: Connection, context: SQLContext, ifExists: Boolean): Unit

final def eq(arg0: AnyRef): Boolean

def equals(arg0: Any): Boolean

def finalize(): Unit

def getCatalystType(sqlType: Int, typeName: String, size: Int, md: MetadataBuilder, session: Option[SparkSession]): Option[DataType]

def getCatalystType(sqlType: Int, typeName: String, size: Int, md: MetadataBuilder): Option[DataType]

final def getClass(): Class[_]

def getJDBCMetadata(dt: DataType, md: Metadata, forTableDefn: Boolean): (DataType, String, Int, Int, Int)

def getJDBCType(dt: DataType, md: Metadata): Option[JdbcType]

def getJDBCType(dt: DataType): Option[JdbcType]

def getPartitionByClause(col: String): String

def getSchemaQuery(table: String): String

def getTableExistsQuery(table: String): String

def hashCode(): Int

def initializeTable(tableName: String, caseSensitive: Boolean, conn: Connection): Unit

def isCascadingTruncateTable(): Option[Boolean]

final def isInstanceOf[T0]: Boolean

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

def quoteIdentifier(colName: String): String

final def synchronized[T0](arg0: ⇒ T0): T0

def tableExists(table: String, conn: Connection, context: SQLContext): Boolean

def toString(): String

def truncateTable(tableName: String): String

final def wait(): Unit

final def wait(arg0: Long, arg1: Int): Unit

final def wait(arg0: Long): Unit

Inherited from JdbcExtendedDialect

Inherited from JdbcDialect

Inherited from Serializable

Inherited from Serializable

Inherited from AnyRef

Inherited from Any

Ungrouped