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], 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. TreeNode
  14. Product
  15. Equals
  16. AnyRef
  17. 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. 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 children: Seq[LogicalPlan]
    Definition Classes
    DataWritingCommand → Command → TreeNode
  9. def childrenResolved: Boolean
    Definition Classes
    LogicalPlan
  10. def clone(): LogicalPlan
    Definition Classes
    TreeNode → AnyRef
  11. def collect[B](pf: PartialFunction[LogicalPlan, B]): Seq[B]
    Definition Classes
    TreeNode
  12. def collectFirst[B](pf: PartialFunction[LogicalPlan, B]): Option[B]
    Definition Classes
    TreeNode
  13. def collectLeaves(): Seq[LogicalPlan]
    Definition Classes
    TreeNode
  14. def collectWithSubqueries[B](f: PartialFunction[LogicalPlan, B]): Seq[B]
    Definition Classes
    QueryPlan
  15. def conf: SQLConf
    Definition Classes
    QueryPlan
  16. lazy val constraints: ExpressionSet
    Definition Classes
    QueryPlanConstraints
  17. def constructIsNotNullConstraints(constraints: Set[Expression], output: Seq[Attribute]): Set[Expression]
    Definition Classes
    ConstraintHelper
  18. lazy val containsChild: Set[TreeNode[_]]
    Definition Classes
    TreeNode
  19. final def expressions: Seq[Expression]
    Definition Classes
    QueryPlan
  20. def fastEquals(other: TreeNode[_]): Boolean
    Definition Classes
    TreeNode
  21. def find(f: (LogicalPlan) ⇒ Boolean): Option[LogicalPlan]
    Definition Classes
    TreeNode
  22. def flatMap[A](f: (LogicalPlan) ⇒ TraversableOnce[A]): Seq[A]
    Definition Classes
    TreeNode
  23. def foreach(f: (LogicalPlan) ⇒ Unit): Unit
    Definition Classes
    TreeNode
  24. def foreachUp(f: (LogicalPlan) ⇒ Unit): Unit
    Definition Classes
    TreeNode
  25. def generateTreeString(depth: Int, lastChildren: Seq[Boolean], append: (String) ⇒ Unit, verbose: Boolean, prefix: String, addSuffix: Boolean, maxFields: Int, printNodeId: Boolean): Unit
    Definition Classes
    TreeNode
  26. def getTagValue[T](tag: TreeNodeTag[T]): Option[T]
    Definition Classes
    TreeNode
  27. def hashCode(): Int
    Definition Classes
    TreeNode → AnyRef → Any
  28. def inferAdditionalConstraints(constraints: Set[Expression]): Set[Expression]
    Definition Classes
    ConstraintHelper
  29. def innerChildren: Seq[QueryPlan[_]]
    Definition Classes
    QueryPlan → TreeNode
  30. def inputSet: AttributeSet
    Definition Classes
    QueryPlan
  31. final def invalidateStatsCache(): Unit
    Definition Classes
    LogicalPlanStats
  32. def isStreaming: Boolean
    Definition Classes
    LogicalPlan
  33. def makeCopy(newArgs: Array[AnyRef]): LogicalPlan
    Definition Classes
    TreeNode
  34. def map[A](f: (LogicalPlan) ⇒ A): Seq[A]
    Definition Classes
    TreeNode
  35. def mapChildren(f: (LogicalPlan) ⇒ LogicalPlan): LogicalPlan
    Definition Classes
    TreeNode
  36. def mapExpressions(f: (Expression) ⇒ Expression): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  37. def maxRows: Option[Long]
    Definition Classes
    LogicalPlan
  38. def maxRowsPerPartition: Option[Long]
    Definition Classes
    LogicalPlan
  39. lazy val metrics: Map[String, SQLMetric]
    Definition Classes
    DataWritingCommand
  40. final def missingInput: AttributeSet
    Definition Classes
    QueryPlan
  41. val mode: SaveMode
  42. def nodeName: String
    Definition Classes
    TreeNode
  43. def numberedTreeString: String
    Definition Classes
    TreeNode
  44. val origin: Origin
    Definition Classes
    TreeNode
  45. def output: Seq[Attribute]
    Definition Classes
    Command → QueryPlan
  46. val outputColumnNames: Seq[String]
  47. def outputColumns: Seq[Attribute]
    Definition Classes
    DataWritingCommand
  48. def outputOrdering: Seq[SortOrder]
    Definition Classes
    LogicalPlan
  49. lazy val outputSet: AttributeSet
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  50. def p(number: Int): LogicalPlan
    Definition Classes
    TreeNode
  51. def prettyJson: String
    Definition Classes
    TreeNode
  52. def printSchema(): Unit
    Definition Classes
    QueryPlan
  53. def producedAttributes: AttributeSet
    Definition Classes
    QueryPlan
  54. 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 FileFormatWriter.

    Definition Classes
    CreateDataSourceTableAsSelectCommandDataWritingCommand
  55. lazy val references: AttributeSet
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  56. def refresh(): Unit
    Definition Classes
    LogicalPlan
  57. def resolve(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  58. def resolve(schema: StructType, resolver: Resolver): Seq[Attribute]
    Definition Classes
    LogicalPlan
  59. def resolveChildren(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  60. def resolveExpressions(r: PartialFunction[Expression, Expression]): LogicalPlan
    Definition Classes
    AnalysisHelper
  61. def resolveOperators(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  62. def resolveOperatorsDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  63. def resolveOperatorsUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  64. def resolveQuoted(name: String, resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  65. lazy val resolved: Boolean
    Definition Classes
    LogicalPlan
  66. def run(sparkSession: SparkSession, child: SparkPlan): Seq[Row]
  67. def sameOutput(other: LogicalPlan): Boolean
    Definition Classes
    LogicalPlan
  68. final def sameResult(other: LogicalPlan): Boolean
    Definition Classes
    QueryPlan
  69. lazy val schema: StructType
    Definition Classes
    QueryPlan
  70. def schemaString: String
    Definition Classes
    QueryPlan
  71. final def semanticHash(): Int
    Definition Classes
    QueryPlan
  72. def setTagValue[T](tag: TreeNodeTag[T], value: T): Unit
    Definition Classes
    TreeNode
  73. def simpleString(maxFields: Int): String
    Definition Classes
    QueryPlan → TreeNode
  74. def simpleStringWithNodeId(): String
    Definition Classes
    QueryPlan → TreeNode
  75. def stats: Statistics
    Definition Classes
    Command → LogicalPlanStats
  76. def subqueries: Seq[LogicalPlan]
    Definition Classes
    QueryPlan
  77. def subqueriesAll: Seq[LogicalPlan]
    Definition Classes
    QueryPlan
  78. val table: CatalogTable
  79. def toJSON: String
    Definition Classes
    TreeNode
  80. def toString(): String
    Definition Classes
    TreeNode → AnyRef → Any
  81. def transform(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  82. def transformAllExpressions(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    AnalysisHelper → QueryPlan
  83. def transformDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode
  84. def transformExpressions(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  85. def transformExpressionsDown(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  86. def transformExpressionsUp(rule: PartialFunction[Expression, Expression]): CreateDataSourceTableAsSelectCommand.this.type
    Definition Classes
    QueryPlan
  87. def transformUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode
  88. def treeString(append: (String) ⇒ Unit, verbose: Boolean, addSuffix: Boolean, maxFields: Int, printOperatorId: Boolean): Unit
    Definition Classes
    TreeNode
  89. final def treeString(verbose: Boolean, addSuffix: Boolean, maxFields: Int, printOperatorId: Boolean): String
    Definition Classes
    TreeNode
  90. final def treeString: String
    Definition Classes
    TreeNode
  91. def unsetTagValue[T](tag: TreeNodeTag[T]): Unit
    Definition Classes
    TreeNode
  92. def verboseString(maxFields: Int): String
    Definition Classes
    QueryPlan → TreeNode
  93. def verboseStringWithOperatorId(): String
    Definition Classes
    QueryPlan
  94. def verboseStringWithSuffix(maxFields: Int): String
    Definition Classes
    LogicalPlan → TreeNode
  95. def withNewChildren(newChildren: Seq[LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode