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, outputColumnNames: Seq[String]) extends LogicalPlan with SaveAsHiveFile 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, SaveAsHiveFile, DataWritingCommand, Command, LogicalPlan, Logging, QueryPlanConstraints, ConstraintHelper, LogicalPlanStats, AnalysisHelper, QueryPlan[LogicalPlan], TreeNode[LogicalPlan], Product, Equals, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. InsertIntoHiveTable
  2. Serializable
  3. Serializable
  4. SaveAsHiveFile
  5. DataWritingCommand
  6. Command
  7. LogicalPlan
  8. Logging
  9. QueryPlanConstraints
  10. ConstraintHelper
  11. LogicalPlanStats
  12. AnalysisHelper
  13. QueryPlan
  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 InsertIntoHiveTable(table: CatalogTable, partition: Map[String, Option[String]], query: LogicalPlan, overwrite: Boolean, ifPartitionNotExists: Boolean, outputColumnNames: Seq[String])

    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
    AnalysisHelper
  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. def assertNotAnalysisRule(): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    AnalysisHelper
  11. def basicWriteJobStatsTracker(hadoopConf: Configuration): BasicWriteJobStatsTracker

    Permalink
    Definition Classes
    DataWritingCommand
  12. final lazy val canonicalized: LogicalPlan

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

    Permalink
    Definition Classes
    DataWritingCommand → Command → TreeNode
  14. def childrenResolved: Boolean

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

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

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

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

    Permalink
    Definition Classes
    TreeNode
  19. def conf: SQLConf

    Permalink
    Definition Classes
    QueryPlan
  20. lazy val constraints: ExpressionSet

    Permalink
    Definition Classes
    QueryPlanConstraints
  21. def constructIsNotNullConstraints(constraints: Set[Expression], output: Seq[Attribute]): Set[Expression]

    Permalink
    Definition Classes
    ConstraintHelper
  22. lazy val containsChild: Set[TreeNode[_]]

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

    Permalink
    Definition Classes
    SaveAsHiveFile
  24. def deleteExternalTmpPath(hadoopConf: Configuration): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    SaveAsHiveFile
  25. def doCanonicalize(): LogicalPlan

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan
  26. final def eq(arg0: AnyRef): Boolean

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

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

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

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

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

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

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

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

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

    Permalink
    Definition Classes
    AnyRef → Any
  36. def getExternalTmpPath(sparkSession: SparkSession, hadoopConf: Configuration, path: Path): Path

    Permalink
    Attributes
    protected
    Definition Classes
    SaveAsHiveFile
  37. def hashCode(): Int

    Permalink
    Definition Classes
    TreeNode → AnyRef → Any
  38. 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.

  39. def inferAdditionalConstraints(constraints: Set[Expression]): Set[Expression]

    Permalink
    Definition Classes
    ConstraintHelper
  40. def initializeLogIfNecessary(isInterpreter: Boolean, silent: Boolean = false): Boolean

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  41. def initializeLogIfNecessary(isInterpreter: Boolean): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging
  42. def innerChildren: Seq[QueryPlan[_]]

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

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

    Permalink
    Definition Classes
    LogicalPlanStats
  45. def isCanonicalizedPlan: Boolean

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan
  46. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  47. def isStreaming: Boolean

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Permalink
    Definition Classes
    LogicalPlan
  68. def maxRowsPerPartition: Option[Long]

    Permalink
    Definition Classes
    LogicalPlan
  69. lazy val metrics: Map[String, SQLMetric]

    Permalink
    Definition Classes
    DataWritingCommand
  70. def missingInput: AttributeSet

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

    Permalink
    Definition Classes
    AnyRef
  72. def nodeName: String

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

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

    Permalink
    Definition Classes
    AnyRef
  75. def numberedTreeString: String

    Permalink
    Definition Classes
    TreeNode
  76. val origin: Origin

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

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

    Permalink
    Definition Classes
    Command → QueryPlan
  79. val outputColumnNames: Seq[String]

    Permalink
    Definition Classes
    InsertIntoHiveTable → DataWritingCommand
  80. def outputColumns: Seq[Attribute]

    Permalink
    Definition Classes
    DataWritingCommand
  81. def outputOrdering: Seq[SortOrder]

    Permalink
    Definition Classes
    LogicalPlan
  82. def outputSet: AttributeSet

    Permalink
    Definition Classes
    QueryPlan
  83. val overwrite: Boolean

    Permalink

    overwrite existing table or partitions.

  84. def p(number: Int): LogicalPlan

    Permalink
    Definition Classes
    TreeNode
  85. 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)

    .

  86. def prettyJson: String

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

    Permalink
    Definition Classes
    QueryPlan
  88. def producedAttributes: AttributeSet

    Permalink
    Definition Classes
    QueryPlan
  89. val query: LogicalPlan

    Permalink

    the logical plan representing data to write to.

    the logical plan representing data to write to.

    Definition Classes
    InsertIntoHiveTable → DataWritingCommand
  90. def references: AttributeSet

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

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

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

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

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

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

    Permalink
    Definition Classes
    AnalysisHelper
  97. def resolveOperatorsDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    AnalysisHelper
  98. def resolveOperatorsUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

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

    Permalink
    Definition Classes
    LogicalPlan
  100. lazy val resolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan
  101. def run(sparkSession: SparkSession, child: SparkPlan): 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 → DataWritingCommand
  102. final def sameResult(other: LogicalPlan): Boolean

    Permalink
    Definition Classes
    QueryPlan
  103. def saveAsHiveFile(sparkSession: SparkSession, plan: SparkPlan, hadoopConf: Configuration, fileSinkConf: ShimFileSinkDesc, outputLocation: String, customPartitionLocations: Map[TablePartitionSpec, String] = Map.empty, partitionAttributes: Seq[Attribute] = Nil): Set[String]

    Permalink
    Attributes
    protected
    Definition Classes
    SaveAsHiveFile
  104. lazy val schema: StructType

    Permalink
    Definition Classes
    QueryPlan
  105. def schemaString: String

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

    Permalink
    Definition Classes
    QueryPlan
  107. def simpleString: String

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

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan → QueryPlan
  109. def stats: Statistics

    Permalink
    Definition Classes
    LogicalPlanStats
  110. var statsCache: Option[Statistics]

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlanStats
  111. def stringArgs: Iterator[Any]

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

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

    Permalink
    Definition Classes
    AnyRef
  114. val table: CatalogTable

    Permalink

    the metadata of the table.

  115. def toJSON: String

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

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

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

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

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

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

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

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

    Permalink
    Definition Classes
    AnalysisHelper → TreeNode
  124. def treeString(verbose: Boolean, addSuffix: Boolean): String

    Permalink
    Definition Classes
    TreeNode
  125. def treeString: String

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

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlanConstraints
  127. def verboseString: String

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

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

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

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

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

    Permalink
    Definition Classes
    TreeNode

Inherited from Serializable

Inherited from Serializable

Inherited from SaveAsHiveFile

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 TreeNode[LogicalPlan]

Inherited from Product

Inherited from Equals

Inherited from AnyRef

Inherited from Any

Ungrouped