Class

org.apache.spark.sql.execution.command

CreateTableCommand

Related Doc: package command

Permalink

case class CreateTableCommand(table: CatalogTable, ifNotExists: Boolean) extends LogicalPlan with RunnableCommand with Product with Serializable

A command to create a table.

Note: This is currently used only for creating Hive tables. This is not intended for temporary tables.

The syntax of using this command in SQL is:

CREATE [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name
[(col1 data_type [COMMENT col_comment], ...)]
[COMMENT table_comment]
[PARTITIONED BY (col3 data_type [COMMENT col_comment], ...)]
[CLUSTERED BY (col1, ...) [SORTED BY (col1 [ASC|DESC], ...)] INTO num_buckets BUCKETS]
[SKEWED BY (col1, col2, ...) ON ((col_value, col_value, ...), ...)
[STORED AS DIRECTORIES]
[ROW FORMAT row_format]
[STORED AS file_format | STORED BY storage_handler_class [WITH SERDEPROPERTIES (...)]]
[LOCATION path]
[TBLPROPERTIES (property_name=property_value, ...)]
[AS select_statement];
Linear Supertypes
Serializable, Serializable, RunnableCommand, Command, LogicalPlan, Logging, QueryPlan[LogicalPlan], TreeNode[LogicalPlan], Product, Equals, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. CreateTableCommand
  2. Serializable
  3. Serializable
  4. RunnableCommand
  5. Command
  6. LogicalPlan
  7. Logging
  8. QueryPlan
  9. TreeNode
  10. Product
  11. Equals
  12. AnyRef
  13. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Instance Constructors

  1. new CreateTableCommand(table: CatalogTable, ifNotExists: Boolean)

    Permalink

Value Members

  1. final def !=(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any

  2. final def ##(): Int

    Permalink
    Definition Classes
    AnyRef → Any

  3. final def ==(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any

  4. lazy val allAttributes: AttributeSeq

    Permalink
    Definition Classes
    QueryPlan

  5. def analyzed: Boolean

    Permalink
    Definition Classes
    LogicalPlan

  6. def apply(number: Int): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  7. def argString: String

    Permalink
    Definition Classes
    TreeNode

  8. def asCode: String

    Permalink
    Definition Classes
    TreeNode

  9. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any

  10. lazy val canonicalized: LogicalPlan

    Permalink
    Definition Classes
    LogicalPlan → QueryPlan

  11. final def children: Seq[LogicalPlan]

    Permalink
    Definition Classes
    RunnableCommand → TreeNode

  12. def childrenResolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan

  13. lazy val cleanArgs: Seq[Any]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan

  14. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  15. def collect[B](pf: PartialFunction[LogicalPlan, B]): Seq[B]

    Permalink
    Definition Classes
    TreeNode

  16. def collectFirst[B](pf: PartialFunction[LogicalPlan, B]): Option[B]

    Permalink
    Definition Classes
    TreeNode

  17. lazy val constraints: ExpressionSet

    Permalink
    Definition Classes
    QueryPlan

  18. lazy val containsChild: Set[TreeNode[_]]

    Permalink
    Definition Classes
    TreeNode

  19. final def eq(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef

  20. final def expressions: Seq[Expression]

    Permalink
    Definition Classes
    QueryPlan

  21. def fastEquals(other: TreeNode[_]): Boolean

    Permalink
    Definition Classes
    TreeNode

  22. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )

  23. def find(f: (LogicalPlan) ⇒ Boolean): Option[LogicalPlan]

    Permalink
    Definition Classes
    TreeNode

  24. def flatMap[A](f: (LogicalPlan) ⇒ TraversableOnce[A]): Seq[A]

    Permalink
    Definition Classes
    TreeNode

  25. def foreach(f: (LogicalPlan) ⇒ Unit): Unit

    Permalink
    Definition Classes
    TreeNode

  26. def foreachUp(f: (LogicalPlan) ⇒ Unit): Unit

    Permalink
    Definition Classes
    TreeNode

  27. def generateTreeString(depth: Int, lastChildren: Seq[Boolean], builder: StringBuilder, verbose: Boolean, prefix: String): StringBuilder

    Permalink
    Definition Classes
    TreeNode

  28. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any

  29. def getNodeNumbered(number: MutableInt): LogicalPlan

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  30. def getRelevantConstraints(constraints: Set[Expression]): Set[Expression]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan

  31. def hashCode(): Int

    Permalink
    Definition Classes
    TreeNode → AnyRef → Any

  32. val ifNotExists: Boolean

    Permalink

  33. def initializeLogIfNecessary(isInterpreter: Boolean): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  34. def innerChildren: Seq[QueryPlan[_]]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan → TreeNode

  35. def inputSet: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  36. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any

  37. def isStreaming: Boolean

    Permalink
    Definition Classes
    LogicalPlan

  38. def isTraceEnabled(): Boolean

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  39. def jsonFields: List[JField]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  40. def log: Logger

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  41. def logDebug(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  42. def logDebug(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  43. def logError(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  44. def logError(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  45. def logInfo(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  46. def logInfo(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  47. def logName: String

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  48. def logTrace(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  49. def logTrace(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  50. def logWarning(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  51. def logWarning(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  52. def makeCopy(newArgs: Array[AnyRef]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  53. def map[A](f: (LogicalPlan) ⇒ A): Seq[A]

    Permalink
    Definition Classes
    TreeNode

  54. def mapChildren(f: (LogicalPlan) ⇒ LogicalPlan): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  55. def mapProductIterator[B](f: (Any) ⇒ B)(implicit arg0: ClassTag[B]): Array[B]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  56. def maxRows: Option[Long]

    Permalink
    Definition Classes
    LogicalPlan

  57. def missingInput: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  58. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef

  59. def nodeName: String

    Permalink
    Definition Classes
    TreeNode

  60. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef

  61. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef

  62. def numberedTreeString: String

    Permalink
    Definition Classes
    TreeNode

  63. val origin: Origin

    Permalink
    Definition Classes
    TreeNode

  64. def otherCopyArgs: Seq[AnyRef]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  65. def output: Seq[Attribute]

    Permalink
    Definition Classes
    RunnableCommand → QueryPlan

  66. def outputSet: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  67. def prettyJson: String

    Permalink
    Definition Classes
    TreeNode

  68. def printSchema(): Unit

    Permalink
    Definition Classes
    QueryPlan

  69. def producedAttributes: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  70. def references: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  71. def refresh(): Unit

    Permalink
    Definition Classes
    LogicalPlan

  72. def resolve(nameParts: Seq[String], input: Seq[Attribute], resolver: Resolver): Option[NamedExpression]

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan

  73. def resolve(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]

    Permalink
    Definition Classes
    LogicalPlan

  74. def resolve(schema: StructType, resolver: Resolver): Seq[Attribute]

    Permalink
    Definition Classes
    LogicalPlan

  75. def resolveChildren(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]

    Permalink
    Definition Classes
    LogicalPlan

  76. def resolveExpressions(r: PartialFunction[Expression, Expression]): LogicalPlan

    Permalink
    Definition Classes
    LogicalPlan

  77. def resolveOperators(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    LogicalPlan

  78. def resolveQuoted(name: String, resolver: Resolver): Option[NamedExpression]

    Permalink
    Definition Classes
    LogicalPlan

  79. lazy val resolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan

  80. def run(sparkSession: SparkSession): Seq[Row]

    Permalink
    Definition Classes
    CreateTableCommand → RunnableCommand

  81. def sameResult(plan: LogicalPlan): Boolean

    Permalink
    Definition Classes
    QueryPlan

  82. lazy val schema: StructType

    Permalink
    Definition Classes
    QueryPlan

  83. def schemaString: String

    Permalink
    Definition Classes
    QueryPlan

  84. def simpleString: String

    Permalink
    Definition Classes
    QueryPlan → TreeNode

  85. def statePrefix: String

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan → QueryPlan

  86. def statistics: Statistics

    Permalink
    Definition Classes
    LogicalPlan

  87. def stringArgs: Iterator[Any]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  88. def subqueries: Seq[LogicalPlan]

    Permalink
    Definition Classes
    QueryPlan

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

    Permalink
    Definition Classes
    AnyRef

  90. val table: CatalogTable

    Permalink

  91. def toJSON: String

    Permalink
    Definition Classes
    TreeNode

  92. def toString(): String

    Permalink
    Definition Classes
    TreeNode → AnyRef → Any

  93. def transform(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  94. def transformAllExpressions(rule: PartialFunction[Expression, Expression]): CreateTableCommand.this.type

    Permalink
    Definition Classes
    QueryPlan

  95. def transformChildren(rule: PartialFunction[LogicalPlan, LogicalPlan], nextOperation: (LogicalPlan, PartialFunction[LogicalPlan, LogicalPlan]) ⇒ LogicalPlan): LogicalPlan

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  96. def transformDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  97. def transformExpressions(rule: PartialFunction[Expression, Expression]): CreateTableCommand.this.type

    Permalink
    Definition Classes
    QueryPlan

  98. def transformExpressionsDown(rule: PartialFunction[Expression, Expression]): CreateTableCommand.this.type

    Permalink
    Definition Classes
    QueryPlan

  99. def transformExpressionsUp(rule: PartialFunction[Expression, Expression]): CreateTableCommand.this.type

    Permalink
    Definition Classes
    QueryPlan

  100. def transformUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  101. def treeString(verbose: Boolean): String

    Permalink
    Definition Classes
    TreeNode

  102. def treeString: String

    Permalink
    Definition Classes
    TreeNode

  103. def validConstraints: Set[Expression]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan

  104. def verboseString: String

    Permalink
    Definition Classes
    QueryPlan → TreeNode

  105. final def wait(): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

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

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  107. final def wait(arg0: Long): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  108. def withNewChildren(newChildren: Seq[LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

Inherited from Serializable

Inherited from Serializable

Inherited from RunnableCommand

Inherited from Command

Inherited from LogicalPlan

Inherited from Logging

Inherited from QueryPlan[LogicalPlan]

Inherited from TreeNode[LogicalPlan]

Inherited from Product

Inherited from Equals

Inherited from AnyRef

Inherited from Any

Ungrouped