Hive/SQL queries for equivalent Excel transformations
$30-250 USD
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 !!
Project ID: #20778170
About the project
20 freelancers are bidding on average $169 for this job
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
- 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
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
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
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
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 .
Hi, I have extensive experience with SQL. Please consider me for this project. Thanks and regards, Kavita
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
yes. I will do this project within given time period. Give me full details related to your project .
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.
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
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.
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