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 !!
22 freelancere byder i gennemsnit $162 på dette job
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.