Suljettu

Hive/SQL queries for equivalent Excel transformations

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 !!

Taidot: SQL, Python, Hive, Excel

Näytä lisää: adonet sql large data excel export, streamlining sql queries, sql 2005 import excel, table sql queries join, convert sql server bak excel, java programs read excel sheets write mysql database, write sql queries customer order tables, excel vba write csv cvs, wordpress custom sql queries, excel macro write xml file, excel vba write xml document file, money optimizing sql queries, excel file write mysql database jsp, sql queries check total bulk sms day, write sql queries oracle 10g, excel vba write sql table row, write sql queries, Write some Sql Queries

Tietoa työnantajasta:
( 0 arvostelua ) PATIALA, India

Projektin tunnus: #20778170

22 freelanceria on tarjonnut keskimäärin 162$ tähän työhön

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 Lisää

$140 USD 7 päivässä
(21 arvostelua)
5.0
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 Lisää

$140 USD 3 päivässä
(3 arvostelua)
3.9
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 Lisää

$250 USD 7 päivässä
(2 arvostelua)
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 Lisää

$277 USD 5 päivässä
(1 arvostelu)
1.1
randomnut

I can do data processing, and have experience with PostgreSQL and Excel from my professional work. I have used coalescing, window functions, and complicated joins. I used LibreOffice Calc (analogous to Excel, but free Lisää

$140 USD 7 päivässä
(2 arvostelua)
1.3
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 Lisää

$140 USD 7 päivässä
(0 arvostelua)
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 Lisää

$180 USD 10 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
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 Lisää

$250 USD 3 päivässä
(0 arvostelua)
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 5 päivässä
(0 arvostelua)
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 Lisää

$166 USD 4 päivässä
(0 arvostelua)
0.0
dineshtak83

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

$160 USD 5 päivässä
(0 arvostelua)
0.0
RPFREE

I work as a full time IT professional on states and i work with HIVE/PYTHON/SQL [login to view URL] i can finish your job in a day

$277 USD 1 päivässä
(0 arvostelua)
0.0
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 Lisää

$250 USD 7 päivässä
(0 arvostelua)
0.0
$155 USD 3 päivässä
(0 arvostelua)
0.0
AiAge888

Full Time web design/website developer for 5 years. Dear. I am a website design and SQL expert to have many experience. I have read your post details. I know you want and can start this task immediately. If you start w Lisää

$50 USD 7 päivässä
(0 arvostelua)
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 Lisää

$90 USD 7 päivässä
(0 arvostelua)
0.0
manojmo

Hi, I have 20+ years of experience, mostly on java, web, and database technologies. I have also worked on PHP, Python, spark, some ML, and dabbled in many others. My linkedin profile : [login to view URL] Lisää

$100 USD 4 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
0.0
kavipadm

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

$140 USD 7 päivässä
(0 arvostelua)
0.0