Hive/SQL queries for equivalent Excel transformations

Closed Posted 4 years ago Paid on delivery
Closed Paid on delivery

Write Hive/SQL queries which can be incorporated as Hive queries so that transformations done through excel can be automated.

All Create, Insert table statements need to be included.

Currently the data is being transformed manually and through excel formulas.

NOTE - 1) No updation is allowed in Hive, so use only Insert Overwrite.

2) Intake input data in Raw format (csv) and process/transform it through SQL queries.

3) Hive and Python is being taken care of, you need to be only good at SQL !!

SQL Python Hive Excel

Project ID: #20778170

About the project

20 proposals Remote project Active 4 years ago

20 freelancers are bidding on average $169 for this job

albertpopov46

Hi Dear I read your requirements carefully. I have rich experience with Python Django, Flask, selenium, Web Scrapy, software architecture and so on. You can see my good reviews for python projects. Please touch me. I w More

$140 USD in 7 days
(28 Reviews)
5.2
asjkim

Highly effective Data Scientist/Data Engiener with over 25 years of experience. I have extensive Spark experience both in PySpark and Scala also in MLLib. I checked your Scala code and should be able to convert it to P More

$250 USD in 7 days
(2 Reviews)
4.1
masterb325

- I have experience of working on Hive SQL for the similar in my working company. -Looking to bring the benefits of data analysis to your business, the company might have analytics already implemented but with the skil More

$140 USD in 3 days
(4 Reviews)
4.0
dineshrajputit

Hi, I have 8 years of experience and working on hadoop, spark, nosql, java, BI tools(tableau, powerbi), cloud(Amazon, Google, Microsoft Azure)... Done end to end data warehouse management projects on aws cloud with ha More

$277 USD in 5 days
(3 Reviews)
3.4
TechnicalGeeks

Hi, I am a bigdata developer and a module lead in reputed MNC.i an into the IT industry for more then 12 years. I have tonnes of experience in developing projects using Java,Apache Spark,Hive,Kafka,Scoop,Pig,Scala,aws More

$250 USD in 7 days
(1 Review)
1.7
InfoTechOneStop

Hey, we are a company based out of the United States and I believe that we can complete what you are asking in an efficient manner. Please reach back out to us and we are looking forward to working with you in the futu More

$166 USD in 14 days
(0 Reviews)
0.0
safervas

My main specialty is Oracle Developer. But we have 6 months experience with Spark and Hive. Update is suspicious operation. You should remember that Hive fully rewrights tables .

$140 USD in 2 days
(0 Reviews)
0.0
kavipadm

Hi, I have extensive experience with SQL. Please consider me for this project. Thanks and regards, Kavita

$140 USD in 7 days
(0 Reviews)
0.0
hasinib

Hi, Experience in oracle sql Will be able to complete your task if it is considering oracle sql. Over 7 years experience in working with oracle db

$150 USD in 7 days
(0 Reviews)
0.0
imaya1989

Experienced Senior Software Engineer with a demonstrated history of working in the hospital & health care industry. Skilled in SQL, Oracle Database, Requirements Analysis, Databases, and PL/SQL. Have a strong knowledge More

$90 USD in 7 days
(0 Reviews)
0.0
csrajja

Hello , I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like to make you an offer and some background so you can check my work out. However, I am new to freel More

$140 USD in 7 days
(0 Reviews)
0.0
dineshtak83

yes. I will do this project within given time period. Give me full details related to your project .

$160 USD in 5 days
(0 Reviews)
0.0
sa6o03

Hello, I have 3 years in it industry mainly on data transformation. I worked 2 years with hive so I sure I can do the job. Best Regards, Aleksandar Atanasov Relevant Skills and Experience I have experience with Hiv More

$166 USD in 4 days
(0 Reviews)
0.0
ramaband

I have already worked on such projects and currently working on the same kind of projects. I am very good at writing SQL's for complex data transformations as needed.

$150 USD in 5 days
(0 Reviews)
0.0
prabhatratnala

I have over 7 years experience in Hadoop technologies. I have worked with big MNC's from USA as well as India. I have both developer as well as architect experience and currently well equipped with Hortonworks and Clou More

$250 USD in 3 days
(0 Reviews)
0.0
nareshnaidu644

I have real time experience of 7 years in SQL and Hive. I worked in various projects where I written sql / hive queries to load the data.

$60 USD in 3 days
(0 Reviews)
0.0
Deepak03021

1. Cleans the input dataset 2. Populate these dataset in HDFS which is optional but recommended. We can use local files too to create Hive tables 3. Load data during the table creation through Hive shell entries. 4. I More

$180 USD in 10 days
(0 Reviews)
0.0