Packages

c

org.apache.spark.sql.execution.command

CreateDataSourceTableAsSelectCommand

case class CreateDataSourceTableAsSelectCommand(table: CatalogTable, mode: SaveMode, query: LogicalPlan, outputColumnNames: Seq[String]) extends LogicalPlan with DataWritingCommand with Product with Serializable

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

Note: This is different from CreateHiveTableAsSelectCommand. 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, DataWritingCommand, Command, LogicalPlan, Logging, QueryPlanConstraints, ConstraintHelper, LogicalPlanStats, AnalysisHelper, QueryPlan[LogicalPlan], SQLConfHelper, TreeNode[LogicalPlan], Product, Equals, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. CreateDataSourceTableAsSelectCommand
  2. Serializable
  3. Serializable
  4. DataWritingCommand
  5. Command
  6. LogicalPlan
  7. Logging
  8. QueryPlanConstraints
  9. ConstraintHelper
  10. LogicalPlanStats
  11. AnalysisHelper
  12. QueryPlan
  13. SQLConfHelper
  14. TreeNode
  15. Product
  16. Equals
  17. AnyRef
  18. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Instance Constructors

  1. new CreateDataSourceTableAsSelectCommand(table: CatalogTable, mode: SaveMode, query: LogicalPlan, outputColumnNames: Seq[String])

