Class

org.apache.spark.sql.hive.execution

InsertIntoHiveTable

Related Doc: package execution

Permalink

case class InsertIntoHiveTable(table: CatalogTable, partition: Map[String, Option[String]], query: LogicalPlan, overwrite: Boolean, ifPartitionNotExists: Boolean) extends LeafNode with RunnableCommand with Product with Serializable

Command for writing data out to a Hive table.

This class is mostly a mess, for legacy reasons (since it evolved in organic ways and had to follow Hive's internal implementations closely, which itself was a mess too). Please don't blame Reynold for this! He was just moving code around!

In the future we should converge the write path for Hive with the normal data source write path, as defined in org.apache.spark.sql.execution.datasources.FileFormatWriter.

table

the metadata of the table.

partition

a map from the partition key to the partition value (optional). If the partition value is optional, dynamic partition insert will be performed. As an example, INSERT INTO tbl PARTITION (a=1, b=2) AS ... would have

Map('a' -> Some('1'), 'b' -> Some('2'))

and INSERT INTO tbl PARTITION (a=1, b) AS ... would have

Map('a' -> Some('1'), 'b' -> None)

.

query

the logical plan representing data to write to.

overwrite

overwrite existing table or partitions.

ifPartitionNotExists

If true, only write if the partition does not exist. Only valid for static partitions.

Source
InsertIntoHiveTable.scala
Linear Supertypes
Serializable, Serializable, RunnableCommand, Command, LeafNode, LogicalPlan, Logging, QueryPlan[LogicalPlan], TreeNode[LogicalPlan], Product, Equals, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. InsertIntoHiveTable
  2. Serializable
  3. Serializable
  4. RunnableCommand
  5. Command
  6. LeafNode
  7. LogicalPlan
  8. Logging
  9. QueryPlan
  10. TreeNode
  11. Product
  12. Equals
  13. AnyRef
  14. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Instance Constructors

  1. new InsertIntoHiveTable(table: CatalogTable, partition: Map[String, Option[String]], query: LogicalPlan, overwrite: Boolean, ifPartitionNotExists: Boolean)

    Permalink

    table

    the metadata of the table.

    partition

    a map from the partition key to the partition value (optional). If the partition value is optional, dynamic partition insert will be performed. As an example, INSERT INTO tbl PARTITION (a=1, b=2) AS ... would have

    Map('a' -> Some('1'), 'b' -> Some('2'))

    and INSERT INTO tbl PARTITION (a=1, b) AS ... would have

    Map('a' -> Some('1'), 'b' -> None)

    .

    query

    the logical plan representing data to write to.

    overwrite

    overwrite existing table or partitions.

    ifPartitionNotExists

    If true, only write if the partition does not exist. Only valid for static partitions.

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): TreeNode[_]

    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. lazy val canonicalized: LogicalPlan

    Permalink
    Definition Classes
    QueryPlan
  11. final def children: Seq[LogicalPlan]

    Permalink
    Definition Classes
    LeafNode → TreeNode
  12. def childrenResolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan
  13. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  14. def collect[B](pf: PartialFunction[LogicalPlan, B]): Seq[B]

    Permalink
    Definition Classes
    TreeNode
  15. def collectFirst[B](pf: PartialFunction[LogicalPlan, B]): Option[B]

    Permalink
    Definition Classes
    TreeNode
  16. def collectLeaves(): Seq[LogicalPlan]

    Permalink
    Definition Classes
    TreeNode
  17. def computeStats(conf: SQLConf): Statistics

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan
  18. lazy val constraints: ExpressionSet

    Permalink
    Definition Classes
    QueryPlan
  19. lazy val containsChild: Set[TreeNode[_]]

    Permalink
    Definition Classes
    TreeNode
  20. var createdTempDir: Option[Path]

    Permalink
  21. final def eq(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  22. final def expressions: Seq[Expression]

    Permalink
    Definition Classes
    QueryPlan
  23. def fastEquals(other: TreeNode[_]): Boolean

    Permalink
    Definition Classes
    TreeNode
  24. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  25. def find(f: (LogicalPlan) ⇒ Boolean): Option[LogicalPlan]

    Permalink
    Definition Classes
    TreeNode
  26. def flatMap[A](f: (LogicalPlan) ⇒ TraversableOnce[A]): Seq[A]

    Permalink
    Definition Classes
    TreeNode
  27. def foreach(f: (LogicalPlan) ⇒ Unit): Unit

    Permalink
    Definition Classes
    TreeNode
  28. def foreachUp(f: (LogicalPlan) ⇒ Unit): Unit

    Permalink
    Definition Classes
    TreeNode
  29. def generateTreeString(depth: Int, lastChildren: Seq[Boolean], builder: StringBuilder, verbose: Boolean, prefix: String, addSuffix: Boolean): StringBuilder

    Permalink
    Definition Classes
    TreeNode
  30. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any
  31. def getExtTmpPathRelTo(path: Path, hadoopConf: Configuration, stagingDir: String): Path

    Permalink
  32. def getExternalTmpPath(path: Path, hiveVersion: HiveVersion, hadoopConf: Configuration, stagingDir: String, scratchDir: String): Path

    Permalink
  33. def getRelevantConstraints(constraints: Set[Expression]): Set[Expression]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan
  34. def hashCode(): Int

    Permalink
    Definition Classes
    TreeNode → AnyRef → Any
  35. val ifPartitionNotExists: Boolean

    Permalink

    If true, only write if the partition does not exist.

    If true, only write if the partition does not exist. Only valid for static partitions.

  36. def initializeLogIfNecessary(isInterpreter: Boolean): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  37. def innerChildren: Seq[LogicalPlan]

    Permalink
    Attributes
    protected
    Definition Classes
    InsertIntoHiveTable → QueryPlan → TreeNode
  38. def inputSet: AttributeSet

    Permalink
    Definition Classes
    QueryPlan
  39. final def invalidateStatsCache(): Unit

    Permalink
    Definition Classes
    LogicalPlan
  40. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  41. def isStreaming: Boolean

    Permalink
    Definition Classes
    LogicalPlan
  42. def isTraceEnabled(): Boolean

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  43. def jsonFields: List[JField]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode
  44. def log: Logger

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  45. def logDebug(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  46. def logDebug(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  47. def logError(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  48. def logError(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  49. def logInfo(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  50. def logInfo(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  51. def logName: String

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  52. def logTrace(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  53. def logTrace(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  54. def logWarning(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  55. def logWarning(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  56. def makeCopy(newArgs: Array[AnyRef]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode
  57. def map[A](f: (LogicalPlan) ⇒ A): Seq[A]

    Permalink
    Definition Classes
    TreeNode
  58. def mapChildren(f: (LogicalPlan) ⇒ LogicalPlan): LogicalPlan

    Permalink
    Definition Classes
    TreeNode
  59. def mapExpressions(f: (Expression) ⇒ Expression): InsertIntoHiveTable.this.type

    Permalink
    Definition Classes
    QueryPlan
  60. def mapProductIterator[B](f: (Any) ⇒ B)(implicit arg0: ClassTag[B]): Array[B]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode
  61. def maxRows: Option[Long]

    Permalink
    Definition Classes
    LogicalPlan
  62. def missingInput: AttributeSet

    Permalink
    Definition Classes
    QueryPlan
  63. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  64. def newVersionExternalTempPath(path: Path, hadoopConf: Configuration, stagingDir: String): Path

    Permalink
  65. def nodeName: String

    Permalink
    Definition Classes
    TreeNode
  66. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef
  67. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef
  68. def numberedTreeString: String

    Permalink
    Definition Classes
    TreeNode
  69. def oldVersionExternalTempPath(path: Path, hadoopConf: Configuration, scratchDir: String): Path

    Permalink
  70. val origin: Origin

    Permalink
    Definition Classes
    TreeNode
  71. def otherCopyArgs: Seq[AnyRef]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode
  72. def output: Seq[Attribute]

    Permalink
    Definition Classes
    Command → QueryPlan
  73. def outputSet: AttributeSet

    Permalink
    Definition Classes
    QueryPlan
  74. val overwrite: Boolean

    Permalink

    overwrite existing table or partitions.

  75. def p(number: Int): LogicalPlan

    Permalink
    Definition Classes
    TreeNode
  76. val partition: Map[String, Option[String]]

    Permalink

    a map from the partition key to the partition value (optional).

    a map from the partition key to the partition value (optional). If the partition value is optional, dynamic partition insert will be performed. As an example, INSERT INTO tbl PARTITION (a=1, b=2) AS ... would have

    Map('a' -> Some('1'), 'b' -> Some('2'))

    and INSERT INTO tbl PARTITION (a=1, b) AS ... would have

    Map('a' -> Some('1'), 'b' -> None)

    .

  77. def preCanonicalized: LogicalPlan

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan
  78. def prettyJson: String

    Permalink
    Definition Classes
    TreeNode
  79. def printSchema(): Unit

    Permalink
    Definition Classes
    QueryPlan
  80. def producedAttributes: AttributeSet

    Permalink
    Definition Classes
    LeafNode → QueryPlan
  81. val query: LogicalPlan

    Permalink

    the logical plan representing data to write to.

  82. def references: AttributeSet

    Permalink
    Definition Classes
    QueryPlan
  83. def refresh(): Unit

    Permalink
    Definition Classes
    LogicalPlan
  84. def resolve(nameParts: Seq[String], input: Seq[Attribute], resolver: Resolver): Option[NamedExpression]

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan
  85. def resolve(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]

    Permalink
    Definition Classes
    LogicalPlan
  86. def resolve(schema: StructType, resolver: Resolver): Seq[Attribute]

    Permalink
    Definition Classes
    LogicalPlan
  87. def resolveChildren(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]

    Permalink
    Definition Classes
    LogicalPlan
  88. def resolveExpressions(r: PartialFunction[Expression, Expression]): LogicalPlan

    Permalink
    Definition Classes
    LogicalPlan
  89. def resolveOperators(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    LogicalPlan
  90. def resolveQuoted(name: String, resolver: Resolver): Option[NamedExpression]

    Permalink
    Definition Classes
    LogicalPlan
  91. lazy val resolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan
  92. def run(sparkSession: SparkSession): Seq[Row]

    Permalink

    Inserts all the rows in the table into Hive.

    Inserts all the rows in the table into Hive. Row objects are properly serialized with the org.apache.hadoop.hive.serde2.SerDe and the org.apache.hadoop.mapred.OutputFormat provided by the table definition.

    Definition Classes
    InsertIntoHiveTable → RunnableCommand
  93. final def sameResult(other: LogicalPlan): Boolean

    Permalink
    Definition Classes
    QueryPlan
  94. lazy val schema: StructType

    Permalink
    Definition Classes
    QueryPlan
  95. def schemaString: String

    Permalink
    Definition Classes
    QueryPlan
  96. final def semanticHash(): Int

    Permalink
    Definition Classes
    QueryPlan
  97. def simpleString: String

    Permalink
    Definition Classes
    QueryPlan → TreeNode
  98. def statePrefix: String

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan → QueryPlan
  99. final def stats(conf: SQLConf): Statistics

    Permalink
    Definition Classes
    LogicalPlan
  100. def stringArgs: Iterator[Any]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode
  101. def subqueries: Seq[LogicalPlan]

    Permalink
    Definition Classes
    QueryPlan
  102. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef
  103. val table: CatalogTable

    Permalink

    the metadata of the table.

  104. def toJSON: String

    Permalink
    Definition Classes
    TreeNode
  105. def toString(): String

    Permalink
    Definition Classes
    TreeNode → AnyRef → Any
  106. def transform(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode
  107. def transformAllExpressions(rule: PartialFunction[Expression, Expression]): InsertIntoHiveTable.this.type

    Permalink
    Definition Classes
    QueryPlan
  108. def transformDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode
  109. def transformExpressions(rule: PartialFunction[Expression, Expression]): InsertIntoHiveTable.this.type

    Permalink
    Definition Classes
    QueryPlan
  110. def transformExpressionsDown(rule: PartialFunction[Expression, Expression]): InsertIntoHiveTable.this.type

    Permalink
    Definition Classes
    QueryPlan
  111. def transformExpressionsUp(rule: PartialFunction[Expression, Expression]): InsertIntoHiveTable.this.type

    Permalink
    Definition Classes
    QueryPlan
  112. def transformUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode
  113. def treeString(verbose: Boolean, addSuffix: Boolean): String

    Permalink
    Definition Classes
    TreeNode
  114. def treeString: String

    Permalink
    Definition Classes
    TreeNode
  115. def validConstraints: Set[Expression]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan
  116. def verboseString: String

    Permalink
    Definition Classes
    QueryPlan → TreeNode
  117. def verboseStringWithSuffix: String

    Permalink
    Definition Classes
    LogicalPlan → TreeNode
  118. final def wait(): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  119. final def wait(arg0: Long, arg1: Int): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  120. final def wait(arg0: Long): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  121. def withNewChildren(newChildren: Seq[LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

Inherited from Serializable

Inherited from Serializable

Inherited from RunnableCommand

Inherited from Command

Inherited from LeafNode

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