0

I need to load data in already created hive table in orc format.

ie I need to read data from excel sheet, create data frame and then load it into hive tables in orc format.

baitmbarek
  • 2,440
  • 4
  • 18
  • 26
Chetan Mane
  • 9
  • 1
  • Does this answer your question? [How to construct Dataframe from a Excel (xls,xlsx) file in Scala Spark?](https://stackoverflow.com/questions/44196741/how-to-construct-dataframe-from-a-excel-xls-xlsx-file-in-scala-spark) – OneCricketeer Jan 18 '20 at 04:26
  • I have a already created table and the data is in orc format. now i have new excel sheet from which I have to update some values of already created hive table. Please suggest – Chetan Mane Jan 20 '20 at 04:22
  • Okay, fine. Why can't you use the library mentioned there? SparkSQL can run any Hive statement – OneCricketeer Jan 20 '20 at 13:23

1 Answers1

0

There are two steps involved:

  • read the excel file[1]

  • write it into the Hive table [2]

The answers related to this:

  1. Reading Excel file with Scala

  2. How to save DataFrame directly to Hive?

Istvan
  • 7,500
  • 9
  • 59
  • 109