Value Members

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  4. lazy val allAttributes: AttributeSeq
    Definition Classes
    QueryPlan
  5. def analyzed: Boolean
    Definition Classes
    AnalysisHelper
  6. def apply(number: Int): TreeNode[_]
    Definition Classes
    TreeNode
  7. def argString(maxFields: Int): String
    Definition Classes
    TreeNode
  8. def asCode: String
    Definition Classes
    TreeNode
  9. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  10. def assertNotAnalysisRule(): Unit
    Attributes
    protected
    Definition Classes
    AnalysisHelper
  11. def basicWriteJobStatsTracker(hadoopConf: Configuration): BasicWriteJobStatsTracker
    Definition Classes
    DataWritingCommand
  12. final lazy val canonicalized: LogicalPlan
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  13. final def children: Seq[LogicalPlan]
    Definition Classes
    DataWritingCommand → Command → TreeNode
  14. def childrenResolved: Boolean
    Definition Classes
    LogicalPlan
  15. def clone(): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode → AnyRef
  16. def collect[B](pf: PartialFunction[LogicalPlan, B]): Seq[B]
    Definition Classes
    TreeNode
  17. def collectFirst[B](pf: PartialFunction[LogicalPlan, B]): Option[B]
    Definition Classes
    TreeNode
  18. def collectLeaves(): Seq[LogicalPlan]
    Definition Classes
    TreeNode
  19. def collectWithSubqueries[B](f: PartialFunction[LogicalPlan, B]): Seq[B]
    Definition Classes
    QueryPlan
  20. def conf: SQLConf
    Definition Classes
    SQLConfHelper
  21. lazy val constraints: ExpressionSet
    Definition Classes
    QueryPlanConstraints
  22. def constructIsNotNullConstraints(constraints: ExpressionSet, output: Seq[Attribute]): ExpressionSet
    Definition Classes
    ConstraintHelper
  23. lazy val containsChild: Set[TreeNode[_]]
    Definition Classes
    TreeNode
  24. def copyTagsFrom(other: LogicalPlan): Unit
    Definition Classes
    TreeNode
  25. def doCanonicalize(): LogicalPlan
    Attributes
    protected
    Definition Classes
    QueryPlan
  26. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  27. final def expressions: Seq[Expression]
    Definition Classes
    QueryPlan
  28. def fastEquals(other: TreeNode[_]): Boolean
    Definition Classes
    TreeNode
  29. def finalize(): Unit
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  30. def find(f: (LogicalPlan) ⇒ Boolean): Option[LogicalPlan]
    Definition Classes
    TreeNode
  31. def flatMap[A](f: (LogicalPlan) ⇒ TraversableOnce[A]): Seq[A]
    Definition Classes
    TreeNode
  32. def foreach(f: (LogicalPlan) ⇒ Unit): Unit
    Definition Classes
    TreeNode
  33. def foreachUp(f: (LogicalPlan) ⇒ Unit): Unit
    Definition Classes
    TreeNode
  34. def formattedNodeName: String
    Attributes
    protected
    Definition Classes
    QueryPlan
  35. def generateTreeString(depth: Int, lastChildren: Seq[Boolean], append: (String) ⇒ Unit, verbose: Boolean, prefix: String, addSuffix: Boolean, maxFields: Int, printNodeId: Boolean, indent: Int): Unit
    Definition Classes
    TreeNode
  36. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  37. def getTagValue[T](tag: TreeNodeTag[T]): Option[T]
    Definition Classes
    TreeNode
  38. def hashCode(): Int
    Definition Classes
    TreeNode → AnyRef → Any
  39. def inferAdditionalConstraints(constraints: ExpressionSet): ExpressionSet
    Definition Classes
    ConstraintHelper
  40. def initializeLogIfNecessary(isInterpreter: Boolean, silent: Boolean): Boolean
    Attributes
    protected
    Definition Classes
    Logging
  41. def initializeLogIfNecessary(isInterpreter: Boolean): Unit
    Attributes
    protected
    Definition Classes
    Logging
  42. def innerChildren: Seq[QueryPlan[_]]
    Definition Classes
    QueryPlan → TreeNode
  43. def inputSet: AttributeSet
    Definition Classes
    QueryPlan
  44. final def invalidateStatsCache(): Unit
    Definition Classes
    LogicalPlanStats
  45. def isCanonicalizedPlan: Boolean
    Attributes
    protected
    Definition Classes
    QueryPlan
  46. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  47. def isStreaming: Boolean
    Definition Classes
    LogicalPlan
  48. def isTraceEnabled(): Boolean
    Attributes
    protected
    Definition Classes
    Logging
  49. def jsonFields: List[JField]
    Attributes
    protected
    Definition Classes
    TreeNode
  50. def log: Logger
    Attributes
    protected
    Definition Classes
    Logging
  51. def logDebug(msg: ⇒ String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  52. def logDebug(msg: ⇒ String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  53. def logError(msg: ⇒ String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  54. def logError(msg: ⇒ String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  55. def logInfo(msg: ⇒ String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  56. def logInfo(msg: ⇒ String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  57. def logName: String
    Attributes
    protected
    Definition Classes
    Logging
  58. def logTrace(msg: ⇒ String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  59. def logTrace(msg: ⇒ String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  60. def logWarning(msg: ⇒ String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  61. def logWarning(msg: ⇒ String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  62. def makeCopy(newArgs: Array[AnyRef]): LogicalPlan
    Definition Classes
    TreeNode
  63. def map[A](f: (LogicalPlan) ⇒ A): Seq[A]
    Definition Classes
    TreeNode
  64. def mapChildren(f: (LogicalPlan) ⇒ LogicalPlan): LogicalPlan
    Definition Classes
    TreeNode
  65. def mapExpressions(f: (Expression) ⇒ Expression): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  66. def mapProductIterator[B](f: (Any) ⇒ B)(implicit arg0: ClassTag[B]): Array[B]
    Attributes
    protected
    Definition Classes
    TreeNode
  67. def maxRows: Option[Long]
    Definition Classes
    LogicalPlan
  68. def maxRowsPerPartition: Option[Long]
    Definition Classes
    LogicalPlan
  69. def metadataOutput: Seq[Attribute]
    Definition Classes
    LogicalPlan
  70. lazy val metrics: Map[String, SQLMetric]
    Definition Classes
    DataWritingCommand
  71. final def missingInput: AttributeSet
    Definition Classes
    QueryPlan
  72. val mode: SaveMode
  73. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  74. def nodeName: String
    Definition Classes
    TreeNode
  75. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  76. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  77. def numberedTreeString: String
    Definition Classes
    TreeNode
  78. val origin: Origin
    Definition Classes
    TreeNode
  79. def otherCopyArgs: Seq[AnyRef]
    Attributes
    protected
    Definition Classes
    TreeNode
  80. def output: Seq[Attribute]
    Definition Classes
    Command → QueryPlan
  81. val outputColumnNames: Seq[String]
    Definition Classes
    CreateDataSourceTableAsSelectCommand → DataWritingCommand
  82. def outputColumns: Seq[Attribute]
    Definition Classes
    DataWritingCommand
  83. def outputOrdering: Seq[SortOrder]
    Definition Classes
    LogicalPlan
  84. lazy val outputSet: AttributeSet
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  85. def p(number: Int): LogicalPlan
    Definition Classes
    TreeNode
  86. def prettyJson: String
    Definition Classes
    TreeNode
  87. def printSchema(): Unit
    Definition Classes
    QueryPlan
  88. def producedAttributes: AttributeSet
    Definition Classes
    QueryPlan
  89. val query: LogicalPlan

    The input query plan that produces the data to be written.

    The input query plan that produces the data to be written. IMPORTANT: the input query plan MUST be analyzed, so that we can carry its output columns to org.apache.spark.sql.execution.datasources.FileFormatWriter.

    Definition Classes
    CreateDataSourceTableAsSelectCommand → DataWritingCommand
  90. lazy val references: AttributeSet
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  91. def refresh(): Unit
    Definition Classes
    LogicalPlan
  92. def resolve(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  93. def resolve(schema: StructType, resolver: Resolver): Seq[Attribute]
    Definition Classes
    LogicalPlan
  94. def resolveChildren(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  95. def resolveExpressions(r: PartialFunction[Expression, Expression]): LogicalPlan
    Definition Classes
    AnalysisHelper
  96. def resolveOperators(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  97. def resolveOperatorsDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  98. def resolveOperatorsUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  99. def resolveOperatorsUpWithNewOutput(rule: PartialFunction[LogicalPlan, (LogicalPlan, Seq[(Attribute, Attribute)])]): LogicalPlan
    Definition Classes
    AnalysisHelper
  100. def resolveQuoted(name: String, resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  101. lazy val resolved: Boolean
    Definition Classes
    LogicalPlan
  102. def run(sparkSession: SparkSession, child: SparkPlan): Seq[Row]
    Definition Classes
    CreateDataSourceTableAsSelectCommand → DataWritingCommand
  103. def sameOutput(other: LogicalPlan): Boolean
    Definition Classes
    LogicalPlan
  104. final def sameResult(other: LogicalPlan): Boolean
    Definition Classes
    QueryPlan
  105. lazy val schema: StructType
    Definition Classes
    QueryPlan
  106. def schemaString: String
    Definition Classes
    QueryPlan
  107. final def semanticHash(): Int
    Definition Classes
    QueryPlan
  108. def setTagValue[T](tag: TreeNodeTag[T], value: T): Unit
    Definition Classes
    TreeNode
  109. def simpleString(maxFields: Int): String
    Definition Classes
    QueryPlan → TreeNode
  110. def simpleStringWithNodeId(): String
    Definition Classes
    QueryPlan → TreeNode
  111. def statePrefix: String
    Attributes
    protected
    Definition Classes
    LogicalPlan → QueryPlan
  112. def stats: Statistics
    Definition Classes
    Command → LogicalPlanStats
  113. val statsCache: Option[Statistics]
    Attributes
    protected
    Definition Classes
    LogicalPlanStats
  114. def stringArgs: Iterator[Any]
    Attributes
    protected
    Definition Classes
    TreeNode
  115. def subqueries: Seq[LogicalPlan]
    Definition Classes
    QueryPlan
  116. def subqueriesAll: Seq[LogicalPlan]
    Definition Classes
    QueryPlan
  117. final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
    AnyRef
  118. val table: CatalogTable
  119. def toJSON: String
    Definition Classes
    TreeNode
  120. def toString(): String
    Definition Classes
    TreeNode → AnyRef → Any
  121. def transform(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  122. def transformAllExpressions(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    AnalysisHelper → QueryPlan
  123. def transformDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode
  124. def transformExpressions(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  125. def transformExpressionsDown(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  126. def transformExpressionsUp(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  127. def transformUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode
  128. def transformUpWithNewOutput(rule: PartialFunction[LogicalPlan, (LogicalPlan, Seq[(Attribute, Attribute)])], skipCond: (LogicalPlan) ⇒ Boolean, canGetOutput: (LogicalPlan) ⇒ Boolean): LogicalPlan
    Definition Classes
    AnalysisHelper → QueryPlan
  129. def treeString(append: (String) ⇒ Unit, verbose: Boolean, addSuffix: Boolean, maxFields: Int, printOperatorId: Boolean): Unit
    Definition Classes
    TreeNode
  130. final def treeString(verbose: Boolean, addSuffix: Boolean, maxFields: Int, printOperatorId: Boolean): String
    Definition Classes
    TreeNode
  131. final def treeString: String
    Definition Classes
    TreeNode
  132. def unsetTagValue[T](tag: TreeNodeTag[T]): Unit
    Definition Classes
    TreeNode
  133. lazy val validConstraints: ExpressionSet
    Attributes
    protected
    Definition Classes
    QueryPlanConstraints
  134. def verboseString(maxFields: Int): String
    Definition Classes
    QueryPlan → TreeNode
  135. def verboseStringWithOperatorId(): String
    Definition Classes
    QueryPlan
  136. def verboseStringWithSuffix(maxFields: Int): String
    Definition Classes
    LogicalPlan → TreeNode
  137. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  138. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  139. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... ) @native()
  140. def withNewChildren(newChildren: Seq[LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode

Inherited from Serializable

Inherited from Serializable

Inherited from DataWritingCommand

Inherited from Command

Inherited from LogicalPlan

Inherited from Logging

Inherited from QueryPlanConstraints

Inherited from ConstraintHelper

Inherited from LogicalPlanStats

Inherited from AnalysisHelper

Inherited from QueryPlan[LogicalPlan]

Inherited from SQLConfHelper

Inherited from TreeNode[LogicalPlan]

Inherited from Product

Inherited from Equals

Inherited from AnyRef

Inherited from Any

Ungrouped