CreatePartitionedRowTable

An example that shows how to create partitioned row tables in SnappyData using SQL or APIs.

This example can be run either in local mode (in which case the example runs collocated with Spark+SnappyData Store in the same JVM) or can be submitted as a job to an already running SnappyData cluster.

To run the example in local mode go to your SnappyData product distribution directory and type following command on the command prompt

bin/run-example snappydata.CreatePartitionedRowTable

To submit this example as a job to an already running cluster

  cd $SNAPPY_HOME
  bin/snappy-job.sh submit
  --app-name CreatePartitionedRowTable
  --class org.apache.spark.examples.snappydata.CreatePartitionedRowTable
  --app-jar examples/jars/quickstart.jar
  --lead [leadHost:port]

Check the status of your job id
bin/snappy-job.sh status --lead [leadHost:port] --job-id [job-id]

The output of the job will be redirected to a file named CreatePartitionedRowTable.out

Linear Supertypes

SnappySQLJob, SparkJobBase, AnyRef, Any

Type Members

type C = Any

Definition Classes
SnappySQLJob → SparkJobBase
case class Data(PS_PARTKEY: Int, PS_SUPPKEY: Int, PS_AVAILQTY: Int, PS_SUPPLYCOST: BigDecimal) extends Product with Serializable

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
final def asInstanceOf[T0]: T0

Definition Classes
Any
def clone(): AnyRef

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( ... )
def createAndGetDataDir: String
def createPartitionedRowTableUsingAPI(snSession: SnappySession, pw: PrintWriter): Unit

Creates a partitioned row table and performs operations on it using APIs
def createPartitionedRowTableUsingSQL(snSession: SnappySession, pw: PrintWriter): Unit

Creates a partitioned row table and performs operations on it using SQL queries thru SnappyContext
Creates a partitioned row table and performs operations on it using SQL queries thru SnappyContext
Other way to execute a SQL statement is thru JDBC or ODBC driver. Refer to JDBCExample.scala for more details
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] )
final def getClass(): Class[_]

Definition Classes
AnyRef → Any
def getCurrentDirectory: String
def hashCode(): Int

Definition Classes
AnyRef → Any
final def isInstanceOf[T0]: Boolean

Definition Classes
Any
def isValidJob(sc: SnappySession, config: Config): SnappyJobValidation

Definition Classes
CreatePartitionedRowTable → SnappySQLJob
def main(args: Array[String]): Unit
final def ne(arg0: AnyRef): Boolean

Definition Classes
AnyRef
final def notify(): Unit

Definition Classes
AnyRef
final def notifyAll(): Unit

Definition Classes
AnyRef
final def runJob(sc: C, jobConfig: Config): Any

Definition Classes
SnappySQLJob → SparkJobBase
def runSnappyJob(snSession: SnappySession, jobConfig: Config): Any

Definition Classes
CreatePartitionedRowTable → SnappySQLJob
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
def toString(): String

Definition Classes
AnyRef → Any
final def validate(sc: C, config: Config): SparkJobValidation

Definition Classes
SnappySQLJob → SparkJobBase
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 snappydata

object CreatePartitionedRowTable extends SnappySQLJob

Type Members

type C = Any

case class Data(PS_PARTKEY: Int, PS_SUPPKEY: Int, PS_AVAILQTY: Int, PS_SUPPLYCOST: BigDecimal) extends Product with Serializable

Value Members

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

final def asInstanceOf[T0]: T0

def clone(): AnyRef

def createAndGetDataDir: String

def createPartitionedRowTableUsingAPI(snSession: SnappySession, pw: PrintWriter): Unit

def createPartitionedRowTableUsingSQL(snSession: SnappySession, pw: PrintWriter): Unit

final def eq(arg0: AnyRef): Boolean

def equals(arg0: Any): Boolean

def finalize(): Unit

final def getClass(): Class[_]

def getCurrentDirectory: String

def hashCode(): Int

final def isInstanceOf[T0]: Boolean

def isValidJob(sc: SnappySession, config: Config): SnappyJobValidation

def main(args: Array[String]): Unit

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

final def runJob(sc: C, jobConfig: Config): Any

def runSnappyJob(snSession: SnappySession, jobConfig: Config): Any

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

def toString(): String

final def validate(sc: C, config: Config): SparkJobValidation

final def wait(): Unit

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

final def wait(arg0: Long): Unit

Inherited from SnappySQLJob

Inherited from SparkJobBase

Inherited from AnyRef

Inherited from Any

Ungrouped