org.apache.spark.sql.execution.command

CreateDataSourceTableAsSelectCommand

case class CreateDataSourceTableAsSelectCommand(tableIdent: TableIdentifier, provider: String, partitionColumns: Array[String], bucketSpec: Option[BucketSpec], mode: SaveMode, options: Map[String, String], query: LogicalPlan) extends LogicalPlan with RunnableCommand with Product with Serializable

A command used to create a data source table using the result of a query.

Note: This is different from CreateTableAsSelectLogicalPlan. Please check the syntax for difference. This is not intended for temporary tables.

The syntax of using this command in SQL is:

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name
USING format OPTIONS ([option1_name "option1_value", option2_name "option2_value", ...])
AS SELECT ...
Linear Supertypes
Serializable, Serializable, RunnableCommand, Command, LogicalPlan, Logging, QueryPlan[LogicalPlan], TreeNode[LogicalPlan], Product, Equals, AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. CreateDataSourceTableAsSelectCommand
  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
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new CreateDataSourceTableAsSelectCommand(tableIdent: TableIdentifier, provider: String, partitionColumns: Array[String], bucketSpec: Option[BucketSpec], mode: SaveMode, options: Map[String, String], query: LogicalPlan)

Value Members

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

    Definition Classes
    AnyRef

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

    Definition Classes
    Any

  3. final def ##(): Int

    Definition Classes
    AnyRef → Any

  4. final def ==(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

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

    Definition Classes
    Any

  6. lazy val allAttributes: AttributeSeq

    Definition Classes
    QueryPlan

  7. def analyzed: Boolean

    Definition Classes
    LogicalPlan

  8. def apply(number: Int): LogicalPlan

    Definition Classes
    TreeNode

  9. def argString: String

    Definition Classes
    TreeNode

  10. def asCode: String

    Definition Classes
    TreeNode

  11. final def asInstanceOf[T0]: T0

    Definition Classes
    Any

  12. val bucketSpec: Option[BucketSpec]

  13. lazy val canonicalized: LogicalPlan

    Definition Classes
    LogicalPlan → QueryPlan

  14. def children: Seq[LogicalPlan]

    Definition Classes
    RunnableCommand → TreeNode

  15. def childrenResolved: Boolean

    Definition Classes
    LogicalPlan

  16. lazy val cleanArgs: Seq[Any]

    Attributes
    protected
    Definition Classes
    QueryPlan

  17. def clone(): AnyRef

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

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

    Definition Classes
    TreeNode

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

    Definition Classes
    TreeNode

  20. lazy val constraints: ExpressionSet

    Definition Classes
    QueryPlan

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

    Definition Classes
    TreeNode

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

    Definition Classes
    AnyRef

  23. final def expressions: Seq[Expression]

    Definition Classes
    QueryPlan

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

    Definition Classes
    TreeNode

  25. def finalize(): Unit

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

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

    Definition Classes
    TreeNode

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

    Definition Classes
    TreeNode

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

    Definition Classes
    TreeNode

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

    Definition Classes
    TreeNode

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

    Definition Classes
    TreeNode

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

    Definition Classes
    AnyRef → Any

  32. def getNodeNumbered(number: MutableInt): LogicalPlan

    Attributes
    protected
    Definition Classes
    TreeNode

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

    Attributes
    protected
    Definition Classes
    QueryPlan

  34. def hashCode(): Int

    Definition Classes
    TreeNode → AnyRef → Any

  35. def initializeLogIfNecessary(isInterpreter: Boolean): Unit

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    CreateDataSourceTableAsSelectCommand → QueryPlan → TreeNode

  37. def inputSet: AttributeSet

    Definition Classes
    QueryPlan

  38. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  39. def isStreaming: Boolean

    Definition Classes
    LogicalPlan

  40. def isTraceEnabled(): Boolean

    Attributes
    protected
    Definition Classes
    Logging

  41. def jsonFields: List[(String, JValue)]

    Attributes
    protected
    Definition Classes
    TreeNode

  42. def log: Logger

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

  49. def logName: String

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Definition Classes
    TreeNode

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

    Definition Classes
    TreeNode

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

    Definition Classes
    TreeNode

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

    Attributes
    protected
    Definition Classes
    TreeNode

  58. def maxRows: Option[Long]

    Definition Classes
    LogicalPlan

  59. def missingInput: AttributeSet

    Definition Classes
    QueryPlan

  60. val mode: SaveMode

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

    Definition Classes
    AnyRef

  62. def nodeName: String

    Definition Classes
    TreeNode

  63. final def notify(): Unit

    Definition Classes
    AnyRef

  64. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  65. def numberedTreeString: String

    Definition Classes
    TreeNode

  66. val options: Map[String, String]

  67. val origin: Origin

    Definition Classes
    TreeNode

  68. def otherCopyArgs: Seq[AnyRef]

    Attributes
    protected
    Definition Classes
    TreeNode

  69. def output: Seq[Attribute]

    Definition Classes
    RunnableCommand → QueryPlan

  70. def outputSet: AttributeSet

    Definition Classes
    QueryPlan

  71. val partitionColumns: Array[String]

  72. def prettyJson: String

    Definition Classes
    TreeNode

  73. def printSchema(): Unit

    Definition Classes
    QueryPlan

  74. def producedAttributes: AttributeSet

    Definition Classes
    QueryPlan

  75. val provider: String

  76. val query: LogicalPlan

  77. def references: AttributeSet

    Definition Classes
    QueryPlan

  78. def refresh(): Unit

    Definition Classes
    LogicalPlan

  79. def resolve(nameParts: Seq[String], input: Seq[Attribute], resolver: (String, String) ⇒ Boolean): Option[NamedExpression]

    Attributes
    protected
    Definition Classes
    LogicalPlan

  80. def resolve(nameParts: Seq[String], resolver: (String, String) ⇒ Boolean): Option[NamedExpression]

    Definition Classes
    LogicalPlan

  81. def resolve(schema: StructType, resolver: (String, String) ⇒ Boolean): Seq[Attribute]

    Definition Classes
    LogicalPlan

  82. def resolveChildren(nameParts: Seq[String], resolver: (String, String) ⇒ Boolean): Option[NamedExpression]

    Definition Classes
    LogicalPlan

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

    Definition Classes
    LogicalPlan

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

    Definition Classes
    LogicalPlan

  85. def resolveQuoted(name: String, resolver: (String, String) ⇒ Boolean): Option[NamedExpression]

    Definition Classes
    LogicalPlan

  86. lazy val resolved: Boolean

    Definition Classes
    LogicalPlan

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

    Definition Classes
    CreateDataSourceTableAsSelectCommand → RunnableCommand

  88. def sameResult(plan: LogicalPlan): Boolean

    Definition Classes
    QueryPlan

  89. lazy val schema: StructType

    Definition Classes
    QueryPlan

  90. def schemaString: String

    Definition Classes
    QueryPlan

  91. def simpleString: String

    Definition Classes
    QueryPlan → TreeNode

  92. def statePrefix: String

    Attributes
    protected
    Definition Classes
    LogicalPlan → QueryPlan

  93. def statistics: Statistics

    Definition Classes
    LogicalPlan

  94. def stringArgs: Iterator[Any]

    Attributes
    protected
    Definition Classes
    TreeNode

  95. def subqueries: Seq[LogicalPlan]

    Definition Classes
    QueryPlan

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

    Definition Classes
    AnyRef

  97. val tableIdent: TableIdentifier

  98. def toJSON: String

    Definition Classes
    TreeNode

  99. def toString(): String

    Definition Classes
    TreeNode → AnyRef → Any

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

    Definition Classes
    TreeNode

  101. def transformAllExpressions(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type

    Definition Classes
    QueryPlan

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

    Attributes
    protected
    Definition Classes
    TreeNode

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

    Definition Classes
    TreeNode

  104. def transformExpressions(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type

    Definition Classes
    QueryPlan

  105. def transformExpressionsDown(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type

    Definition Classes
    QueryPlan

  106. def transformExpressionsUp(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type

    Definition Classes
    QueryPlan

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

    Definition Classes
    TreeNode

  108. def treeString(verbose: Boolean): String

    Definition Classes
    TreeNode

  109. def treeString: String

    Definition Classes
    TreeNode

  110. def validConstraints: Set[Expression]

    Attributes
    protected
    Definition Classes
    QueryPlan

  111. def verboseString: String

    Definition Classes
    QueryPlan → TreeNode

  112. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

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

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

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

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

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

    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