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, LogicalPlanStats, 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. LogicalPlanStats
  11. QueryPlan
  12. TreeNode
  13. Product
  14. Equals
  15. AnyRef
  16. 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 apply(number: Int): TreeNode[_]

    Permalink
    Definition Classes
    TreeNode
  6. def argString: String

    Permalink
    Definition Classes
    TreeNode
  7. def asCode: String

    Permalink
    Definition Classes
    TreeNode
  8. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  9. def basicWriteJobStatsTracker(hadoopConf: Configuration): BasicWriteJobStatsTracker

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

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

    Permalink
    Definition Classes
    DataWritingCommand → Command → 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 conf: SQLConf

    Permalink
    Definition Classes
    QueryPlan
  18. lazy val constraints: ExpressionSet

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Permalink
    Attributes
    protected
    Definition Classes
    SaveAsHiveFile
  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, silent: Boolean = false): Boolean

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

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

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

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

    Permalink
    Definition Classes
    LogicalPlanStats
  41. def isCanonicalizedPlan: Boolean

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

    Permalink
    Definition Classes
    Any
  43. def isStreaming: Boolean

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Permalink
    Definition Classes
    DataWritingCommand
  66. def missingInput: AttributeSet

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

    Permalink
    Definition Classes
    AnyRef
  68. def nodeName: String

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

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

    Permalink
    Definition Classes
    AnyRef
  71. def numberedTreeString: String

    Permalink
    Definition Classes
    TreeNode
  72. val origin: Origin

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

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

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

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

    Permalink
    Definition Classes
    DataWritingCommand
  77. def outputSet: AttributeSet

    Permalink
    Definition Classes
    QueryPlan
  78. val overwrite: Boolean

    Permalink

    overwrite existing table or partitions.

  79. def p(number: Int): LogicalPlan

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

    .

  81. def prettyJson: String

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

    Permalink
    Definition Classes
    QueryPlan
  83. def producedAttributes: AttributeSet

    Permalink
    Definition Classes
    QueryPlan
  84. val query: LogicalPlan

    Permalink

    the logical plan representing data to write to.

    the logical plan representing data to write to.

    Definition Classes
    InsertIntoHiveTable → DataWritingCommand
  85. def references: AttributeSet

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

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

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

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

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

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

    Permalink
    Definition Classes
    LogicalPlan
  92. lazy val resolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan
  93. 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
  94. final def sameResult(other: LogicalPlan): Boolean

    Permalink
    Definition Classes
    QueryPlan
  95. 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
  96. lazy val schema: StructType

    Permalink
    Definition Classes
    QueryPlan
  97. def schemaString: String

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

    Permalink
    Definition Classes
    QueryPlan
  99. def simpleString: String

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

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

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

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

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

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

    Permalink
    Definition Classes
    AnyRef
  106. val table: CatalogTable

    Permalink

    the metadata of the table.

  107. def toJSON: String

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

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

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

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

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

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

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

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

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

    Permalink
    Definition Classes
    TreeNode
  117. def treeString: String

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

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

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

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

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

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

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  124. 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 LogicalPlanStats

Inherited from QueryPlan[LogicalPlan]

Inherited from TreeNode[LogicalPlan]

Inherited from Product

Inherited from Equals

Inherited from AnyRef

Inherited from Any

Ungrouped