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 !!
20 freelancers estão ofertando em média $156 para esse trabalho
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.
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 .