How to save DataFrame directly to Hive?

by

You can create an in-memory temporary table and store them in hive table using sqlContext.

Lets say your data frame is myDf. You can create one temporary table using,

myDf.createOrReplaceTempView("mytempTable")

Then you can use a simple hive statement to create table and dump the data from your temp table. 

sqlContext.sql("create table mytable as select * from mytempTable");

More Related Contents:

  1. Spark – load CSV file as DataFrame?
  2. How to define partitioning of DataFrame?
  3. Encoder error while trying to map dataframe row to updated row
  4. Spark Scala: How to convert Dataframe[vector] to DataFrame[f1:Double, …, fn: Double)]
  5. How to define schema for custom type in Spark SQL?
  6. How can I change column types in Spark SQL’s DataFrame?
  7. Spark unionAll multiple dataframes
  8. How can I pass extra parameters to UDFs in Spark SQL?
  9. SparkSQL: How to deal with null values in user defined function?
  10. How to split a dataframe into dataframes with same column values?
  11. How to aggregate values into collection after groupBy?
  12. Dropping a nested column from Spark DataFrame
  13. Spark Dataframe :How to add a index Column : Aka Distributed Data Index
  14. Spark / Scala: forward fill with last observation
  15. Spark DataFrame: does groupBy after orderBy maintain that order?
  16. Filling gaps in timeseries Spark
  17. Spark UDAF with ArrayType as bufferSchema performance issues
  18. Apache Spark how to append new column from list/array to Spark dataframe
  19. How to use COGROUP for large datasets
  20. What are possible reasons for receiving TimeoutException: Futures timed out after [n seconds] when working with Spark [duplicate]
  21. Why does join fail with “java.util.concurrent.TimeoutException: Futures timed out after [300 seconds]”?
  22. Create new Dataframe with empty/null field values
  23. Perform a typed join in Scala with Spark Datasets
  24. DataFrame-ified zipWithIndex
  25. Spark: Add column to dataframe conditionally
  26. Apache Spark, add an “CASE WHEN … ELSE …” calculated column to an existing DataFrame
  27. Calculate Cosine Similarity Spark Dataframe
  28. Why is join not possible after show operator?
  29. How to create DataFrame from Scala’s List of Iterables?
  30. How to create a Dataset of Maps?

Leave a Comment