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, DataWritingCommand, UnaryCommand, UnaryLike[LogicalPlan], Command, LogicalPlan, Logging, QueryPlanConstraints, ConstraintHelper, LogicalPlanDistinctKeys, LogicalPlanStats, AnalysisHelper, QueryPlan[LogicalPlan], SQLConfHelper, TreeNode[LogicalPlan], TreePatternBits, Product, Equals, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. CreateDataSourceTableAsSelectCommand
  2. Serializable
  3. DataWritingCommand
  4. UnaryCommand
  5. UnaryLike
  6. Command
  7. LogicalPlan
  8. Logging
  9. QueryPlanConstraints
  10. ConstraintHelper
  11. LogicalPlanDistinctKeys
  12. LogicalPlanStats
  13. AnalysisHelper
  14. QueryPlan
  15. SQLConfHelper
  16. TreeNode
  17. TreePatternBits
  18. Product
  19. Equals
  20. AnyRef
  21. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. Protected

Instance Constructors

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

Value Members

  1. lazy val allAttributes: AttributeSeq
    Definition Classes
    QueryPlan
  2. def analyzed: Boolean
    Definition Classes
    AnalysisHelper
  3. def apply(number: Int): TreeNode[_]
    Definition Classes
    TreeNode
  4. def argString(maxFields: Int): String
    Definition Classes
    TreeNode
  5. def asCode: String
    Definition Classes
    TreeNode
  6. def basicWriteJobStatsTracker(hadoopConf: Configuration): BasicWriteJobStatsTracker
    Definition Classes
    DataWritingCommand
  7. final lazy val canonicalized: LogicalPlan
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  8. final def child: LogicalPlan
    Definition Classes
    DataWritingCommand → UnaryLike
  9. final lazy val children: Seq[LogicalPlan]
    Definition Classes
    UnaryLike
    Annotations
    @transient()
  10. def childrenResolved: Boolean
    Definition Classes
    LogicalPlan
  11. def clone(): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode → AnyRef
  12. def collect[B](pf: PartialFunction[LogicalPlan, B]): Seq[B]
    Definition Classes
    TreeNode
  13. def collectFirst[B](pf: PartialFunction[LogicalPlan, B]): Option[B]
    Definition Classes
    TreeNode
  14. def collectLeaves(): Seq[LogicalPlan]
    Definition Classes
    TreeNode
  15. def collectWithSubqueries[B](f: PartialFunction[LogicalPlan, B]): Seq[B]
    Definition Classes
    QueryPlan
  16. def conf: SQLConf
    Definition Classes
    SQLConfHelper
  17. lazy val constraints: ExpressionSet
    Definition Classes
    QueryPlanConstraints
  18. def constructIsNotNullConstraints(constraints: ExpressionSet, output: Seq[Attribute]): ExpressionSet
    Definition Classes
    ConstraintHelper
  19. final def containsAllPatterns(patterns: TreePattern*): Boolean
    Definition Classes
    TreePatternBits
  20. final def containsAnyPattern(patterns: TreePattern*): Boolean
    Definition Classes
    TreePatternBits
  21. lazy val containsChild: Set[TreeNode[_]]
    Definition Classes
    TreeNode
  22. final def containsPattern(t: TreePattern): Boolean
    Definition Classes
    TreePatternBits
    Annotations
    @inline()
  23. def copyTagsFrom(other: LogicalPlan): Unit
    Definition Classes
    TreeNode
  24. lazy val deterministic: Boolean
    Definition Classes
    QueryPlan
  25. lazy val distinctKeys: Set[ExpressionSet]
    Definition Classes
    LogicalPlanDistinctKeys
  26. def exists(f: (LogicalPlan) => Boolean): Boolean
    Definition Classes
    TreeNode
  27. final def expressions: Seq[Expression]
    Definition Classes
    QueryPlan
  28. def fastEquals(other: TreeNode[_]): Boolean
    Definition Classes
    TreeNode
  29. def find(f: (LogicalPlan) => Boolean): Option[LogicalPlan]
    Definition Classes
    TreeNode
  30. def flatMap[A](f: (LogicalPlan) => TraversableOnce[A]): Seq[A]
    Definition Classes
    TreeNode
  31. def foreach(f: (LogicalPlan) => Unit): Unit
    Definition Classes
    TreeNode
  32. def foreachUp(f: (LogicalPlan) => Unit): Unit
    Definition Classes
    TreeNode
  33. 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
  34. def getTagValue[T](tag: TreeNodeTag[T]): Option[T]
    Definition Classes
    TreeNode
  35. def hashCode(): Int
    Definition Classes
    TreeNode → AnyRef → Any
  36. def inferAdditionalConstraints(constraints: ExpressionSet): ExpressionSet
    Definition Classes
    ConstraintHelper
  37. def innerChildren: Seq[QueryPlan[_]]
    Definition Classes
    QueryPlan → TreeNode
  38. def inputSet: AttributeSet
    Definition Classes
    QueryPlan
  39. final def invalidateStatsCache(): Unit
    Definition Classes
    LogicalPlanStats
  40. def isStreaming: Boolean
    Definition Classes
    LogicalPlan
  41. def makeCopy(newArgs: Array[AnyRef]): LogicalPlan
    Definition Classes
    TreeNode
  42. def map[A](f: (LogicalPlan) => A): Seq[A]
    Definition Classes
    TreeNode
  43. final def mapChildren(f: (LogicalPlan) => LogicalPlan): LogicalPlan
    Definition Classes
    UnaryLike
  44. def mapExpressions(f: (Expression) => Expression): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  45. def maxRows: Option[Long]
    Definition Classes
    LogicalPlan
  46. def maxRowsPerPartition: Option[Long]
    Definition Classes
    LogicalPlan
  47. def metadataOutput: Seq[Attribute]
    Definition Classes
    LogicalPlan
  48. lazy val metrics: Map[String, SQLMetric]
    Definition Classes
    DataWritingCommand
  49. final def missingInput: AttributeSet
    Definition Classes
    QueryPlan
  50. val mode: SaveMode
  51. def nodeName: String
    Definition Classes
    TreeNode
  52. final val nodePatterns: Seq[TreePattern]
    Definition Classes
    Command → TreeNode
  53. def numberedTreeString: String
    Definition Classes
    TreeNode
  54. val origin: Origin
    Definition Classes
    TreeNode
  55. def output: Seq[Attribute]
    Definition Classes
    Command → QueryPlan
  56. val outputColumnNames: Seq[String]
  57. def outputColumns: Seq[Attribute]
    Definition Classes
    DataWritingCommand
  58. def outputOrdering: Seq[SortOrder]
    Definition Classes
    LogicalPlan
  59. lazy val outputSet: AttributeSet
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  60. def p(number: Int): LogicalPlan
    Definition Classes
    TreeNode
  61. def prettyJson: String
    Definition Classes
    TreeNode
  62. def printSchema(): Unit
    Definition Classes
    QueryPlan
  63. def producedAttributes: AttributeSet
    Definition Classes
    Command → QueryPlan
  64. def productElementNames: Iterator[String]
    Definition Classes
    Product
  65. 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
    CreateDataSourceTableAsSelectCommandDataWritingCommand
  66. lazy val references: AttributeSet
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  67. def refresh(): Unit
    Definition Classes
    LogicalPlan
  68. def resolve(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  69. def resolve(schema: StructType, resolver: Resolver): Seq[Attribute]
    Definition Classes
    LogicalPlan
  70. def resolveChildren(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  71. def resolveExpressions(r: PartialFunction[Expression, Expression]): LogicalPlan
    Definition Classes
    AnalysisHelper
  72. def resolveExpressionsWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): LogicalPlan
    Definition Classes
    AnalysisHelper
  73. def resolveOperators(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  74. def resolveOperatorsDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  75. def resolveOperatorsDownWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  76. def resolveOperatorsUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  77. def resolveOperatorsUpWithNewOutput(rule: PartialFunction[LogicalPlan, (LogicalPlan, Seq[(Attribute, Attribute)])]): LogicalPlan
    Definition Classes
    AnalysisHelper
  78. def resolveOperatorsUpWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  79. def resolveOperatorsWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  80. def resolveQuoted(name: String, resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  81. lazy val resolved: Boolean
    Definition Classes
    LogicalPlan
  82. def rewriteAttrs(attrMap: AttributeMap[Attribute]): LogicalPlan
    Definition Classes
    QueryPlan
  83. def run(sparkSession: SparkSession, child: SparkPlan): Seq[Row]
  84. def sameOutput(other: LogicalPlan): Boolean
    Definition Classes
    LogicalPlan
  85. final def sameResult(other: LogicalPlan): Boolean
    Definition Classes
    QueryPlan
  86. lazy val schema: StructType
    Definition Classes
    QueryPlan
  87. def schemaString: String
    Definition Classes
    QueryPlan
  88. final def semanticHash(): Int
    Definition Classes
    QueryPlan
  89. def setTagValue[T](tag: TreeNodeTag[T], value: T): Unit
    Definition Classes
    TreeNode
  90. def simpleString(maxFields: Int): String
    Definition Classes
    QueryPlan → TreeNode
  91. def simpleStringWithNodeId(): String
    Definition Classes
    QueryPlan → TreeNode
  92. def stats: Statistics
    Definition Classes
    Command → LogicalPlanStats
  93. lazy val subqueries: Seq[LogicalPlan]
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  94. def subqueriesAll: Seq[LogicalPlan]
    Definition Classes
    QueryPlan
  95. val table: CatalogTable
  96. def toJSON: String
    Definition Classes
    TreeNode
  97. def toString(): String
    Definition Classes
    TreeNode → AnyRef → Any
  98. def transform(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  99. def transformAllExpressions(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  100. def transformAllExpressionsWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    AnalysisHelper → QueryPlan
  101. def transformDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  102. def transformDownWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode
  103. def transformDownWithSubqueries(f: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    QueryPlan
  104. def transformDownWithSubqueriesAndPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(f: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    QueryPlan
  105. def transformExpressions(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  106. def transformExpressionsDown(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  107. def transformExpressionsDownWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  108. def transformExpressionsUp(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  109. def transformExpressionsUpWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  110. def transformExpressionsWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  111. def transformUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  112. def transformUpWithBeforeAndAfterRuleOnChildren(cond: (LogicalPlan) => Boolean, ruleId: RuleId)(rule: PartialFunction[(LogicalPlan, LogicalPlan), LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  113. def transformUpWithNewOutput(rule: PartialFunction[LogicalPlan, (LogicalPlan, Seq[(Attribute, Attribute)])], skipCond: (LogicalPlan) => Boolean, canGetOutput: (LogicalPlan) => Boolean): LogicalPlan
    Definition Classes
    AnalysisHelper → QueryPlan
  114. def transformUpWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode
  115. def transformUpWithSubqueries(f: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    QueryPlan
  116. def transformWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  117. def transformWithSubqueries(f: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    QueryPlan
  118. lazy val treePatternBits: BitSet
    Definition Classes
    QueryPlan → TreeNode → TreePatternBits
  119. def treeString(append: (String) => Unit, verbose: Boolean, addSuffix: Boolean, maxFields: Int, printOperatorId: Boolean): Unit
    Definition Classes
    TreeNode
  120. final def treeString(verbose: Boolean, addSuffix: Boolean, maxFields: Int, printOperatorId: Boolean): String
    Definition Classes
    TreeNode
  121. final def treeString: String
    Definition Classes
    TreeNode
  122. def unsetTagValue[T](tag: TreeNodeTag[T]): Unit
    Definition Classes
    TreeNode
  123. def updateOuterReferencesInSubquery(plan: LogicalPlan, attrMap: AttributeMap[Attribute]): LogicalPlan
    Definition Classes
    AnalysisHelper → QueryPlan
  124. def verboseString(maxFields: Int): String
    Definition Classes
    QueryPlan → TreeNode
  125. def verboseStringWithOperatorId(): String
    Definition Classes
    QueryPlan
  126. def verboseStringWithSuffix(maxFields: Int): String
    Definition Classes
    LogicalPlan → TreeNode
  127. final def withNewChildren(newChildren: Seq[LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  128. final def withNewChildrenInternal(newChildren: IndexedSeq[LogicalPlan]): LogicalPlan
    Definition Classes
    UnaryLike