Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to load the excel data into hive using python script?

How to load the excel data into hive using python script?

Contributor

I created a python script using excel data and want to load the excel data into hive using python script

3 REPLIES 3

Re: How to load the excel data into hive using python script?

Mentor

you can load data into hive straight from CSV, no need to programmatically read excel. @kavitha velaga Steps are here http://hortonworks.com/hadoop-tutorial/how-to-process-data-with-apache-hive/

Re: How to load the excel data into hive using python script?

Contributor

Thanks Artem. The link shows how to load the data into hive from Hive view, here I'm trying to load the excel data into using Python script from command line. Any advise?

Re: How to load the excel data into hive using python script?

Mentor

@kavitha velaga read further, there's a load example you can use. Here's a slightly different way of doing it in Hive as well. http://blog.ervits.com/2015/12/apache-hive-csv-serde-example.html

Don't have an account?
Coming from Hortonworks? Activate your account here