Packages

c

org.apache.spark.sql.execution.command

CreateTableLikeCommand

case class CreateTableLikeCommand(targetTable: TableIdentifier, sourceTable: TableIdentifier, fileFormat: CatalogStorageFormat, provider: Option[String], properties: Map[String, String] = Map.empty, ifNotExists: Boolean) extends LogicalPlan with LeafRunnableCommand with Product with Serializable

A command to create a table with the same definition of the given existing table. In the target table definition, the table comment is always empty but the column comments are identical to the ones defined in the source table.

The CatalogTable attributes copied from the source table are storage(inputFormat, outputFormat, serde, compressed, properties), schema, provider, partitionColumnNames, bucketSpec by default.

Use "CREATE TABLE t1 LIKE t2 USING file_format" to specify new provider for t1. For Hive compatibility, use "CREATE TABLE t1 LIKE t2 STORED AS hiveFormat" to specify new file storage format (inputFormat, outputFormat, serde) for t1.

The syntax of using this command in SQL is:

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name
LIKE [other_db_name.]existing_table_name
[USING provider |
 [
  [ROW FORMAT row_format]
  [STORED AS file_format] [WITH SERDEPROPERTIES (...)]
 ]
]
[locationSpec]
[TBLPROPERTIES (property_name=property_value, ...)]
Linear Supertypes
Serializable, LeafRunnableCommand, LeafLike[LogicalPlan], RunnableCommand, 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. CreateTableLikeCommand
  2. Serializable
  3. LeafRunnableCommand
  4. LeafLike
  5. RunnableCommand
  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 CreateTableLikeCommand(targetTable: TableIdentifier, sourceTable: TableIdentifier, fileFormat: CatalogStorageFormat, provider: Option[String], properties: Map[String, String] = Map.empty, ifNotExists: Boolean)

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. final lazy val canonicalized: LogicalPlan
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  12. final def children: Seq[LogicalPlan]
    Definition Classes
    LeafLike
  13. def childrenResolved: Boolean
    Definition Classes
    LogicalPlan
  14. def clone(): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode → AnyRef
  15. def collect[B](pf: PartialFunction[LogicalPlan, B]): Seq[B]
    Definition Classes
    TreeNode
  16. def collectFirst[B](pf: PartialFunction[LogicalPlan, B]): Option[B]
    Definition Classes
    TreeNode
  17. def collectLeaves(): Seq[LogicalPlan]
    Definition Classes
    TreeNode
  18. def collectWithSubqueries[B](f: PartialFunction[LogicalPlan, B]): Seq[B]
    Definition Classes
    QueryPlan
  19. def conf: SQLConf
    Definition Classes
    SQLConfHelper
  20. lazy val constraints: ExpressionSet
    Definition Classes
    QueryPlanConstraints
  21. def constructIsNotNullConstraints(constraints: ExpressionSet, output: Seq[Attribute]): ExpressionSet
    Definition Classes
    ConstraintHelper
  22. final def containsAllPatterns(patterns: TreePattern*): Boolean
    Definition Classes
    TreePatternBits
  23. final def containsAnyPattern(patterns: TreePattern*): Boolean
    Definition Classes
    TreePatternBits
  24. lazy val containsChild: Set[TreeNode[_]]
    Definition Classes
    TreeNode
  25. final def containsPattern(t: TreePattern): Boolean
    Definition Classes
    TreePatternBits
    Annotations
    @inline()
  26. def copyTagsFrom(other: LogicalPlan): Unit
    Definition Classes
    TreeNode
  27. lazy val deterministic: Boolean
    Definition Classes
    QueryPlan
  28. lazy val distinctKeys: Set[ExpressionSet]
    Definition Classes
    LogicalPlanDistinctKeys
  29. def doCanonicalize(): LogicalPlan
    Attributes
    protected
    Definition Classes
    QueryPlan
  30. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  31. def exists(f: (LogicalPlan) => Boolean): Boolean
    Definition Classes
    TreeNode
  32. final def expressions: Seq[Expression]
    Definition Classes
    QueryPlan
  33. def fastEquals(other: TreeNode[_]): Boolean
    Definition Classes
    TreeNode
  34. val fileFormat: CatalogStorageFormat
  35. def finalize(): Unit
    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.Throwable])
  36. def find(f: (LogicalPlan) => Boolean): Option[LogicalPlan]
    Definition Classes
    TreeNode
  37. def flatMap[A](f: (LogicalPlan) => TraversableOnce[A]): Seq[A]
    Definition Classes
    TreeNode
  38. def foreach(f: (LogicalPlan) => Unit): Unit
    Definition Classes
    TreeNode
  39. def foreachUp(f: (LogicalPlan) => Unit): Unit
    Definition Classes
    TreeNode
  40. def formattedNodeName: String
    Attributes
    protected
    Definition Classes
    QueryPlan
  41. 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
  42. final def getClass(): Class[_ <: AnyRef]
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  43. def getDefaultTreePatternBits: BitSet
    Attributes
    protected
    Definition Classes
    TreeNode
  44. def getTagValue[T](tag: TreeNodeTag[T]): Option[T]
    Definition Classes
    TreeNode
  45. def hashCode(): Int
    Definition Classes
    TreeNode → AnyRef → Any
  46. val ifNotExists: Boolean
  47. def inferAdditionalConstraints(constraints: ExpressionSet): ExpressionSet
    Definition Classes
    ConstraintHelper
  48. def initializeLogIfNecessary(isInterpreter: Boolean, silent: Boolean): Boolean
    Attributes
    protected
    Definition Classes
    Logging
  49. def initializeLogIfNecessary(isInterpreter: Boolean): Unit
    Attributes
    protected
    Definition Classes
    Logging
  50. def innerChildren: Seq[QueryPlan[_]]
    Definition Classes
    QueryPlan → TreeNode
  51. def inputSet: AttributeSet
    Definition Classes
    QueryPlan
  52. final def invalidateStatsCache(): Unit
    Definition Classes
    LogicalPlanStats
  53. def isCanonicalizedPlan: Boolean
    Attributes
    protected
    Definition Classes
    QueryPlan
  54. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  55. def isRuleIneffective(ruleId: RuleId): Boolean
    Attributes
    protected
    Definition Classes
    TreeNode
  56. def isStreaming: Boolean
    Definition Classes
    LogicalPlan
  57. def isTraceEnabled(): Boolean
    Attributes
    protected
    Definition Classes
    Logging
  58. def jsonFields: List[JField]
    Attributes
    protected
    Definition Classes
    TreeNode
  59. final def legacyWithNewChildren(newChildren: Seq[LogicalPlan]): LogicalPlan
    Attributes
    protected
    Definition Classes
    TreeNode
  60. def log: Logger
    Attributes
    protected
    Definition Classes
    Logging
  61. def logDebug(msg: => String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  62. def logDebug(msg: => String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  63. def logError(msg: => String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  64. def logError(msg: => String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  65. def logInfo(msg: => String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  66. def logInfo(msg: => String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  67. def logName: String
    Attributes
    protected
    Definition Classes
    Logging
  68. def logTrace(msg: => String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  69. def logTrace(msg: => String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  70. def logWarning(msg: => String, throwable: Throwable): Unit
    Attributes
    protected
    Definition Classes
    Logging
  71. def logWarning(msg: => String): Unit
    Attributes
    protected
    Definition Classes
    Logging
  72. def makeCopy(newArgs: Array[AnyRef]): LogicalPlan
    Definition Classes
    TreeNode
  73. def map[A](f: (LogicalPlan) => A): Seq[A]
    Definition Classes
    TreeNode
  74. final def mapChildren(f: (LogicalPlan) => LogicalPlan): LogicalPlan
    Definition Classes
    LeafLike
  75. def mapExpressions(f: (Expression) => Expression): CreateTableLikeCommand.this.type
    Definition Classes
    QueryPlan
  76. def mapProductIterator[B](f: (Any) => B)(implicit arg0: ClassTag[B]): Array[B]
    Attributes
    protected
    Definition Classes
    TreeNode
  77. def markRuleAsIneffective(ruleId: RuleId): Unit
    Attributes
    protected
    Definition Classes
    TreeNode
  78. def maxRows: Option[Long]
    Definition Classes
    LogicalPlan
  79. def maxRowsPerPartition: Option[Long]
    Definition Classes
    LogicalPlan
  80. def metadataOutput: Seq[Attribute]
    Definition Classes
    LogicalPlan
  81. lazy val metrics: Map[String, SQLMetric]
    Definition Classes
    RunnableCommand
  82. final def missingInput: AttributeSet
    Definition Classes
    QueryPlan
  83. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  84. def nodeName: String
    Definition Classes
    TreeNode
  85. final val nodePatterns: Seq[TreePattern]
    Definition Classes
    Command → TreeNode
  86. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  87. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  88. def numberedTreeString: String
    Definition Classes
    TreeNode
  89. val origin: Origin
    Definition Classes
    TreeNode
  90. def otherCopyArgs: Seq[AnyRef]
    Attributes
    protected
    Definition Classes
    TreeNode
  91. def output: Seq[Attribute]
    Definition Classes
    Command → QueryPlan
  92. def outputOrdering: Seq[SortOrder]
    Definition Classes
    LogicalPlan
  93. lazy val outputSet: AttributeSet
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  94. def p(number: Int): LogicalPlan
    Definition Classes
    TreeNode
  95. def prettyJson: String
    Definition Classes
    TreeNode
  96. def printSchema(): Unit
    Definition Classes
    QueryPlan
  97. def producedAttributes: AttributeSet
    Definition Classes
    Command → QueryPlan
  98. def productElementNames: Iterator[String]
    Definition Classes
    Product
  99. val properties: Map[String, String]
  100. val provider: Option[String]
  101. lazy val references: AttributeSet
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  102. def refresh(): Unit
    Definition Classes
    LogicalPlan
  103. def resolve(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  104. def resolve(schema: StructType, resolver: Resolver): Seq[Attribute]
    Definition Classes
    LogicalPlan
  105. def resolveChildren(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  106. def resolveExpressions(r: PartialFunction[Expression, Expression]): LogicalPlan
    Definition Classes
    AnalysisHelper
  107. def resolveExpressionsWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): LogicalPlan
    Definition Classes
    AnalysisHelper
  108. def resolveOperators(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  109. def resolveOperatorsDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  110. def resolveOperatorsDownWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  111. def resolveOperatorsUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  112. def resolveOperatorsUpWithNewOutput(rule: PartialFunction[LogicalPlan, (LogicalPlan, Seq[(Attribute, Attribute)])]): LogicalPlan
    Definition Classes
    AnalysisHelper
  113. def resolveOperatorsUpWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  114. def resolveOperatorsWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper
  115. def resolveQuoted(name: String, resolver: Resolver): Option[NamedExpression]
    Definition Classes
    LogicalPlan
  116. lazy val resolved: Boolean
    Definition Classes
    LogicalPlan
  117. def rewriteAttrs(attrMap: AttributeMap[Attribute]): LogicalPlan
    Definition Classes
    QueryPlan
  118. def run(sparkSession: SparkSession): Seq[Row]
    Definition Classes
    CreateTableLikeCommand → RunnableCommand
  119. def sameOutput(other: LogicalPlan): Boolean
    Definition Classes
    LogicalPlan
  120. final def sameResult(other: LogicalPlan): Boolean
    Definition Classes
    QueryPlan
  121. lazy val schema: StructType
    Definition Classes
    QueryPlan
  122. def schemaString: String
    Definition Classes
    QueryPlan
  123. final def semanticHash(): Int
    Definition Classes
    QueryPlan
  124. def setTagValue[T](tag: TreeNodeTag[T], value: T): Unit
    Definition Classes
    TreeNode
  125. def simpleString(maxFields: Int): String
    Definition Classes
    QueryPlan → TreeNode
  126. def simpleStringWithNodeId(): String
    Definition Classes
    QueryPlan → TreeNode
  127. val sourceTable: TableIdentifier
  128. def statePrefix: String
    Attributes
    protected
    Definition Classes
    LogicalPlan → QueryPlan
  129. def stats: Statistics
    Definition Classes
    Command → LogicalPlanStats
  130. val statsCache: Option[Statistics]
    Attributes
    protected
    Definition Classes
    LogicalPlanStats
  131. def stringArgs: Iterator[Any]
    Attributes
    protected
    Definition Classes
    TreeNode
  132. lazy val subqueries: Seq[LogicalPlan]
    Definition Classes
    QueryPlan
    Annotations
    @transient()
  133. def subqueriesAll: Seq[LogicalPlan]
    Definition Classes
    QueryPlan
  134. final def synchronized[T0](arg0: => T0): T0
    Definition Classes
    AnyRef
  135. val targetTable: TableIdentifier
  136. def toJSON: String
    Definition Classes
    TreeNode
  137. def toString(): String
    Definition Classes
    TreeNode → AnyRef → Any
  138. def transform(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  139. def transformAllExpressions(rule: PartialFunction[Expression, Expression]): CreateTableLikeCommand.this.type
    Definition Classes
    QueryPlan
  140. def transformAllExpressionsWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): CreateTableLikeCommand.this.type
    Definition Classes
    AnalysisHelper → QueryPlan
  141. def transformDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  142. def transformDownWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode
  143. def transformDownWithSubqueries(f: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    QueryPlan
  144. def transformDownWithSubqueriesAndPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(f: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    QueryPlan
  145. def transformExpressions(rule: PartialFunction[Expression, Expression]): CreateTableLikeCommand.this.type
    Definition Classes
    QueryPlan
  146. def transformExpressionsDown(rule: PartialFunction[Expression, Expression]): CreateTableLikeCommand.this.type
    Definition Classes
    QueryPlan
  147. def transformExpressionsDownWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): CreateTableLikeCommand.this.type
    Definition Classes
    QueryPlan
  148. def transformExpressionsUp(rule: PartialFunction[Expression, Expression]): CreateTableLikeCommand.this.type
    Definition Classes
    QueryPlan
  149. def transformExpressionsUpWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): CreateTableLikeCommand.this.type
    Definition Classes
    QueryPlan
  150. def transformExpressionsWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[Expression, Expression]): CreateTableLikeCommand.this.type
    Definition Classes
    QueryPlan
  151. def transformUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  152. def transformUpWithBeforeAndAfterRuleOnChildren(cond: (LogicalPlan) => Boolean, ruleId: RuleId)(rule: PartialFunction[(LogicalPlan, LogicalPlan), LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  153. def transformUpWithNewOutput(rule: PartialFunction[LogicalPlan, (LogicalPlan, Seq[(Attribute, Attribute)])], skipCond: (LogicalPlan) => Boolean, canGetOutput: (LogicalPlan) => Boolean): LogicalPlan
    Definition Classes
    AnalysisHelper → QueryPlan
  154. def transformUpWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    AnalysisHelper → TreeNode
  155. def transformUpWithSubqueries(f: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    QueryPlan
  156. def transformWithPruning(cond: (TreePatternBits) => Boolean, ruleId: RuleId)(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  157. def transformWithSubqueries(f: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan
    Definition Classes
    QueryPlan
  158. lazy val treePatternBits: BitSet
    Definition Classes
    QueryPlan → TreeNode → TreePatternBits
  159. def treeString(append: (String) => Unit, verbose: Boolean, addSuffix: Boolean, maxFields: Int, printOperatorId: Boolean): Unit
    Definition Classes
    TreeNode
  160. final def treeString(verbose: Boolean, addSuffix: Boolean, maxFields: Int, printOperatorId: Boolean): String
    Definition Classes
    TreeNode
  161. final def treeString: String
    Definition Classes
    TreeNode
  162. def unsetTagValue[T](tag: TreeNodeTag[T]): Unit
    Definition Classes
    TreeNode
  163. def updateOuterReferencesInSubquery(plan: LogicalPlan, attrMap: AttributeMap[Attribute]): LogicalPlan
    Definition Classes
    AnalysisHelper → QueryPlan
  164. lazy val validConstraints: ExpressionSet
    Attributes
    protected
    Definition Classes
    QueryPlanConstraints
  165. def verboseString(maxFields: Int): String
    Definition Classes
    QueryPlan → TreeNode
  166. def verboseStringWithOperatorId(): String
    Definition Classes
    QueryPlan
  167. def verboseStringWithSuffix(maxFields: Int): String
    Definition Classes
    LogicalPlan → TreeNode
  168. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  169. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException])
  170. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws(classOf[java.lang.InterruptedException]) @native()
  171. final def withNewChildren(newChildren: Seq[LogicalPlan]): LogicalPlan
    Definition Classes
    TreeNode
  172. final def withNewChildrenInternal(newChildren: IndexedSeq[LogicalPlan]): LogicalPlan
    Definition Classes
    LeafLike

Inherited from Serializable

Inherited from LeafRunnableCommand

Inherited from LeafLike[LogicalPlan]

Inherited from RunnableCommand

Inherited from Command

Inherited from LogicalPlan

Inherited from Logging

Inherited from QueryPlanConstraints

Inherited from ConstraintHelper

Inherited from LogicalPlanDistinctKeys

Inherited from LogicalPlanStats

Inherited from AnalysisHelper

Inherited from QueryPlan[LogicalPlan]

Inherited from SQLConfHelper

Inherited from TreeNode[LogicalPlan]

Inherited from TreePatternBits

Inherited from Product

Inherited from Equals

Inherited from AnyRef

Inherited from Any

Ungrouped