Class

org.apache.spark.sql.execution.command

CreateDataSourceTableAsSelectCommand

Related Doc: package command

Permalink

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
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)

    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. val bucketSpec: Option[BucketSpec]

    Permalink

  11. lazy val canonicalized: LogicalPlan

    Permalink
    Definition Classes
    LogicalPlan → QueryPlan

  12. final def children: Seq[LogicalPlan]

    Permalink
    Definition Classes
    RunnableCommand → TreeNode

  13. def childrenResolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan

  14. lazy val cleanArgs: Seq[Any]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan

  15. def clone(): AnyRef

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

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

    Permalink
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    TreeNode

  18. lazy val constraints: ExpressionSet

    Permalink
    Definition Classes
    QueryPlan

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

    Permalink
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    AnyRef

  21. final def expressions: Seq[Expression]

    Permalink
    Definition Classes
    QueryPlan

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

    Permalink
    Definition Classes
    TreeNode

  23. def finalize(): Unit

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

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

    Permalink
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    AnyRef → Any

  30. def getNodeNumbered(number: MutableInt): LogicalPlan

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

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

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan

  32. def hashCode(): Int

    Permalink
    Definition Classes
    TreeNode → AnyRef → Any

  33. def initializeLogIfNecessary(isInterpreter: Boolean): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  34. def innerChildren: Seq[LogicalPlan]

    Permalink
    Attributes
    protected
    Definition Classes
    CreateDataSourceTableAsSelectCommand → 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. val mode: SaveMode

    Permalink

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

    Permalink
    Definition Classes
    AnyRef

  60. def nodeName: String

    Permalink
    Definition Classes
    TreeNode

  61. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef

  62. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef

  63. def numberedTreeString: String

    Permalink
    Definition Classes
    TreeNode

  64. val options: Map[String, String]

    Permalink

  65. val origin: Origin

    Permalink
    Definition Classes
    TreeNode

  66. def otherCopyArgs: Seq[AnyRef]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  67. def output: Seq[Attribute]

    Permalink
    Definition Classes
    RunnableCommand → QueryPlan

  68. def outputSet: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  69. val partitionColumns: Array[String]

    Permalink

  70. def prettyJson: String

    Permalink
    Definition Classes
    TreeNode

  71. def printSchema(): Unit

    Permalink
    Definition Classes
    QueryPlan

  72. def producedAttributes: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  73. val provider: String

    Permalink

  74. val query: LogicalPlan

    Permalink

  75. def references: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  76. def refresh(): Unit

    Permalink
    Definition Classes
    LogicalPlan

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

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan

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

    Permalink
    Definition Classes
    LogicalPlan

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

    Permalink
    Definition Classes
    LogicalPlan

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

    Permalink
    Definition Classes
    LogicalPlan

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

    Permalink
    Definition Classes
    LogicalPlan

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

    Permalink
    Definition Classes
    LogicalPlan

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

    Permalink
    Definition Classes
    LogicalPlan

  84. lazy val resolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan

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

    Permalink
    Definition Classes
    CreateDataSourceTableAsSelectCommand → RunnableCommand

  86. def sameResult(plan: LogicalPlan): Boolean

    Permalink
    Definition Classes
    QueryPlan

  87. lazy val schema: StructType

    Permalink
    Definition Classes
    QueryPlan

  88. def schemaString: String

    Permalink
    Definition Classes
    QueryPlan

  89. def simpleString: String

    Permalink
    Definition Classes
    QueryPlan → TreeNode

  90. def statePrefix: String

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan → QueryPlan

  91. def statistics: Statistics

    Permalink
    Definition Classes
    LogicalPlan

  92. def stringArgs: Iterator[Any]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  93. def subqueries: Seq[LogicalPlan]

    Permalink
    Definition Classes
    QueryPlan

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

    Permalink
    Definition Classes
    AnyRef

  95. val tableIdent: TableIdentifier

    Permalink

  96. def toJSON: String

    Permalink
    Definition Classes
    TreeNode

  97. def toString(): String

    Permalink
    Definition Classes
    TreeNode → AnyRef → Any

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

    Permalink
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    QueryPlan

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

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    TreeNode

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

    Permalink
    Definition Classes
    QueryPlan

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

    Permalink
    Definition Classes
    QueryPlan

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

    Permalink
    Definition Classes
    QueryPlan

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

    Permalink
    Definition Classes
    TreeNode

  106. def treeString(verbose: Boolean): String

    Permalink
    Definition Classes
    TreeNode

  107. def treeString: String

    Permalink
    Definition Classes
    TreeNode

  108. def validConstraints: Set[Expression]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan

  109. def verboseString: String

    Permalink
    Definition Classes
    QueryPlan → TreeNode

  110. final def wait(): Unit

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

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

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

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

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

  113. 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